SUPPORT / SAMPLES & SAS NOTES
Problem Note 38731: Errors might occur when you run the rpo_alert task of the back-end jobs in SAS® Regular Price Optimization
 |  |  |  |  |
You might encounter an error similar to the following in the log when you run the rpo_alert task of back-end jobs in SAS Regular Price Optimization:
ERROR: During insert: [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.MARGIN_RULE_VIOLATION" from having duplicate values for the index key. SQLSTATE=23505
This error occurs when the value of the NUM_PARALLEL_EXECUTIONS spec in the GLOBAL_SETTING table is greater than or equal to 10.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||