When using SAS^® Size Profiling to publish store groups for a profile that was copied, you might notice that the store groups do not get published. In addition, you might notice the following error messages in the stored process server log for the szpf_stp_profile_copy_tables.sas stored process:

ERROR: Could not extract data from PRF_RSLT_SC_ATTR_PVALUE for data project 100103, 
sizeset 3 in module SZPF_PROFILE_COPY_TABLES.

ERROR: Could not copy profile data for data project 100103, sizeset 3.
                                                   
ERROR:[macro:STP] returns error for inputs: debug: process_sk:100660 context_sk:
100140 src_data_project: 100103 dest_data_project: 100140 src_sizeset: 3 dest_sizeset: 
3.  Please check the log above.

ERROR: The profile copying process ended with errors.

This issue occurs because the PRF_RSLT_SC_ATTR_PVALUE table does not get populated for the source data project when there are no classification attributes selected.

To work around this issue, you should create a dummy attribute and force it into the classification model as follows:

1. Create a numeric attribute called RANDOM.
2. Populate it with random numbers between 0 and 1 for each store.
3. Force this attribute in the classification model. If you want this to be the default across all data projects, you can include it in the configuration as a default.
4. Make sure any new stores have this attribute populated.

Click 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: