Problem Note 46489: "ORA-00001: unique constraint..." error encountered during batch optimization
When you run the %DI_JOB task dipcl_opt_eval_workflow in SAS® Markdown Optimization, batch optimization might generate the following error in one of the <date>_<hour>_<minute>_<second>_mp.log.AUTO.dipcl_wrap_extract_data_call.<nbr>.log files.
ERROR: ORACLE execute error: ORA-00001: unique constraint (DI_DM.SYS_C00131163) violated.
ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.MPLN_RESULT.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.02 seconds
ERROR: Insert MPR - trans write: The status code is 1012
ERROR: Insert MPR data: The status code is 1012 and syscc is 1012
dipcl_insert_mprdata started at <date_time> and completed at <date_time>
FAILED: Insert of mplan result: status code is 1012 and syscc is 1012
FAILED: Wrap Extract Data: status code is 1012 and syscc is 1012
This error occurs when the global setting PARALLEL_PLAN_MEM_CHUNK_SIZE is set too low.
The workaround for this issue is to ensure that the global setting PARALLEL_PLAN_MEM_CHUNK_SIZE is set to a value larger than <number of geo-prods in all active mdo plans> / <global setting NUM_PARALLEL_EXECUTIONS>.
Operating System and Release Information
| SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 3.2 | | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 3.2 | | 9.1 TS1M3 | |
*
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: | 2016-07-12 13:36:03 |
| Date Created: | 2012-05-04 12:29:56 |
