Usage Note 45722: RPO_ALERT task can only be run once per calendar day
As documented in the SAS® Revenue Optimization Administrator's Guide, the rpo_alert task can be run daily if the associated data tables are updated daily. The rpo_alert task can only be run once per calendar day.
If you attempt to run the rpo_alert task more than once in a calendar day, you might see the following error in the <date_hh_mm_ss>_rpo_chk_alert_violations.log file.
ERROR: CLI execute error: [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT
statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid
because the primary key, unique constraint or unique index identified by "1" constrains table
"DI_DM.COMP_PRICE_RULE_RESULT" from having duplicate values for the index key.
SQLSTATE=23505
ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.COMP_PRICE_RULE_RESULT.DATA.
Operating System and Release Information
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2008 | 4.2_M1 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | | 9.2 TS2M3 | |
| 64-bit Enabled AIX | 4.2_M1 | | 9.2 TS2M3 | |
*
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.
| Date Modified: | 2012-02-21 09:45:06 |
| Date Created: | 2012-02-20 09:41:19 |
