The SAS^® Revenue Optimization Suite Load_STG2DM_Geo_prod job might generate the following error in one or more of the Load_STG2DM_Geo_prod.log.Load_STG2DM_Geo_prod..etl_exec_job.n.log unit log files:

NOTE: Table TRG_LIB.GEO_PROD has been modified, with 11 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):

This error occurs when the following are true:

1. The Load_STG2DM_Geo_prod job is run after %DI_MAINTAIN_JOB has been used to purge records from the GEO_PROD and GEO_PROD_STATUS tables.
2. %DI_MAINTAIN_JOB does not purge all of the related GEO_PROD_STATUS records when a GEO_PROD is purged.

Please contact SAS Technical Support for a workaround for this issue and reference this SAS Note.

To prevent this issue from occurring in the future follow the steps documented in SAS Note: 47780.

Operating System and Release Information