Description

    Steps to reproduce issue:

    1. Import the attached 7.0.10.6 database into DB2 11.1
    2. Upgrade database
      • Expected result: Upgrade executes successfully without SQL syntax errors
      • Actual results: SQL syntax errors are thrown:
        2018-12-12 08:07:24.821 WARN  [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskForm;
        
        WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskForm;
        
        2018-12-12 08:07:25.022 WARN  [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskFormInstance;
        
        WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoTaskFormInstance;
        
        2018-12-12 08:07:25.220 WARN  [main][BaseDB:487] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoDefinitionVersion;
        
        WARN - DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=exists;drop table if ;NPS_DOUBLE_DOT, DRIVER=4.24.92: drop table if exists KaleoDefinitionVersion;
        
        
    3. Start up portal
      • Expected result: No SQL syntax errors are thrown
      • Actual result: SQL syntax errors are thrown
        2018-12-12 08:07:31.810 WARN  [main][UpgradeProcess:447] Attempting to upgrade table LayoutSetPrototype by recreating the table due to: DB2 SQL Error: SQLCODE=-190, SQLSTATE=42837, SQLERRMC=ROOT.LAYOUTSETPROTOTYPE;NAME, DRIVER=4.24.92
        WARN - Attempting to upgrade table LayoutSetPrototype by recreating the table due to: DB2 SQL Error: SQLCODE=-190, SQLSTATE=42837, SQLERRMC=ROOT.LAYOUTSETPROTOTYPE;NAME, DRIVER=4.24.92
        2018-12-12 08:07:31.810 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype
        INFO - Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype
        2018-12-12 08:07:31.811 INFO  [main][Table:168] Starting backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp
        INFO - Starting backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp
        2018-12-12 08:07:31.814 INFO  [main][Table:204] Finished backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp in 3 ms
        INFO - Finished backup of LayoutSetPrototype to /tmp/temp-db-LayoutSetPrototype-4096692390939125030.tmp in 3 ms
        2018-12-12 08:07:32.156 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype in 346 ms
        INFO - Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#LayoutSetPrototype in 346 ms
        2018-12-12 08:07:32.157 WARN  [main][UpgradeProcess:466] Successfully recreated and upgraded table LayoutSetPrototype
        WARN - Successfully recreated and upgraded table LayoutSetPrototype
        

    Reproduced on:
    Tomcat 9.0.10 + DB2 11.1
    Portal master GIT ID: 17920c8d2d94e155e34b593a5389e49b8ae34e57

      Attachments

        Activity

          People

          Assignee:
          support-lep@liferay.com SE Support
          Reporter:
          anthony.chu Anthony Chu
          Participants of an Issue:
          Recent user:
          Marta Elicegui
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Days since last comment:
            2 years, 44 weeks, 5 days ago

              Packages

              Version Package