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

NOTE: Table DI_DM.GEO_PROD has been modified, with 10 columns.
ERROR: Integrity constraint _NM0001_ was rejected because n observations failed the constraint.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Statement not executed due to NOEXEC option.
NOTE: Statement not executed due to NOEXEC option.
NOTE: Statement not executed due to NOEXEC option.
NOTE: Statement not executed due to NOEXEC option.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           n seconds
      cpu time            n seconds
 

This error occurs when the following are both true:

• The STG_GEO_PROD file contains records where the STG_GEO_PROD.STATUS_VALID_FROM_DT is before the GEO_PROD_STATUS.VALID_FROM_DT for the current time period for a geo-prod.
• There is a STG_GEO_PROD record with a future STG_GEO_PROD.STATUS_VALID_FROM_DT for at least one other geo-prod.

The historical STG_GEO_PROD record is rejected and written to the DI_MON.STG_GEO_PROD_X table. Updating historical geo-prod status data is not supported.

To workaround this issue, perform the following steps:

1. Restore the DI_DM.GEO_PROD and DI_DM.GEO_PROD_STATUS tables from a backup made prior to the attempt to run Load_STG2DM_Geo_prod.
2. Remove the records identified in the DI_MON.STG_GEO_PROD_X table as historical records from the DIDM_STG.STG_GEO_PROD table.
3. Run the Load_STG2DM_Geo_prod 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 Merchandise Intelligence 4.2_M2 is available at: