-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 6.2.X EE, 7.0.0 M3
-
Component/s: Workflow, Workflow > API, Workflow > API > Kaleo Engine
-
Labels:None
-
Branch Version/s:6.2.x
-
Backported to Branch:Committed
-
Story Points:1.75
-
Fix Priority:3
-
Databases:DB2 10.1, DB2 9.7
-
Git Pull Request:
Description
Unable to add a new Kaleo workflow definition after upgrading from 6.1 with DB2 9.7
Prepare a DB2 blank database
Start a clean 6.1 GA1 bundle
Login as administrator
Deploy Kaleo plugins
kaleo-upgrade-hook-6.1.10.1-ee-ga1-20130301094057839.war
kaleo-web-6.1.10.4-ee-ga1-20130301094057839.war
Go to Control Panel > Update Manager to confirm they are deployed
Confirm that KaleoTaskAssignment table has no column named assigneeScriptRequiredContexts
Shutdown Liferay
Prepare a 6.2 GA1 clean bundle
Apply liferay-hotfix-3290-6210.zip
Start 6.2 with upgrade parameters
passwords.encryption.algorithm.legacy=SHA
verify.frequency=-1
Deploy Kaleo Workflow (In my case, I reproduced it without deploying it as well)
Kaleo Workflow EE.lpkg (kaleo-web-6.2.10.2.war)
Confirm that the column assigneeScriptRequiredContexts still does not exist
Login as administrator
Go to Control Panel > Workflow
Click "Add New Definition"
Note that layout is odd, no Save or Publish button at the bottom
Type a Name and Title and click Add Draft
Click Publish
Confirm that SqlSyntaxErrorException are thrown on console
Note: Column assigneeScriptRequiredContexts exists when starting from a clean 6.2 bundle
Expected behavior: The definition is saved without error
Actual behavior: A SQLGrammarException occurs
- Testing discovered
-
LPS-52770 Upgrade from 6.1 to 7.0 throws UpgradeException on DB2
- Closed