Bug 778820 (SOA-1270)

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