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

Error converting characters on start up with Sybase 15.7

    Details

    • Fix Priority:
      4

      Description

      Steps to reproduce:

      1. Set up Sybase 15.7 following instructions listed here
        portal-ext.properties
        jdbc.default.driverClassName=com.sybase.jdbc4.jdbc.SybDriver
        jdbc.default.url=jdbc:sybase:Tds:{IPAddressHere}/lportal
        jdbc.default.username=sa
        jdbc.default.password=password
        
        hibernate.dialect=com.liferay.portal.dao.orm.hibernate.SybaseASE157Dialect
        custom.sql.function.isnull=CONVERT(VARCHAR,?) IS NULL
        custom.sql.function.isnotnull=CONVERT(VARCHAR,?) IS NOT NULL
        
      2. Start portal

      Expected Result: No errors on start up.

      Actual Result: The errors below show up a few times during start up. No functional impact on portal.

      15:20:27,828 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] JZ0BE: BatchUpdateException: Error occurred while executing batch statement: Error converting characters into server's character set. Some character(s) could not be converted._ [Sanitized]
      15:20:27,856 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] Error converting characters into server's character set. Some character(s) could not be converted._ [Sanitized]
      15:20:27,881 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] Error converting characters into server's character set. Some character(s) could not be converted._ [Sanitized]
      

      Reproduced on:
      Tomcat 8.0.32 + Sybase 15.7
      Portal ee-7.0.x Git Hash: 2f0370e4fec6c39c284f5394844812886e4de0e4

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.0.X EE