My Oracle Support Banner

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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.