DB2 SQL syntax error on upgrade

• Type: Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: None
• Component/s: Database Upgrade Framework, Environments > Databases
• Labels:
  • QA-AUTOMATION
• Fix Priority: 2
• Databases:
  DB2 11.1
• QA Test Name:
  • LocalFile.CPDocumentsandmedia#EditDocument
  • LocalFile.OrganizationUpgrade#AddOrganizationAfterUpgrade7110
  • LocalFile.OrganizationUpgrade#AddUserandSuborganizationAfterUpgrade7110
  • LocalFile.UserUpgrade#ResetTestUserPasswordAfterUpgrade7110
  • LocalFile.UserUpgrade#ViewAndEditUserAfterUpgrade7110
• QA Test Score: 25

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