TCA: Customer Data Import Is Getting Into Error Status As Soon As It Is Imported In Fusion Stage.

(Doc ID 1476142.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Common CRM - Version 1.0-Beta and later
Information in this document applies to any platform.

Symptoms

While looking into ESS logs, could see below error while connecting to ODI
=====
ODI-1274: Agent Exception Caused by: ODI-1419: Warning connecting to Agent FusionCrmOdiAgent: JDBC connection error occurs while connecting to the work repository FUSIONAPPS_WREP.
Caused by: oracle.odi.core.config.WorkRepositoryResourceFailureException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
-----

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