Defect HC-23618
Exception in CalculationCodeListDataBean from REST /associated_promotion with Variants
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0354729 | V9.1 | 9.1.12.0 |
Observed behavior
When invoking the REST API call "/associated_promotion" with product or item variants, an exception similar to the following may occur:
[11/16/22 11:03:14:243 GMT] 00000153 CommerceSrvr E DataBeanManager activate(commandContext,response) CMN0420E: The following command exception has occurred during processing: "com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=4.19.66". com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=4.19.66
Expected behavior
The API should work properly for variants with no exceptions raised.
Resolution
Fixed