Defect HC-11011

Software

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.