SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 45619: Load_STG2DM_Budget.sas fails because of incorrect sort order

DetailsHotfixAboutRate It

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:

ERROR: BY variables are not properly sorted on data set WORK.BUDGET.

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS High-Performance Markdown OptimizationLinux for x644.3_M25.29.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.