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

MessageListenerException on startup with sybase and oracle database

    Details

      Description

      Same issue with Oracle database.
      Reproduction steps:

      1. Startup 71 with sybase(for me I test with sybase 16.0)

      Expected Results: No error throws.
      Actual Results: The following exception gets thrown:

      2019-01-25 07:02:44.687 INFO  [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.search.web.internal.upgrade.v2_0_0.UpgradeSearchPortlet in 42 ms
      2019-01-25 07:02:44.805 ERROR [liferay/scheduler_dispatch-4][JDBCExceptionReporter:234] Invalid column name 'true'._ [Sanitized]
      2019-01-25 07:02:44.826 ERROR [liferay/scheduler_dispatch-4][ParallelDestination:55] Unable to process message {destinationName=liferay/scheduler_dispatch, response=null, responseDestinationName=null, responseId=null, payload=null, values={GROUP_NAME=com.liferay.commerce.product.type.virtual.order.internal.messaging.CheckCommerceVirtualOrderItemMessageListener, companyId=0, groupId=0, DESTINATION_NAME=liferay/scheduler_dispatch, EXCEPTIONS_MAX_SIZE=0, JOB_STATE=com.liferay.portal.kernel.scheduler.JobState@4e870315, STORAGE_TYPE=MEMORY_CLUSTERED, JOB_NAME=com.liferay.commerce.product.type.virtual.order.internal.messaging.CheckCommerceVirtualOrderItemMessageListener}}
      com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:32)
      	at com.liferay.portal.kernel.scheduler.messaging.SchedulerEventMessageListenerWrapper.receive(SchedulerEventMessageListenerWrapper.java:66)
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
      	at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:752)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:664)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
      	at com.liferay.commerce.product.type.virtual.order.service.persistence.impl.CommerceVirtualOrderItemFinderImpl.findByEndDate(CommerceVirtualOrderItemFinderImpl.java:112)
      	at com.liferay.commerce.product.type.virtual.order.service.impl.CommerceVirtualOrderItemLocalServiceImpl.checkCommerceVirtualOrderItems(CommerceVirtualOrderItemLocalServiceImpl.java:159)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor._execute(DefaultTransactionExecutor.java:203)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:94)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:113)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:47)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:39)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.cache.thread.local.ThreadLocalCacheAdvice.invoke(ThreadLocalCacheAdvice.java:48)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:130)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:125)
      	at com.sun.proxy.$Proxy751.checkCommerceVirtualOrderItems(Unknown Source)
      	at com.liferay.commerce.product.type.virtual.order.internal.messaging.CheckCommerceVirtualOrderItemMessageListener.doReceive(CheckCommerceVirtualOrderItemMessageListener.java:79)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
      	... 6 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:188)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168)
      	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:61)
      	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53)
      	at com.liferay.commerce.product.type.virtual.order.service.persistence.impl.CommerceVirtualOrderItemFinderImpl.findByEndDate(CommerceVirtualOrderItemFinderImpl.java:108)
      	... 42 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.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:176)
      	... 46 more
      Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Invalid column name 'true'._ [Sanitized]
      	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.queryLoop(SybStatement.java:2643)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2629)
      	at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:279)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      	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
      2019-01-25 07:02:46.040 INFO  [main][UpgradeProcess:93] Upgrading com.liferay.announcements.web.internal.upgrade.v1_0_4.UpgradePortletPreferences
      
      

        Attachments

          Activity

            People

            Assignee:
            yvonne.han Yvonne Han
            Reporter:
            yvonne.han Yvonne Han
            Participants of an Issue:
            Recent user:
            Yvonne Han
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 49 weeks, 1 day ago

                Packages

                Version Package
                7.1.X