Uploaded image for project: 'PUBLIC - Liferay Commerce'
  1. PUBLIC - Liferay Commerce
  2. COMMERCE-2197

Shipments screen triggers ORM exception

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      After a clean install of 2.0.1 on Liferay DXP 7.1 FP12, when you click the Shipments tab, the screen renders "Shipments is temporarily unavailable." due to an ORM exception being triggered.

      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT COUNT(*) FROM com.liferay.commerce.model.impl.CommerceShipmentImpl commerceShipment WHERE ]
      {{ at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:269)}}
      {{ at com.liferay.commerce.service.persistence.impl.CommerceShipmentPersistenceImpl.countByGroupIds(CommerceShipmentPersistenceImpl.java:853)}}
      {{ at com.liferay.commerce.service.impl.CommerceShipmentLocalServiceImpl.getCommerceShipmentsCount(CommerceShipmentLocalServiceImpl.java:133)}}...Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: Incorrect query syntax [SELECT COUNT(*) FROM com.liferay.commerce.model.impl.CommerceShipmentImpl commerceShipment WHERE ]
      {{ at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:39)}}
      {{ at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:86)}}
      {{ at com.liferay.portal.dao.orm.hibernate.SessionImpl.createQuery(SessionImpl.java:73)}}
      {{ at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.createQuery(ClassLoaderSession.java:103)}}
      {{ at com.liferay.commerce.service.persistence.impl.CommerceShipmentPersistenceImpl.countByGroupIds(CommerceShipmentPersistenceImpl.java:841)}}
      {{ ... 274 more}}
      Caused by: org.hibernate.QueryException: Incorrect query syntax [SELECT COUNT(*) FROM com.liferay.commerce.model.impl.CommerceShipmentImpl commerceShipment 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:83)}}
      {{ ... 277 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)}}
      {{ ... 285 more}}
      2019-07-16 11:00:29.195 ERROR [https-jsse-nio-443-exec-4][render_portlet_jsp:131] null
      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)}}

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              gverhemeldonck Gunther Verhemeldonck
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package