FDM Import From ERPi Returns Error "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" in ERPI Source Adapter Log (Doc ID 1645741.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.2.000 and later
Information in this document applies to any platform.
9.21.15

Symptoms

When attempting to import data from ERPi into FDM the import operation fails with error:

Invalid Data or Empty Content
Import Failed

The ERPi-Fin-E1.log in the <ApplicationFolder>\<AppName>\Outbox\Logs directory displays:

-----------------------------------------------------------------------------
*** clsGetFinData.ExecuteCOMJNI @ 4/8/2014 9:21:54 AM ***
-----------------------------------------------------------------------------
m_strSSOToken = 8xgj0oje07oEQ3FfOrpuIhNGX/QazP0Lqz9hef8FYik3mPGzJFG6nTVoQiQuxfxRLsSyKZGg/FOR
GB2ToxzWUThyMTz2f4LIRwoo/noTcKAYyihaCUlMLy+8RfZ+fKQQg0nBfWuzshdOfnYckPLojlH8
EeuvmwpCVN+GMhgl0SREr6M5bCkzhUySJqPUwxdBMuWCrUji4mOW6Uhw5vISoHPbKFbL4lfTA0C9
pLxRCRBudBDXQGO3LaDvtIZWR2zRSvmSEr9878Ix3XhbZ0EehjS4KotSTPAIe3bSLDCiR4yiPeFi
Q1VkzgQ6GJxEYGa/tQeyba6BHPWPPBUd6tslCg==
m_ERPIdbConnString = Oracle://<dbhost>:1521/<service>
m_ERPIdbUserID = ERPI
m_ERPIdbPassword.Length = 6

-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
*** clsGetFinData.ConnectERPI @ 4/8/2014 9:21:54 AM ***
-----------------------------------------------------------------------------
System.Runtime.InteropServices.COMException (0x80004005): ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
 at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
 at fdmERPIfinE1.dbClass.ConnectDB()
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
*** clsGetFinData.fConnect @ 4/8/2014 9:21:54 AM ***
-----------------------------------------------------------------------------
TNS Error: Could not connect to ERPI database.
-----------------------------------------------------------------------------

 

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