Problem Note 59958: "ERROR: ORACLE execute error: ORA-00001: unique constraint (DI_DM.SYS_XXXXXXX) violated" might occur when you generate store groups
 |  |  |  |  |
In SAS® Size Profiling, the following errors might occur when you generate store groups: and the following error messages can be found in the STP log:
ERROR: ORACLE execute error: ORA-00001: unique constraint (DI_DM.SYS_CXXXXXXXX) violated.
ERROR: Could not update table PRF_CONFIG for profiling project XXXXX in module SZPF_WRAP_GEOGRP_UNIT.
The errors are likely to occur when both of the following conditions are true:
- A profiling project was copied from an existing profiling project with a store grouping rule.
- The copied profiling project abended in the Generate Store Groups process.
The workaround for this issue is to re-create the profiling project.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 |
| Linux for x64 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#59958| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-02-28 13:40:11 |
| Date Created: | 2017-02-13 10:30:11 |