Defect HC-11011
catalog filters data load failed when the catalog filter name is too long
Software
Customer case | Applies to | Corrected in |
---|---|---|
CS0235691 | V9.1.9.0 | 9.1.11.0 |
Observed behavior
When creating catalog filters using the dataload utility, a SQL exception can occur if the name is too long.
Expected behavior
There should be no exception raised.
Resolution
The catalog filter's name field (PRODUCTSET.NAME) is created by appending control information to the end of the filter's identifier. When the identifier is longer than 20 characters, the combination of the id and control information makes the name too long to contain in the VARCHAR(32) field.
The code was updated to truncate the identifier's value to 20 characters before appending the control information.