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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||
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#44311| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-11-14 11:20:39 |
| Date Created: | 2011-09-15 17:00:28 |