When you run the Load_STG2DM_Budget job during a SAS^® High Performance Markdown Optimization incremental data load, the job might fail with the following error:

This error occurs because the data extracted from the BUDGET table in Oracle is not in the correct sort order.

The work around for this issue is to sort the data in Oracle before the start of the ETL process. The following code needs to be run in a SAS job where the Merchandise Intelligence macros and libraries are allocated. This job should be run each week before the start of the ETL process.

%di_dm_trans_extract(di_trans=DI_DM2,
            trans_table=BUDGET,
            _output_table=WORK.BUDGET
);

proc sort data=BUDGET;
by by GEO_HIER_SK PROD_HIER_SK START_DT END_DT BUDGET_TYPE;
run;

%di_dm_trans_delete(di_trans=di_dm2,
                 trans_table=BUDGET,
                 lock=0,
                 all_trans=0,
                 chunk_size_val=0
);

%di_dm_trans_append(di_trans=DI_DM2,
                trans_table=BUDGET,
                append_table=WORK.BUDGET);

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 High-Performance Markdown Optimization 4.3_M2 is available at: