OBIA 12c : After Enabing ETL_SRC_VIADBLINK Parameter Load Plan Is Failing Not Refreshing The Variable (Doc ID 2992712.1)

Last updated on DECEMBER 19, 2023

Applies to:

Symptoms

For a new or existing OBIA 12c environment when using a DBlink for SDE phase, the following error may be displayed:

SDE_ORAR122_ADAPTOR_SDE_ORA_KEYFLEXFIELD_COLUMN session fails at this step and the error message is

ODI-1228: Task Create work object-LKM BIAPPS SQL to Oracle (Multi Transport)- fails on the target connection BIAPPS_DW.
Caused by: java.sql.SQLSyntaxErrorException: ORA-02083: database name has illegal character '.'

atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42)
atoracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:929)
atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
atoracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1921)
atoracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1876)
atoracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
atoracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:271)
atoracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
atoracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
atoracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
atoracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:217)
atoracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:129)
atoracle.odi.runti

Cause

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