ODI11g调用DBLink时报ORA-28267: Invalid NameSpace Value错误
来源:互联网 发布:ios10.2.1网络验证失败 编辑:程序博客网 时间:2024/05/29 02:38
环境:ODI 11.1.1.5.0
在用odi111150调用Oracle 11g数据库中的DBlink时,报如下错误:
ODI-1228: 目标ORACLE连接ETL_UAT上的任务SJQY_PRODUCT_IMPORT_PKG.REFRESH_MV (Procedure) 失败。
Caused By: java.sql.SQLSyntaxErrorException: ORA-04052: 在查找远程对象 SOAU.SYS@EC_UAT 时出错
ORA-00604: 递归 SQL 级别 2 出现错误
ORA-28267: Invalid NameSpace Value
ORA-02063: 紧接着 line (起自 EC_UAT)
ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 2558
ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 2771
ORA-06512: 在 "SYS.DBMS_SNAPSHOT", line 2740
ORA-06512: 在 line 3
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
×××××××××××××××××××××××××××××××××
执行代码:
BEGIN
-- SJQY_PRODUCT_IMPORT_PKG.REFRESH_MV;
DBMS_MVIEW.refresh('TEMP_CTGY_ITEM_MV', atomic_refresh => false);
END;
经过测试在ODI11.1.1.6.0上面也报这个错误。
经过最终用确认,造成该错误的原因是Oracle 11g DB的bug,如果该procedure建在Oracle10g DB上则不会出现问题。
oracle给出的解释是:JDBC在调用Oracle 11g中的DBLink时有bug,解决方式就是给Database 打Patch
注意:导致该问题不是DBlink的问题,是通过JDBC调用DBlink有问题。
- ODI11g调用DBLink时报ORA-28267: Invalid NameSpace Value错误
- dblink ora-01017错误
- 在使用dblink时报错:ORA-01017、ORA-02063解决
- 导入时报ORA-39095错误
- ORA-00911: invalid character错误
- impdp时报ORA-39083、ORA-00959错误
- java中JDBCf访问数据库时报java.sql.SQLException: ORA-01017: invalid username/password; logon denied的错误
- ora DBLink.
- Invalid field value for field ---文件上传时报错
- 低版本使用dblink连接11G版本时报错ora-02063/ora-01017
- 错误"Invalid value around character 0"
- 错误:Invalid value around character 0.
- delphi 7 调用web services时报 Invalid at the top level of the document错误的解决方法
- Navicat 连接 oracle 时报 ORA-28547 错误
- ASM添加磁盘时报 ORA-15020错误
- Oracle dblink调用函数报ORA-00904 标识符无效
- Oracle-ORA-01722 invalid number错误
- ORA-00904:invalid identifier错误的解决办法
- Lua文件函数调用
- oracle update 多表关联
- Neither the JAVA_HOME nor the JRE_HOME environment variable is defined 错误解决
- Uva OJ 10167 birthday cake
- cortex-A8上3G模块的支持
- ODI11g调用DBLink时报ORA-28267: Invalid NameSpace Value错误
- UTF-8转GB2312
- JavasSript中类的实现
- 配置django连接SQL Server 2005
- core文件设置
- spring中的装配集合
- 数据一致性: 时间戳策略
- 软件开发的质量红线
- 如何在JSP页面使用JSTL标签获取List的元素个数