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

Investigate Unknown column in AssertDiscountIsAppliedToChannel

    Details

      Description

      Testray
      Poshi
      Jenkins

      021-10-15 08:40:20.862 ERROR [http-nio-8080-exec-14][JDBCExceptionReporter:234] Unknown column 'CommerceDiscount.commerceDiscountId' in 'IN/ALL/ANY subquery'
           [exec] 2021-10-15 08:40:20.875 ERROR [http-nio-8080-exec-14][ExceptionMapper:52] java.sql.SQLSyntaxErrorException: Unknown column 'CommerceDiscount.commerceDiscountId' in 'IN/ALL/ANY subquery'
           [exec] java.sql.SQLSyntaxErrorException: Unknown column 'CommerceDiscount.commerceDiscountId' in 'IN/ALL/ANY subquery'
           [exec] 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql.jar:8.0.21]
           [exec] 	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql.jar:8.0.21]
           [exec] 	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.0.21]
           [exec] 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql.jar:8.0.21]
           [exec] 	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql.jar:8.0.21]
           [exec] 	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[hikaricp.jar:?]
           [exec] 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
           [exec] 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) ~[hibernate-core.jar:3.6.10.Final]
           [exec] 	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176) ~[portal-impl.jar:?]
           [exec] 	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168) ~[portal-impl.jar:?]
           [exec] 	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84) ~[portal-kernel.jar:?]
           [exec] 	at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:53) ~[portal-kernel.jar:?]
      

        Attachments

          Activity

            People

            Assignee:
            riccardo.alberti Riccardo Alberti
            Reporter:
            kevin.valencia Kevin Valencia
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                7.4 DXP U1