DIH Connector Execution Batch Fails With ORA-12650 Error
(Doc ID 2831061.1)
Last updated on JANUARY 05, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
on DIH 8.1.1
DIH Connector execution failing wit the below error:
[ScenarioExecutor$1][write] Error msg -
ODI-1228: Task Create Temp table-LKM MultiFiles to Oracle (SQLLDR)- fails on the target connection FSDFINFO.
Caused By: java.sql.SQLException: Oracle Error ORA-12650
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
Changes
The JDBC URL of the data source for the infodom in ODI was modified.
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 |
Changes |
Cause |
Solution |