FDM Regenerating the ODI Scenario Failing: "Error_Caused by: java.lang.Exception: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found" (Doc ID 2020049.1)

Last updated on OCTOBER 06, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.530 and later
Information in this document applies to any platform.

Symptoms

Regenerating ODI Scenario is failing with below error.

Caused by: java.lang.Exception: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 (jdbc:oracle:thin:@hyp-dbtst-aph.aboitizgroup.net:1521:HYPTST)

 

ErpIntegrator0 log throws below errors :


[2015-06-08T13:34:53.766+08:00] [ErpIntegrator0] [ERROR] [ERPI-105007] [oracle.apps.erpi.model] [tid: 27] [userId: <anonymous>] [ecid: 00iTd58qKYVFw0zqRG04Bz5Q2SU1jwIyx0002R800123R,0:1] [APP: AIF#11.1.2.0] [URI: /aif/faces/mainPage] [SRC_CLASS: com.hyperion.aif.odi.adapter.data.SourceAdapterDriver] [SRC_METHOD: regenerateScenario] EPMERPI Unexpected error occurred.[[
java.lang.RuntimeException: ERPI-105007:EPMERPI Unexpected error occurred.
at com.hyperion.aif.odi.common.util.OdiConstants.logAndThrowException(OdiConstants.java:490)
at com.hyperion.aif.odi.common.util.OdiConstants.getProfileOption(OdiConstants.java:345)
at com.hyperion.aif.odi.common.util.OdiInstanceHandle.validateProfileOptions(OdiInstanceHandle.java:234)

...


Caused by: java.lang.Exception: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 (jdbc:oracle:thin:@hyp-dbtst-aph.aboitizgroup.net:1521:HYPTST)
at com.hyperion.aif.util.RegistryUtilCore.getAIFDatabaseConnectionRegistry(RegistryUtilCore.java:150)
at com.hyperion.aif.odi.common.util.OdiConstants.getProfileOption(OdiConstants.java:340)
... 50 more

 

odiagent log :
-----------------
[2015-06-08T13:36:32.716+08:00] [ErpIntegrator0] [ERROR] [ODI-1212] [] [tid: 349] [userId: <anonymous>] [ecid: 0000KrHem4p3v1YzLoqIOA1LQyNC0004ce,1:32451] [APP: oraclediagent] Session preparation failure: scenario APDU_CAPEX does not exist in work repository FDMEE.
[2015-06-08T13:36:32.901+08:00] [ErpIntegrator0] [WARNING] [ODI-1134] [] [tid: 349] [userId: <anonymous>] [ecid: 0000KrHem4p3v1YzLoqIOA1LQyNC0004ce,1:32451] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1226: Step FAILED Process Detail - Extract fails after 1 attempt(s).
[2015-06-08T13:36:32.902+08:00] [ErpIntegrator0] [ERROR] [ODI-1217] [] [tid: 349] [userId: <anonymous>] [ecid: 0000KrHem4p3v1YzLoqIOA1LQyNC0004ce,1:32451] [APP: oraclediagent] Session ERP_GL_LOAD_BALANCES_DATA (2121501) fails with return code 7000.[[
ODI-1226: Step FAILED Process Detail - Extract fails after 1 attempt(s).
ODI-1232: Procedure COMM End Process Detail execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
 File "<string>", line 6, in <module>
 File "<string>", line 503, in getConnection
AttributeError: 'NoneType' object has no attribute 'setAutoCommit'

Changes

 New environment

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