Uploaded image for project: 'PUBLIC - Liferay Portal Web Content Experience'
  1. PUBLIC - Liferay Portal Web Content Experience
  2. WCM-697

Clicking Liferay Site from Sites admin after deploying AT plugins throws ORMException

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: 2.x
    • Fix Version/s: 2.0
    • Component/s: Content Targeting
    • Labels:
      None
    • Fix Priority:
      3

      Description

      Steps to reproduce:

      1. Startup the app server
      2. Deploy all AT dependencies
      3. Navigate to Product Menu > Control Panel > Sites > Sites
      4. Click the 'Liferay' link

      Expected result:
      There won't be any console errors thrown.

      Actual result:
      The following console error is thrown (but there doesn't appear to be any functional impact):

      15:44:36,578 ERROR [liferay/analytics-7][AnalyticsMessageListener:41] Unable to process message {destinationName=liferay/analytics, response=null, responseDestinationName=null, responseId=null, payload=null, values={pathContext=, groupId=0, classPK=20150, scopeGroupId=32055, anonymousUserId=32004, clientIP=127.0.0.1, uRLHome=http://localhost:8080/web/guest, companyGroupId=20160, stateMaximized=true, pathJavaScript=/o/frontend-js-web, statePopUp=false, plid=32060, defaultLanguageId=en_US, privateLayout=false, defaultLocale=en_US, layoutRelativeURL=/web/new-site/page2, companyId=20116, pathThemeRoot=/o/classic-theme, impersonated=false, controlPanel=false, bCP47LanguageId=en-US, className=com.liferay.portal.kernel.model.Layout, virtualLayout=false, referrers={com.liferay.portal.kernel.model.Layout=[J@7a971f24}, parentLayoutId=0, doAsUserIdEncoded=, siteGroupId=32055, pathThemeImages=http://localhost:8080/o/classic-theme/images, event=view, uRLControlPanel=/group/control_panel?refererPlid=32060, timestamp=2016-05-25T15:44:36.388Z, scopeGroupIdOrLiveGroupId=32055, cDNBaseURL=http://localhost:8080, languageId=en_US, parentGroupId=32055, stateExclusive=false, userAgent=Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101 Firefox/38.0, sessionId=, userName=Test Test, layoutId=1, userId=20164, pathMain=/c, pathImage=/image, cDNHost=, layoutURL=http://localhost:8080/web/new-site/page2, portalURL=http://localhost:8080, signedIn=true, addSessionIdToURL=false, cDNDynamicResourcesHost=, freeformLayout=false}}
      com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT userSegment FROM com.liferay.content.targeting.model.impl.UserSegmentImpl userSegment WHERE ]
              at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:264)
              at com.liferay.content.targeting.service.persistence.impl.UserSegmentPersistenceImpl.findByGroupId(UserSegmentPersistenceImpl.java:2550)
              at com.liferay.content.targeting.service.persistence.impl.UserSegmentPersistenceImpl.findByGroupId(UserSegmentPersistenceImpl.java:2423)
              at com.liferay.content.targeting.service.persistence.impl.UserSegmentPersistenceImpl.findByGroupId(UserSegmentPersistenceImpl.java:2386)
              at com.liferay.content.targeting.service.impl.UserSegmentLocalServiceImpl.getUserSegments(UserSegmentLocalServiceImpl.java:311)
              at sun.reflect.GeneratedMethodAccessor808.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:497)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
              at com.sun.proxy.$Proxy524.getUserSegments(Unknown Source)
              at com.liferay.content.targeting.rule.score.points.messaging.DefaultScorePointsAssignerImpl.assignPoints(DefaultScorePointsAssignerImpl.java:55)
              at com.liferay.content.targeting.rule.score.points.messaging.AnalyticsMessageListener.doReceive(AnalyticsMessageListener.java:52)
              at com.liferay.content.targeting.rule.score.points.messaging.AnalyticsMessageListener.receive(AnalyticsMessageListener.java:38)
              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:756)
              at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT userSegment FROM com.liferay.content.targeting.model.impl.UserSegmentImpl userSegment WHERE ]
              at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:33)
              at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:91)
              at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:77)
              at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.createQuery(ClassLoaderSession.java:110)
              at com.liferay.content.targeting.service.persistence.impl.UserSegmentPersistenceImpl.findByGroupId(UserSegmentPersistenceImpl.java:2526)
              ... 22 more
      Caused by: org.hibernate.QueryException: Incorrect query syntax [SELECT userSegment FROM com.liferay.content.targeting.model.impl.UserSegmentImpl userSegment WHERE ]
              at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:256)
              at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:209)
              at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
              at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
              at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
              at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
              at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
              at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
              at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:88)
              ... 25 more
      Caused by: java.util.NoSuchElementException
              at java.util.LinkedList.getLast(LinkedList.java:257)
              at org.hibernate.hql.classic.WhereParser.closeExpression(WhereParser.java:328)
              at org.hibernate.hql.classic.WhereParser.token(WhereParser.java:270)
              at org.hibernate.hql.classic.WhereParser.end(WhereParser.java:310)
              at org.hibernate.hql.classic.ClauseParser.endChild(ClauseParser.java:122)
              at org.hibernate.hql.classic.ClauseParser.end(ClauseParser.java:130)
              at org.hibernate.hql.classic.PreprocessingParser.end(PreprocessingParser.java:145)
              at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:52)
              at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:240)
              ... 33 more
      

        Attachments

          Activity

            People

            • Assignee:
              brian.wulbern Brian Wulbern
              Reporter:
              brian.wulbern Brian Wulbern
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2.0