Problem Note 46950: %DI_JOB_RO rpo_alert task generates "ORACLE execute error: ORA-00001: unique constraint..." error
 |  |  |  |  |
The %DI_JOB_RO rpo_alert task in SAS® Regular Price Optimization might generate the following error in the <DDMMMYYYY_HH_MM_SS>_rpo_chk_alert_violations.log file:
ERROR: ERROR: ERROR: ORACLE execute error: ORA-00001: unique constraint (<constraint identifier>) violated.
With the occurrence of the above ERROR, the error limit of 1 set by the ERRLIMIT= option has been reached.
ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).
Total rows processed: <#>
Rows failed : <#>
ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.MARGIN_RULE_RESULT.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
This error occurs when there are two margin rules defined that have different geo_hier_assoc_cd values, and both of these rules are violated when a cost changes.
The workaround for this issue is to delete one of the rules.
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 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 4.2_M1 | 5.2_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
A fix for this issue for SAS Merchandise Intelligence 4.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D81.html#46950| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-10-26 08:30:55 |
| Date Created: | 2012-07-10 09:11:49 |