My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.