Running MDP_ADD Procedure Errors With Multiple Errors After Patch 6375504 Any Are Possible ORA-20002 ORA-20003 ORA-06512 ORA-12801 ORA-00018 (Doc ID 458146.1)

Last updated on MARCH 22, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 20-May-2011***


Symptoms

On 7.1.1 in Test with 11.5.10 EBS:
When attempting to run the MDP_ADD procedure after applying Demantra 7.1.1 CU1 (7.1.1.1) patch
6375504, the following error occurs:

ORA-20002: ORA-20003:
Error in PROCEDURE MDP_ADD line 571
executing ACTIVE_PROC_DYN('dynamic_mdp_add')
ORA-06512: at "CRP2.SEND_ERR_MESSAGE", line 21
ORA-06512: at "CRP2.ACTIVE_PROC_DYN", line 13
ORA-06512: at "CRP2.MDP_ADD", line 571
ORA-06512: at line 1

To pinpoint where the error was, the user ran the dynamic_mdp_add procedure and the following
error occurred:

ORA-12801: error signaled in parallel query server P055
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "CRP2.DYNAMIC_MDP_ADD", line 19
ORA-06512: at line 1

STEPS
The issue can be reproduced at will with the following steps:
1. Apply Demantra 7.1.1 CU1 patch 6375504
2. Run the MDP_ADD procedure
3. Run the DYNAMIC_MDP_ADD Procedure

Changes

Applied Demantra 7.1.1 CU1 patch 6375504

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms