-
Type:
Bug
-
Status: Closed
-
Resolution: Duplicate
-
Affects Version/s: 7.2.0 RC2, Master
-
Component/s: Business Productivity > Kaleo Workflow Forms
-
Labels:
-
Fix Priority:3
-
Databases:Sybase ASE 16
-
QA Test Name:
-
QA Test Score:5
Steps to reproduce issue:
- Import the attached 7.0.10.6 database into Sybase
- Upgrade the database
Expected result: Upgrade executes successfully, and no warnings are thrown
Actual result: Upgrades executes, but syntax warnings are thrown:
2019-04-09 11:30:57.544 INFO [main][UpgradeProcess:93] Upgrading com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema INFO - Upgrading com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema 2019-04-09 11:30:57.545 INFO [main][LoggingTimer:83] Starting com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL INFO - Starting com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL 2019-04-09 11:30:57.545 INFO [main][LoggingTimer:83] Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString INFO - Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString 2019-04-09 11:30:57.547 WARN [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskForm) go WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskForm) go 2019-04-09 11:30:57.595 WARN [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskFormInstance) go WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskFormInstance) go 2019-04-09 11:30:57.623 WARN [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoDefinitionVersion) go WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoDefinitionVersion) go 2019-04-09 11:30:57.839 INFO [main][LoggingTimer:43] Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 294 ms INFO - Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 294 ms 2019-04-09 11:30:57.840 INFO [main][LoggingTimer:43] Completed com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL in 295 ms INFO - Completed com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL in 295 ms 2019-04-09 11:30:57.840 INFO [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema in 296 ms INFO - Completed upgrade process com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema in 296 ms
Reproduced on:
Tomcat 9.0.17 + Sybase 16.0
Portal master GIT ID: 32242e6f17cfe39716aa80aa778b073d5ca94524
Portal master-private GIT ID: 1746ff1b29efb42ca90da6abd0ba1be3af1db25d
- duplicates
-
LPS-92506 SQL syntax errors when upgrading from 7.0.10.6
- Closed