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

Cannot configure 7.0/Master to use Sybase

    Details

    • Fix Priority:
      5
    • Databases:
      Sybase ASE 15.7

      Description

      Tomcat 7.0.42 + Sybase ASE 15.7 Portal ee-7.0.x EE GIT ID: 13b30f8f157ea51d3f4d7a4a3a3646f7a0f6ea55.
      Tomcat 7.0.42 + Sybase ASE 15.7 Portal master GIT ID: bbc026af7e3a620d0ed2570a0dcfc34677ff29ba.

      Steps to Reproduce:

      1. Configure a master/7.0 bundle to run on sybase (you can use the following steps as guidance)
        Upload newly configured sybase vm.
        Steps to configure.
        Start > Adaptive Server Enterprise > Server Config
        Configure Adaptive Server > Language > Character Set
        Add/Remove Utf8
        Set UTF8 as default
        
        after opening cmd in the sybase vm and entering 'isql -U sa -P password', you can do this:
        
        disk init name = 'lportal_dev', physname = 'c:\lportal_dev', size = '600M'
        go
        disk init name = 'lportal_log', physname = 'c:\lportal_log', size = '400M'
        go
        CREATE database lportal on lportal_dev = '600M' log on lportal_log = '400M'
        go
        exec sp_dboption 'lportal', 'allow nulls by default' , true
        go
        exec sp_dboption 'lportal', 'select into/bulkcopy/pllsort' , true
        go
        
      2. Start bundle

      Expected result:
      Portal stars without errors.

      Actual result:
      Portal fails to start and the stacktrace throws the following exceptions:

      21:53:28,955 ERROR [localhost-startStop-1][MainServlet:204] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:78)
      	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1230)
      	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:201)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:160)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:656)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1635)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:111)
      	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:76)
      	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:46)
      	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:167)
      	at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:79)
      	at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:240)
      	at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:221)
      	at com.liferay.portal.events.StartupAction.run(StartupAction.java:72)
      	... 19 more
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
      	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:44)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      	... 27 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portlet.journal.service.persistence.impl.JournalArticleFinderImpl.findByNoPermissions(JournalArticleFinderImpl.java:577)
      	at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.getNoPermissionArticles(JournalArticleLocalServiceImpl.java:2888)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:149)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:123)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:174)
      	at com.sun.proxy.$Proxy153.getNoPermissionArticles(Unknown Source)
      	at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.getNoPermissionArticles(JournalArticleLocalServiceUtil.java:2001)
      	at com.liferay.portal.verify.VerifyJournal.verifyPermissions(VerifyJournal.java:726)
      	at com.liferay.portal.verify.VerifyJournal.doVerify(VerifyJournal.java:90)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      	... 30 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:193)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:172)
      	at com.liferay.portlet.journal.service.persistence.impl.JournalArticleFinderImpl.findByNoPermissions(JournalArticleFinderImpl.java:574)
      	... 44 more
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.loader.Loader.doList(Loader.java:2545)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      	at org.hibernate.loader.Loader.list(Loader.java:2271)
      	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
      	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
      	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
      	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:181)
      	... 46 more
      Caused by: java.sql.SQLException: Implicit conversion from datatype 'VARCHAR' to 'DECIMAL' is not allowed.  Use the CONVERT function to run this query._ [Sanitized]
      	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
      	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
      	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:637)
      	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
      	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
      	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      	at org.hibernate.loader.Loader.doList(Loader.java:2542)
      	... 53 more
      Stopping the server due to unexpected startup errors
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              koor.gai Koor Gai
              Reporter:
              jared.zimmerman Jared Zimmerman (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 32 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 Alpha 2
                  7.0.X EE