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
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 |
*
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: | 2018-02-28 13:40:11 |
Date Created: | 2017-02-13 10:30:11 |