ORA-28267: Invalid NameSpace Value using a remote DBLINK
Hi,
I've created an interface INTERFACE1 to map, via SQL_as_Source IKM, the results of a query on a local table & an other remote table accessed via DB-LINK..
The INTERFACE1 become table source on an other INTERFACE2 that copy all the values via Oracle Incremental Update on a local table.
The query it's something like this:
+
select b.customer_id, a.name
from local_table a, remote_table@remote_link b
where a.customer_id=b.customer_id(+)
+
Running the INTERFACE2 via Local Agent or Oracle Agent it's work fine, but if I run it via OracleDIAgent it's report the following error:
ODI-1228: Errore del task INTERFACE2 (Integrazione) sulla connessione ORCL - BSM_ELAB della destinazione ORACLE.
Caused By: java.sql.SQLException: ORA-28267: Invalid NameSpace Value
ORA-02063: precedente line da SITEST_LNK
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:423)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1095)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1040)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1378)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1508)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:665)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3218)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java:1785)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2805)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.java:68)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
Creating an other instance on the locale DB and using an other local schema "as remote" DB via DBLINK the problem don't appear...
I would like to understand where the problem it's and let ODI manage all without writing a local "database" procedure to load only the needed remote data and without write an other interface to copy and keep updated all the remote table...
Versions:
Oracle Data Integrator 11g 11.1.1
Standalone Edition versione 11.1.1
Build ODI_11.1.1.3.0_GENERIC_100623.1635
Local Oracle: 11.1.0.7.0
Remote Oracle: 10.2.0.5.0