Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-52115

Unable to add a new Kaleo workflow definition after upgrading from 6.1 with DB2

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 9 weeks, 2 days ago

                  Packages

                  Version Package
                  6.2.X EE
                  7.0.0 M4