Bug 780989 (SOA-3465)

Summary: Migration scripts are missing
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Pechanec <jpechane>
Component: DistributionAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.2.0.ER4   
Target Milestone: ---   
Target Release: 5.2.0.CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3465
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-14 09:28:28 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jiri Pechanec 2011-10-07 08:25:37 UTC
project_key: SOA

There is at least one db change in 5.2. For this purpose we should provide migration scripts for the current customers.

Comment 1 Jiri Pechanec 2011-10-07 08:26:08 UTC
Link: Added: This issue is related to SOA-3214


Comment 2 Julian Coleman 2011-10-17 15:39:31 UTC
Resolved with revision 10321 of:
  assembly/soa.zip.xml
  resources/soa-p/create-jbpm-index.txt

Commit message:
  SOA-3465
  Add migration script for SOA-3214.


Comment 3 Julian Coleman 2011-10-17 15:39:31 UTC
Release Notes Docs Status: Added: Not Yet Documented
Release Notes Text: Added: Proposed release notes text, for the "Upgrading to SOA-P 5.2.0 from an older 5.x release" section:

The upgrade from jBPM 3.2.11.SP2 adds an additional index on the database table "JBPM_JOB". This index can be created with the following SQL statement:

  create index IDX_JOB_DUEDATE on JBPM_JOB (DUEDATE_);

This SQL statement is also provided in the `create-jbpm-index.txt' file which is included in the distribution.

Note, that jBPM will run without this additional index, but the resolution for JIRA SOA-3214 will not be available in that case.


Comment 4 David Le Sage 2011-11-09 02:54:54 UTC
Release Notes Docs Status: Removed: Not Yet Documented Added: Not Required
Writer: Added: dlesage


Comment 5 Jiri Pechanec 2011-11-14 09:28:28 UTC
Verified in CR1