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

undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC]

    Details

    • Branch Version/s:
      5.2.x, 5.1.x
    • Backported to Branch:
      Committed
    • Liferay Contributor's Agreement:
      Accept

      Description

      At revision 34584.

      3:32:11,343 ERROR [PortalInitThread:50] com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC]
      com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC]
      	at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:97)
      	at com.liferay.wsrp.service.persistence.WSRPConsumerPortletPersistenceImpl.findAll(WSRPConsumerPortletPersistenceImpl.java:694)
      	at com.liferay.wsrp.service.persistence.WSRPConsumerPortletPersistenceImpl.findAll(WSRPConsumerPortletPersistenceImpl.java:624)
      	at com.liferay.wsrp.service.impl.WSRPConsumerPortletLocalServiceImpl.initWSRPConsumerPortlets(WSRPConsumerPortletLocalServiceImpl.java:163)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      	at $Proxy218.initWSRPConsumerPortlets(Unknown Source)
      	at com.liferay.wsrp.service.WSRPConsumerPortletLocalServiceUtil.initWSRPConsumerPortlets(WSRPConsumerPortletLocalServiceUtil.java:135)
      	at com.liferay.wsrp.servlet.PortalInitThread.run(PortalInitThread.java:45)
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC]
      	at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:41)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:82)
      	at com.liferay.wsrp.service.persistence.WSRPConsumerPortletPersistenceImpl.findAll(WSRPConsumerPortletPersistenceImpl.java:680)
      	... 17 more
      Caused by: org.hibernate.QueryException: undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC]
      	at org.hibernate.hql.classic.PathExpressionParser.token(PathExpressionParser.java:153)
      	at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:51)
      	at org.hibernate.hql.classic.FromParser.token(FromParser.java:220)
      	at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:109)
      	at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:131)
      	at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:51)
      	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:239)
      	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:208)
      	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:94)
      	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:1650)
      	at com.liferay.portal.dao.orm.hibernate.LiferaySession.createQuery(LiferaySession.java:137)
      	at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:79)
      	... 18 more
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  10 years, 35 weeks, 2 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP6
                  7.0.0 DXP SP1
                  7.0.3 CE GA4