-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: Master
-
Fix Version/s: Master
-
Component/s: Environments > Databases
-
Labels:
-
Fix Priority:3
-
Databases:DB2 11.1
-
Git Pull Request:
-
QA Test Score:10
Steps to reproduce issue:
- Import the attached 6.2.10.21 database into DB2
- Upgrade database
- 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
- is caused by
-
LPS-91495 ORA-00604 when running update.sql script to upgrade kaleo tables
- Closed