How To Import CSV File For Customer With Multiple Contact Points (Doc ID 1453147.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Fusion Trading Community Hub - Version 11.1.2.0.0 to 11.1.2.0.0 [Release 1.0]
Oracle Fusion Customer Data Steward Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Customer Management Foundation for Organizations Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Customer Management Foundation for Persons Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

When attempting to import more than one Contact Point for a Customer directly the following error occurs:
INFO 8959501 - HZ_IMPORT_MATCH - 24 - CONTACTPTS_MATCH - Error - Error Message : ODI-1226: Step CONTACTPTS_MATCH fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53) at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1101)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:575) at
com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Sn
ERROR ODI-1226: Step CONTACTPTS_MATCH fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1101) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:575)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProce
ERROR 8967501 - CONTACTPTS_MATCHING: ODI-1217: Session CONTACTPTS_MATCHING (8967501) fails with return code 12801.
ODI-1226: Step CONTACTPTS_MATCH fails after 1 attempt(s). ODI-1240: Flow CONTACTPTS_MATCH fails while performing a Integration operation.
This flow loads target table HZ_IMP_CONTACTPTS_T. ODI-1228: Task CONTACTPTS_MATCH (Integration) fails on the target ORACLE connection ORACLE_FUSION.
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P003 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle
ERROR CDM Import : Process MATCHING Error at 23-APR-2012 03:21:17 Step Name CONTACTPTS_MATCH
The process is starting loading data into import interface tables. 

How To Import CSV File For Customer With Multiple Contact Points?

 

Solution

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