Bug 1260377

Summary:	DB upgrade script "jbpm-6.1-to-6.2.sql" does not contain alter statement for ContextMappingInfo.owner_id column
Product:	[Retired] JBoss BPMS Platform 6	Reporter:	Musharraf Hussain <mhussain>
Component:	jBPM Core	Assignee:	Alessandro Lazarotti <alazarot>
Status:	CLOSED EOL	QA Contact:	Tibor Zimanyi <tzimanyi>
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	6.1.0	CC:	alazarot, kverlaen
Target Milestone:	ER5
Target Release:	6.2.0
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2020-03-27 20:03:15 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:
Embargoed:
Bug Depends On:	1235091, 1273622
Bug Blocks:

Description Musharraf Hussain 2015-09-06 09:48:49 UTC

Description of problem:
- The currently available "jbpm-6.1-to-6.2.sql" and "jbpm-6.0-to-6.1.sql" DB upgrade scripts [1][2] do not contain the necessary "ALTER" statement to update an existing database schema with the newly added "owner_id" column from "ContextMappingInfo" table, introduced in jBPM6.1 . 
- We already ship these scripts with BPMS 6.1.0 source code but they are missing the necessary SQL statement to allow customers to manually update an existing "ContextMappingInfo" table from BPMS 6.0.3 to be upgraded to be compatible with BPMS 6.1.0 updated schema.

[1] ./jbpm-6.2.0.Final-redhat-4/jbpm-installer/db/upgrade-scripts/jbpm-6.1-to-6.2.sql
[2] ./jbpm-6.2.0.Final-redhat-4/jbpm-installer/db/upgrade-scripts/jbpm-6.0-to-6.1.sql

Version-Release number of selected component (if applicable):
- BPMS 6.1.0

How reproducible:
- Always

Steps to Reproduce:
1. Check the SQL scripts from BPMS 6.1.0 source code as shown above.
2.
3.

Actual results:
- Scripts missing ALTER statements for ContextMappingInfo.owner_id table column.

Expected results:
- The necessary SQL statement should be there for ContextMappingInfo.owner_id table column.

Additional info:
- Nothing

Comment 3 Maciej Swiderski 2015-10-16 13:32:31 UTC

this is included in 6.0 to 6.1 upgrade script, see [1]

please note that these versions are referring to community versions and thus for product they need to be merged accordingly to what version of community given product version includes

[1]https://github.com/droolsjbpm/jbpm/blob/6.3.x/jbpm-installer/db/upgrade-scripts/oracle/jbpm-6.0-to-6.1.sql#L2

Comment 4 JBoss JIRA Server 2015-11-02 12:32:18 UTC

Maciej Swiderski <swiderski.maciej> updated the status of jira JBPM-4760 to Resolved

Comment 5 Tibor Zimanyi 2015-11-03 14:09:13 UTC

Verified in 6.2.0.ER5. The alter statement is there in bpms-6.0-to-6.1.sql script provided in supplementary tools.