Investigate Unknown column in AssertDiscountIsAppliedToChannel

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.4 DXP U1
• Component/s: Order Management
• Labels:
  • QA-AUTOMATION
  • qa-a
  • qa-flex
• Business Value (single choice): 1
• Git Pull Request: https://github.com/liferay-commerce/liferay-portal/pull/1934

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:?]