Details

    • Story Points:
      1
    • Fix Priority:
      5
    • Databases:
      Sybase ASE 15.5

      Description

      Steps to reproduce:

      1. Configure to use Sybase 15.5.
      2. Start portal.

      Actual results:
      Server stops with these error:

      04:55:39,971 INFO  [localhost-startStop-1][VerifyProcess:69] Verifying com.liferay.portal.verify.VerifySocial
      04:55:39,996 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] Incorrect syntax near the keyword 'AS'._ [Sanitized]
      04:55:39,997 ERROR [localhost-startStop-1][BasePersistenceImpl:244] Caught unexpected exception org.hibernate.exception.GenericJDBCException
      04:55:39,998 INFO  [localhost-startStop-1][VerifyProcess:79] Completed verification process com.liferay.portal.verify.VerifySocial in 27ms
      04:55:40,002 INFO  [localhost-startStop-1][VerifyProcess:79] Completed verification process com.liferay.portal.verify.VerifyProcessSuite in 4814ms
      04:55:40,015 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: org.hibernate.exception.GenericJDBCException: 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: org.hibernate.exception.GenericJDBCException: 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:724)
      Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.GenericJDBCException: 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: org.hibernate.exception.GenericJDBCException: 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:49)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      	... 27 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.GenericJDBCException: could not execute query
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:251)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:148)
      	at com.liferay.portlet.social.service.base.SocialRequestLocalServiceBaseImpl.dynamicQuery(SocialRequestLocalServiceBaseImpl.java:142)
      	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:173)
      	at com.sun.proxy.$Proxy218.dynamicQuery(Unknown Source)
      	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.kernel.dao.orm.BaseActionableDynamicQuery.executeDynamicQuery(BaseActionableDynamicQuery.java:318)
      	at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery$1.call(BaseActionableDynamicQuery.java:263)
      	at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery$1.call(BaseActionableDynamicQuery.java:259)
      	at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.doPerformActions(BaseActionableDynamicQuery.java:290)
      	at com.liferay.portal.kernel.dao.orm.BaseActionableDynamicQuery.performActions(BaseActionableDynamicQuery.java:90)
      	at com.liferay.portal.verify.VerifySocial.doVerify(VerifySocial.java:78)
      	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:72)
      	... 30 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
      	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
      	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.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
      	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
      	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
      	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:94)
      	at com.liferay.portal.dao.orm.hibernate.DynamicQueryImpl.list(DynamicQueryImpl.java:88)
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.findWithDynamicQuery(BasePersistenceImpl.java:145)
      	... 51 more
      Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'AS'._ [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:632)
      	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)
      	... 59 more
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Days since last comment:
                  3 years, 14 weeks, 1 day ago

                  Packages

                  Version Package