Uploaded image for project: 'PUBLIC - Liferay Sync'
  1. PUBLIC - Liferay Sync
  2. SYNC-1698

SQLException: user lacks privilege or object not found: SYNCDLOBJE0_.LANTOKE21_682_

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Connector-3.3.0
    • Fix Version/s: Connector-3.3.1
    • Component/s: Sync Connector
    • Labels:
      None
    • Affects Portal Version/s:
      6.2.10 EE GA1

      Description

      Reproduction steps:
      1. Start Liferay 6.2.10 SP16
      2. Install Liferay Sync Connector from Marketplace version: 3.3.0
      3. In Documents and Library - Add a Basic Document file - publish
      Check the logs:

      15:17:03,032 ERROR [liferay/document_library_sync_event_processor-1][JDBCExceptionReporter:82] user lacks privilege or object not found: SYNCDLOBJE0_.LANTOKE21_682_
      15:17:03,051 ERROR [liferay/document_library_sync_event_processor-1][SerialDestination:70] Unable to process message {destinationName=liferay/document_library_sync_event_processor, response=null, responseDestinationName=null, responseId=null, payload=null, values={defaultLocale=en_US, groupId=0, permissionChecker=com.liferay.portal.kernel.util.TransientValue@61995a5f, principalName=10199, siteDefaultLocale=en_US, event=add, modifiedTime=1480346223001, companyId=10155, type=file, themeDisplayLocale=en_US, typePK=10722}}
      com.liferay.portal.kernel.messaging.MessageListenerException: 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.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:32)
      	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:72)
      	at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:67)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:682)
      	at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:593)
      	at java.lang.Thread.run(Thread.java:745)
      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.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:251)
      	at com.liferay.sync.service.persistence.SyncDLObjectPersistenceImpl.fetchByT_T(SyncDLObjectPersistenceImpl.java:3038)
      	at com.liferay.sync.service.persistence.SyncDLObjectPersistenceImpl.fetchByT_T(SyncDLObjectPersistenceImpl.java:2942)
      	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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:320)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      	at com.liferay.portal.dao.shard.advice.ShardPersistenceAdvice.invoke(ShardPersistenceAdvice.java:54)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      	at com.sun.proxy.$Proxy557.fetchByT_T(Unknown Source)
      	at com.liferay.sync.service.impl.SyncDLObjectLocalServiceImpl.addSyncDLObject(SyncDLObjectLocalServiceImpl.java:95)
      	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:115)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
      	at com.sun.proxy.$Proxy555.addSyncDLObject(Unknown Source)
      	at com.liferay.sync.service.SyncDLObjectLocalServiceUtil.addSyncDLObject(SyncDLObjectLocalServiceUtil.java:320)
      	at com.liferay.sync.util.SyncUtil.addSyncDLObject(SyncUtil.java:121)
      	at com.liferay.sync.messaging.DLSyncEventMessageListener.processDLSyncEvent(DLSyncEventMessageListener.java:128)
      	at com.liferay.sync.messaging.DLSyncEventMessageListener.doReceive(DLSyncEventMessageListener.java:78)
      	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
      	... 5 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:30)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:125)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:98)
      	at com.liferay.sync.service.persistence.SyncDLObjectPersistenceImpl.fetchByT_T(SyncDLObjectPersistenceImpl.java:3013)
      	... 35 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.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
      	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
      	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
      	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      	at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:113)
      	... 37 more
      Caused by: java.sql.SQLException: user lacks privilege or object not found: SYNCDLOBJE0_.LANTOKE21_682_
      	at org.hsqldb.jdbc.Util.sqlException(Util.java:232)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3893)
      	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:643)
      	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:469)
      	at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
      	at com.sun.proxy.$Proxy6.prepareStatement(Unknown Source)
      	at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74)
      	at com.sun.proxy.$Proxy274.prepareStatement(Unknown Source)
      	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
      	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
      	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:801)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      	at org.hibernate.loader.Loader.doList(Loader.java:2542)
      	... 44 more

      Notes:
      Not reproducible with connector 3.2.0
      Reproducible with connector 3.3.0
      Not reproducible on 6.2.x
      liferay-portal-ee: commit 2b6fbb436fbebcffc9721ef4570ce0b72e343c24
      liferay-plugins-ee: commit 006df5b4b308057c209c001f49f6d8047ea2eef2

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 51 weeks ago

                Packages

                Version Package
                Connector-3.3.1