The SAS^® Revenue Optimization Suite Load_STG2DM_Geo_prod job might generate the following error in the Load_STG2DM_Geo_prod.log.Load_STG2DM_Geo_prod..etl_exec_job.n.log file:

This error occurs when you run the Load_STG2DM_Geo_prod job after you have run %di_maintain_job to purge data from the GEO_PROD_STATUS table.

To work around this issue perform the following steps:

1. Restore all partition level (di_dm/1/partition_id) level geo_prod and geo_prod_status tables to a backup from before you attempted to run the Load_STG2DM_Geo_prod job.
2. Repair the geo_prod_status table using the %di_etl_repair_data utility documented in Chapter 9 of the SAS^® Revenue Optimization Administrator's Guide.
3. Run Load_STG2DM_Geo_prod again with same STG file that was used in the failed run.
4. Run all steps for the weekly batch jobs that normally follow the Load_STG2DM_Geo_prod job.

To prevent this error from occurring in the future, run %di_etl_repair_data(table_name=geo_prod_status, dm=0, partition=0); after your regularly scheduled purge job.

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 Revenue Optimization 5.2 is available at:

A fix for this issue for SAS SizeOptimization 3.2 is available at: