-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.0.1 CE GA2
-
Fix Version/s: 7.0.1 CE GA2
-
Labels:
-
Fix Priority:5
-
Databases:Sybase ASE 15.7, Sybase ASE 16
-
Git Pull Request:
Reproduced on:
Sybase 16
ee-6.2.10.15 > 7.0 DXP RC1
Steps to Reproduce:
- Start EE 6.2 on Sybase 16 with properties
jdbc.default.jndi.name= jdbc.default.driverClassName=com.sybase.jdbc4.jdbc.SybDriver jdbc.default.url=jdbc:sybase:Tds:172.16.71.138:5000/lportal jdbc.default.username=sa jdbc.default.password= hibernate.dialect=org.hibernate.dialect.SybaseDialect custom.sql.function.isnull="CONVERT(VARCHAR,?) IS NULL" custom.sql.function.isnotnull="CONVERT(VARCHAR,?) IS NOT NULL"
- Login
- Shutdown server
- Point 7.0 DXP bundle to 6.2 Sybase 16 database
- Upgrade database to 7.0 with upgrade tool in DXP bundle /tools/portal-tools-db-upgrade-client/
Expected Result:
Upgrade completes without error.
Actual Result:
Upgrade fails to complete.
23:50:35,611 INFO [main][UpgradeProcess:97] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 8566ms com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Function STR_REPLACE invoked with wrong number or type of argument(s). at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91) at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175) at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143) at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125) at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:158) at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:96) Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Function STR_REPLACE invoked with wrong number or type of argument(s). at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:91) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115) at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:69) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88) ... 7 more Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Function STR_REPLACE invoked with wrong number or type of argument(s). at com.liferay.portal.upgrade.v7_0_0.UpgradeKernelPackage.doUpgrade(UpgradeKernelPackage.java:66) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88) ... 10 more Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Function STR_REPLACE invoked with wrong number or type of argument(s). at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131) at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247) at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276) at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749) at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733) at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:588) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:291) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:261) at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:60) at com.liferay.portal.upgrade.v7_0_0.UpgradeKernelPackage.upgradeTable(UpgradeKernelPackage.java:126) at com.liferay.portal.upgrade.v7_0_0.UpgradeKernelPackage.doUpgrade(UpgradeKernelPackage.java:46) ... 11 more
- relates
-
LPS-95571 Upgrades fail on Sybase
- Closed