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

SQL syntax errors on DB2 when upgrading from 6.2

    Details

      Description

      Steps to reproduce issue:

      1. Import the attached 6.2.10.21 database into DB2
      2. Upgrade database
      3. Start portal

      Expected result: Bundle starts up successfully with no exceptions
      Actual result; Warnings are thrown regarding sql syntax errors:

      2019-03-21 04:12:24.536 WARN  [default-3][BaseDB:536] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXISTS;DROP TABLE IF ;NPS_DOUBLE_DOT, DRIVER=4.24.92: DROP_TABLE_IF_EXISTS(AssetTagProperty);
      2019-03-21 04:12:25.588 WARN  [default-2][BaseDB:536] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXISTS;DROP TABLE IF ;NPS_DOUBLE_DOT, DRIVER=4.24.92: DROP_TABLE_IF_EXISTS(CyrusUser);
      2019-03-21 04:12:25.589 WARN  [default-2][BaseDB:536] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXISTS;DROP TABLE IF ;NPS_DOUBLE_DOT, DRIVER=4.24.92: DROP_TABLE_IF_EXISTS(CyrusVirtual);
      

      Reproduced on:
      Tomcat 9.0.10 + DB2 11.1
      Portal master GIT ID: 0a3d21e3025b39246f76fa88067a8087974e8000

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                anthony.chu Anthony Chu
                Reporter:
                anthony.chu Anthony Chu
                Participants of an Issue:
                Recent user:
                Brian Wulbern
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 24 weeks, 3 days ago

                  Packages

                  Version Package
                  Master