Problem Note 35763: Load_STG2DM_Vehicle and Load_STG2DM_Vehicle_Attr jobs give ORACLE execute error unique constraint violated following 32RO04 hot fix installation
 |  |  |  |  |
Following installation of hot fix 32RO04 for SAS® Merchandise Intelligence 3.2, you might see the following Oracle error in the SAS log when you run the Load_STG2DM_Vehicle and/or Load_STG2DM_Vehicle_Attr:
*
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.
ERROR: ORACLE execute error: ORA-00001: unique constraint (DI_DM.SYS_C003398) violated.
There was a change made in hot fix 32RO04 that affects the following Oracle sequence keys:
SEQ_VEHICLE_SK
SEQ_VEHICLE_ATTR_SK
To fix the problem, reinitialize the keys by issuing the following Oracle commands where desired number is the maximum current _sk value plus 1 (the desired next sequence number):
DROP SEQUENCE SEQ_VEHICLE_SK; CREATE SEQUENCE SEQ_VEHICLE_SK START WITH desired number; DROP SEQUENCE SEQ_VEHICLE_ATTR_SK; CREATE SEQUENCE SEQ_VEHICLE_ATTR_SK START WITH desired number;
Rerun the failed job following the reinitialization.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| SAS System | SAS Promotion Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| SAS System | SAS Regular Price Optimization | Microsoft Windows 2000 Advanced Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| SAS System | SAS Pack Optimization | Microsoft Windows 2000 Advanced Server | 1.2 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 1.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 1.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 1.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 1.2 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| SAS System | SAS Size Profiling | Microsoft Windows 2000 Advanced Server | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 1.2 | 2.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#035763| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-05-06 12:53:40 |
| Date Created: | 2009-05-01 11:41:17 |