Problem Note 44311: A profile lookup in SAS® Pack Optimization might generate the message “ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.PROFILE_LOOKUP_STAT
In SAS Pack Optimization, performing a profile lookup might fail, generating errors similar to the following in the log:
ERROR: ERROR: ERROR: ORACLE execute error: ORA-00001: unique constraint (DI_DM.SYS_C0015565) violated.
ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.PROFILE_LOOKUP_STAT.DATA.
There error occurs when both of the following conditions are met:
- The UPDATE_PROFILE_LOOKUP_STAT specification in the GLOBAL_SETTING table is set to 1 (update the PROFILE_LOOKUP_STAT table).
- There are to multiple requests return the same profile ID at the same time.
The profile ID from the first request is appended to the PROFILE_LOOKUP_STATS table successfully, but the others fail because of the unique constraint-violated (DI_DM.SYS_C0015565) condition.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Pack Optimization | 64-bit Enabled AIX | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2008 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 for x64 | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Standard Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Datacenter Edition | 2.2_M1 | 3.2 | 9.2 TS2M3 | 9.3 TS1M1 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2012-11-14 11:20:39 |
Date Created: | 2011-09-15 17:00:28 |