SQL syntax errors on DB2 when upgrading from 6.2

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: Master
• Component/s: Environments > Databases
• Labels:
  • QA-AUTOMATION
  • backend_test
  • upgrades
• Fix Priority: 3
• Databases:
  DB2 11.1
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/70914
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621015
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621021
• QA Test Score: 10

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