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

SQL syntax errors when upgrading from 7.0.10.6

    Details

      Description

      Steps to reproduce issue:

      1. Import attached 7.0.10.6 database into DB2 11.1
      2. Upgrade database
      3. Start portal

      Expected result: Portal starts with no warnings
      Actual result: Portal starts with sql syntax warnings:

      2019-03-21 04:13:51.198 WARN  [main][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(KaleoTaskForm);
      
      2019-03-21 04:13:51.356 WARN  [main][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(KaleoTaskFormInstance);
      
      2019-03-21 04:13:51.550 WARN  [main][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(KaleoDefinitionVersion);
      

      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:
              Jason Pince
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 26 weeks, 2 days ago

                  Packages

                  Version Package
                  7.2.10 DXP FP1
                  7.2.1 CE GA2
                  7.2.X
                  7.3.10 DXP GA1
                  Master