Hide Forgot
Affects: Release Notes Date of First Response: 2009-04-06 16:51:34 project_key: SOA The scripts must be present to ensure that there won't be two kinds of db schemas for support 1) Clean CP isnatllation containing indices 2) GA->CP installation without indices The update should be either automatic or there must be documentted the requirement to run update scripts as part of CP installation process
Fixed with revision 2906 (4.3 branch) of: build-tools/resource/create-jbpm-indexes.txt commit message: SOA-1270 Add script containing SQL statements which add new jBPM indexes, required for upgrade from GA. and with revision 2907 of: build-tools/builders/eap/build.xml build-tools/builders/jbpm/build.xml commit message: SOA-1270 Copy create-jbpm-indexes.txt to top-level of SOA and jBPM distributions.
Proposed release notes text, for the "Upgrading from 4.3.GA to 4.3.CP01" section: The upgrade from jBPM 3.2.2 to 3.2.5 requires the creation of additional indexes on the database tables. These indexes can be created with the following SQL statements: create index IDX_ACTION_REFACT on JBPM_ACTION (REFERENCEDACTION_); create index IDX_CRTETIMERACT_TA on JBPM_ACTION (TIMERACTION_); create index IDX_JOB_NODE on JBPM_JOB (NODE_); create index IDX_JOB_ACTION on JBPM_JOB (ACTION_); create index IDX_LOG_NEWBYTES on JBPM_LOG (NEWBYTEARRAY_); create index IDX_LOG_NODE on JBPM_LOG (NODE_); create index IDX_LOG_TASKINST on JBPM_LOG (TASKINSTANCE_); create index IDX_LOG_TRANSITION on JBPM_LOG (TRANSITION_); create index IDX_LOG_DESTNODE on JBPM_LOG (DESTINATIONNODE_); create index IDX_LOG_CHILDTOKEN on JBPM_LOG (CHILD_); create index IDX_LOG_TOKEN on JBPM_LOG (TOKEN_); create index IDX_LOG_SWIMINST on JBPM_LOG (SWIMLANEINSTANCE_); create index IDX_LOG_PARENT on JBPM_LOG (PARENT_); create index IDX_LOG_VARINST on JBPM_LOG (VARIABLEINSTANCE_); create index IDX_LOG_ACTION on JBPM_LOG (ACTION_); create index IDX_LOG_SOURCENODE on JBPM_LOG (SOURCENODE_); create index IDX_LOG_OLDBYTES on JBPM_LOG (OLDBYTEARRAY_); create index IDX_TSKDEF_START on JBPM_MODULEDEFINITION (STARTTASK_); create index IDX_TASKMGTINST_TMD on JBPM_MODULEINSTANCE (TASKMGMTDEFINITION_); create index IDX_NODE_SCRIPT on JBPM_NODE (SCRIPT_); create index IDX_DECISION_DELEG on JBPM_NODE (DECISIONDELEGATION); create index IDX_SWL_TSKMGMTDEF on JBPM_SWIMLANE (TASKMGMTDEFINITION_); create index IDX_SWL_ASSDEL on JBPM_SWIMLANE (ASSIGNMENTDELEGATION_); create index IDX_SWIMLANEINST_TM on JBPM_SWIMLANEINSTANCE (TASKMGMTINSTANCE_); create index IDX_TASK_STARTST on JBPM_TASK (STARTSTATE_); create index IDX_TASK_SWIMLANE on JBPM_TASK (SWIMLANE_); create index IDX_TSK_TSKCTRL on JBPM_TASK (TASKCONTROLLER_); create index IDX_TASK_ASSDEL on JBPM_TASK (ASSIGNMENTDELEGATION_); create index IDX_TSKCTRL_DELEG on JBPM_TASKCONTROLLER (TASKCONTROLLERDELEGATION_); create index IDX_BYTEINST_ARRAY on JBPM_VARIABLEINSTANCE (BYTEARRAYVALUE_); These SQL statements are also provided in the `create-jbpm-indexes.txt' file which is included in the jboss-as, jboss-esb, and jbpm-jpdl directories of the binary distributions. See JIRA issues SOA-1254 and JBPM-2094 for more information. This note also applies to the jBPM framework distribution, apart from the difference that the text file is "included in the top-level of the binary distribution".
Affects: Added: [Release Notes]
added to release notes in known issues and upgrading section
The information is there - but not the SOA-1270 JIRA number... https://svn.devel.redhat.com/repos/jboss-soa/branches/4.3/build-tools/docs/esb/ ================= 10.2. New jBPM database indexes must be created when upgrading When upgrading to the JBoss Enterprise SOA Platform 4.3.CP01 there are several new database indexes that must be manually created in the jBPM database. The SQL statements to do this are in the file create-jbpm-indexes.txt which can be found in both the jbpm-jpdl and jboss-as (jboss-esb in the standalone distribution) directories of the SOA Platform server . You need to run these commands on your jBPM database after upgrading your SOA Platform install. For reference the SQL commands are included here. create index IDX_ACTION_REFACT on JBPM_ACTION (REFERENCEDACTION_); create index IDX_CRTETIMERACT_TA on JBPM_ACTION (TIMERACTION_); create index IDX_JOB_NODE on JBPM_JOB (NODE_); create index IDX_JOB_ACTION on JBPM_JOB (ACTION_); create index IDX_LOG_NEWBYTES on JBPM_LOG (NEWBYTEARRAY_); create index IDX_LOG_NODE on JBPM_LOG (NODE_); create index IDX_LOG_TASKINST on JBPM_LOG (TASKINSTANCE_); create index IDX_LOG_TRANSITION on JBPM_LOG (TRANSITION_); create index IDX_LOG_DESTNODE on JBPM_LOG (DESTINATIONNODE_); create index IDX_LOG_CHILDTOKEN on JBPM_LOG (CHILD_); create index IDX_LOG_TOKEN on JBPM_LOG (TOKEN_); create index IDX_LOG_SWIMINST on JBPM_LOG (SWIMLANEINSTANCE_); create index IDX_LOG_PARENT on JBPM_LOG (PARENT_); create index IDX_LOG_VARINST on JBPM_LOG (VARIABLEINSTANCE_); create index IDX_LOG_ACTION on JBPM_LOG (ACTION_); create index IDX_LOG_SOURCENODE on JBPM_LOG (SOURCENODE_); create index IDX_LOG_OLDBYTES on JBPM_LOG (OLDBYTEARRAY_); create index IDX_TSKDEF_START on JBPM_MODULEDEFINITION (STARTTASK_); create index IDX_TASKMGTINST_TMD on JBPM_MODULEINSTANCE (TASKMGMTDEFINITION_); create index IDX_NODE_SCRIPT on JBPM_NODE (SCRIPT_); create index IDX_DECISION_DELEG on JBPM_NODE (DECISIONDELEGATION); create index IDX_SWL_TSKMGMTDEF on JBPM_SWIMLANE (TASKMGMTDEFINITION_); create index IDX_SWL_ASSDEL on JBPM_SWIMLANE (ASSIGNMENTDELEGATION_); create index IDX_SWIMLANEINST_TM on JBPM_SWIMLANEINSTANCE (TASKMGMTINSTANCE_); create index IDX_TASK_STARTST on JBPM_TASK (STARTSTATE_); create index IDX_TASK_SWIMLANE on JBPM_TASK (SWIMLANE_); create index IDX_TSK_TSKCTRL on JBPM_TASK (TASKCONTROLLER_); create index IDX_TASK_ASSDEL on JBPM_TASK (ASSIGNMENTDELEGATION_); create index IDX_TSKCTRL_DELEG on JBPM_TASKCONTROLLER (TASKCONTROLLERDELEGATION_); create index IDX_BYTEINST_ARRAY on JBPM_VARIABLEINSTANCE (BYTEARRAYVALUE_); 10.3. juddi-service.sar has been removed
It's a small change - but we should include this text for all issues: Additional information: https://jira.jboss.org/jira/browse/SOA-NNNN
Added "additional information" link
Verified in the release notes in the CR7b docs zip.
Link: Added: This issue related SOA-1303
Link: Added: This issue related SOA-1330
Link: Removed: This issue related SOA-1303