Demantra 12.2.3 - Create Simular Product - Error ORA-30683 ODPM-70420, ORA-06512: in "SYS.DBMS_DEBUG_JDWP"

(Doc ID 1905097.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.3 version, When using the Create Similar Product Option of Demantra, it fails and produces the errors

ERROR
-----------------------
Screen ODPM-70420: Create Similar Item process failed.
--
Java log in file: NPI_Java_Console.log
--------------------------
2014-07-04 22:09:14,134 CDT [Method_Notifier_Thread] ERROR level.method :: Error in running workflow schema:  'Create Similar Product'.
Program internal error:ODPM-70420: Create Similar Item process failed.

2. Collaborator log
------------------------------------
2014-07-03 22:32:29,794 CDT [Level_Method_7_bridge_Create similar product] DEBUG appserver.level_method: ODPM-20202: Workflow process (Schema Create Similar Product, SID 1333) has started.
2014-07-03 22:32:29,805 CDT [Level_Method_7_bridge_Create similar product] INFO  workflow.general: [NPIStep] ****** STEP::STARTS ******
2014-07-03 22:32:29,807 CDT [Level_Method_7_bridge_Create similar product] WARN  workflow.general: [NPIStep] Statement Batch Clear failed
2014-07-03 22:32:29,808 CDT [Level_Method_7_bridge_Create similar product] WARN  workflow.general: [NPIStep] Statement Batch Clear failed
2014-07-03 22:32:29,812 CDT [Level_Method_7_bridge_Create similar product] ERROR workflow.general: [NPIStep] ORA-30683: failure establishing connection to debugger
ORA-12541: TNS:no listener
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
[Additional info: null]
java.sql.SQLException: ORA-30683: failure establishing connection to debugger
ORA-12541: TNS:no listener
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1

3.  Other collateral errors:
-----------------------------
Collaborator.log
2014-07-03 13:44:34,509 CDT [Level_Method_0] ERROR workflow.general: [NPIStep] ORA-01031:insufficient privileges
ORA-06512: at"SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1 [Additional info: null]
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at"SYS.DBMS_DEBUG_JDWP", line 68

2014-07-03 13:44:34,524 CDT [Level_Method_0]
FATAL workflow.general: ODPM-70420: Create Similar Item process failed.
java.lang.RuntimeException: ODPM-70420: Create Similar Item process failed. at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source)


Users cannot use NPI process

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