Collections EBS full Download Workflow errors at NPIStep_ONGOING ORA-20001: OnGoing Copy terminated
(Doc ID 1999237.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Oracle Demantra Demand Management - Version 12.2.4 and later Information in this document applies to any platform.
Symptoms
Customer is on 12.2.4 and running collections and they hit the issue at NPIStep_ONGOING. Job Errors out trying to pull EBS data into Demantra at the NPIStep_ONGOING step of the EBS Full Download workflow
2015-03-22 16:53:20,542 CDT [WFProcess_10] WARN workflow.general: [NPIStep] Statement Batch Clear failed 2015-03-22 16:53:20,588 CDT [WFProcess_10] FATAL workflow.general: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series] java.lang.RuntimeException: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series] at com.demantra.workflow.step.NPIStep.executeStep(Unknown Source) at com.demantra.workflow.step.CustomStepHost.doExecute(CustomStepHost.java:196) at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:944) at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281) at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662) at com.demantra.workflow.process.WFProcess.execute(WFProcess.java:630) at com.demantra.workflow.process.WFProcess.launch(WFProcess.java:578) at com.demantra.workflow.step.LaunchWorkflowStep.doExecute(LaunchWorkflowStep.java:579) at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:944) at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281) at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.Exception: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001: OnGoing Copy terminated! 2 combination(s) in NPI_SERIES_DATA is repeating OR shares a common target series] at com.demantra.NPI.OnGoingCopyProcess.onGoingSeriesCopy(Unknown Source) at com.demantra.NPI.OnGoingCopyProcess.runProcess(Unknown Source) at com.demantra.NPI.NPIProcess.execute(Unknown Source) ... 12 more 2015-03-22 16:53:20,590 CDT [WFProcess_10] ERROR dpweb.general: #################################### Step Failure. #################################### 2015-03-22 16:53:20,590 CDT [WFProcess_10] ERROR dpweb.general: Process ID: 781956 Schema ID: 1336 Schema name: 'Data Modification Create Similar' Step ID: 'Step1' Step name: 'NPIStep_ONGOING'
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.