ee-6.2 to 7.0 DXP upgrade fails on Sybase

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.1 CE GA2
• Fix Version/s: 7.0.1 CE GA2
• Component/s: Core Infrastructure, Core Infrastructure > Database Access, Core Infrastructure > Upgrade Framework
• Labels:
  • KNOWNISSUES_DE70
  • LR7UPGRADE
  • QA-F
• Fix Priority: 5
• Databases:
  Sybase ASE 15.7, Sybase ASE 16
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/40318

Reproduced on:
Sybase 16
ee-6.2.10.15 > 7.0 DXP RC1

Steps to Reproduce:

1. 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"
   

2. Login
3. Shutdown server
4. Point 7.0 DXP bundle to 6.2 Sybase 16 database
5. 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