The Generate Store Groups process might fail due to a duplicate key error in SAS Size Profiling. The following error appears in the stored process log:

ERROR: During insert: [IBM][CLI Driver][DB2/AIX64] SQL0803N  One or more values in the
INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid
because the primary key, unique constraint or unique index identified by "1" constrains
table "DI_DM.PRF_RSLT_STORE_GROUP_DISTRIB" from having duplicate values for the index key.
SQLSTATE=23505
ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.PRF_RSLT_STORE_GROUP_DISTRIB.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.

To work around the problem, perform the following steps:

1. Set the value of lrm_handle_missing_predictor to 2 in the prf_config table. If this parameter does not exist in the prf_config table, add the parameter, and set its default value to 2 by running the script below.
   

   INSERT INTO PRF_CONFIG  
    (PRF_CONFIG_SK,PRF_CONFIG_TYPE,SPEC_NM,SPEC_VALUE,SPEC_TYPE)
      VALUES(-1, 2, 'lrm_handle_missing_predictor', '2', 
             'INTEGER');
      

2. Set the value of lrm_ccc to 0 in prf_config table.

The workaround will prevent stores from being classified into store group 0. Instead, those stores will go to the largest store group.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Merchandise Intelligence 3.2 is available at: