SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35763: Load_STG2DM_Vehicle and Load_STG2DM_Vehicle_Attr jobs give ORACLE execute error unique constraint violated following 32RO04 hot fix installation

DetailsHotfixAboutRate It
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:

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Markdown OptimizationMicrosoft Windows 2000 Advanced Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
SAS SystemSAS Promotion OptimizationMicrosoft Windows 2000 Advanced Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
SAS SystemSAS Regular Price OptimizationMicrosoft Windows 2000 Advanced Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4
SAS SystemSAS Pack OptimizationMicrosoft Windows 2000 Advanced Server1.29.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server1.29.1 TS1M3 SP4
Microsoft Windows 2000 Server1.29.1 TS1M3 SP4
Microsoft Windows 2000 Professional1.29.1 TS1M3 SP4
Microsoft Windows NT Workstation1.29.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition1.22.29.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP Professional1.22.29.1 TS1M3 SP49.2 TS2M0
Windows Vista1.22.29.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX1.22.29.1 TS1M3 SP49.2 TS2M0
SAS SystemSAS Size ProfilingMicrosoft Windows 2000 Advanced Server1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX1.22.29.1 TS1M3 SP49.1 TS1M3 SP4
* 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.