Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-66085

ee-6.2 to 7.0 DXP upgrade fails on Sybase

    Details

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                victor.ware Victor Ware
                Reporter:
                victor.ware Victor Ware
                Participants of an Issue:
                Recent user:
                Brian Wulbern
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 19 weeks, 4 days ago

                  Packages

                  Version Package
                  7.0.1 CE GA2