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:

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

Problem Description
---------------------------------------------------
Process ID: 781956
Schema ID: 1336
Schema name: ’’Data Modification Create Similar’’
Step ID: ’’Step1’’
Step name: ’’NPIStep_ONGOING’’

Error description ’’Program internal error:’’


Error Codes
---------------------------------------------------
ORA-20001 - workflow.general: Ongoing Copy completed with errors [return code: *-ERROR-*:-20001 : ORA-20001


Collaborator logs show

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'

Error description 'Program internal error:'
2015-03-22 16:53:20,590 CDT [WFProcess_10] ERROR dpweb.general: ######################################################################################

Cause