Defect HC-11011

catalog filters data load failed when the catalog filter name is too long


Customer case Applies to Corrected in
CS0235691 V9.1.9.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.


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.