ODI 11g 打开接口流视图时出错

2019独角兽企业重金招聘Python工程师标准>>>

错误异常：

java.io.IOException

at oracle.diagram.dif.DiagramIdeNode.getDiagram(DiagramIdeNode.java:226)

at oracle.modeler.dif.ModelerGraphicBridge.getGrapher(ModelerGraphicBridge.java:408)

at oracle.modeler.dif.ModelerGraphicBridge.getGrapher(ModelerGraphicBridge.java:326)

at oracle.modeler.addin.ModelerNode.findOrCreateManager(ModelerNode.java:212)

at oracle.modeler.addin.ModelerDiagram.findOrCreateGraphSystemFromContext(ModelerDiagram.java:338)

at oracle.diagram.framework.editor.CommonDiagram.open(CommonDiagram.java:219)

at oracle.modeler.addin.ModelerDiagram.open(ModelerDiagram.java:104)

at oracle.odi.ui.etlmodeler.custom.OdiModelerDiagram.access$0(OdiModelerDiagram.java:1)

at oracle.odi.ui.etlmodeler.custom.OdiModelerDiagram.open(OdiModelerDiagram.java:273)

at oracle.diagram.framework.editor.IdeDiagramEditor.openDiagram(IdeDiagramEditor.java:264)

at oracle.diagram.framework.editor.IdeDiagramEditor.open(IdeDiagramEditor.java:222)

at oracle.modeler.addin.ModelerEditor.open(ModelerEditor.java:74)

at oracle.odi.ui.editor.pop.OdiFlowModelerEditor.access$1(OdiFlowModelerEditor.java:1)

at oracle.odi.ui.editor.pop.OdiFlowModelerEditor$8.run(OdiFlowModelerEditor.java:724)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

at java.lang.Thread.run(Thread.java:662)

解决方案：

该问题已修复，并发布在ODI的版本1. 11.1.1.5.0。 

对于眼前的工作围绕贯彻落实修复提供ODI 11.1.1.5.0之前，你可以手动更新SNP_DIAGRAM和SNP_TXT工作 

对于损坏的集成接口库表，如下解释： 

从ODI Studio中，打开损坏的集成接口，进入“版本”选项卡，并得到内部ID。 

连接到承载的ODI工作库表的数据库，运行下面的SQL命令，并应用更改： 

--- 

delete from SNP_TXT

where I_TXT in (

select I_TXT_XMI_DATA

from SNP_DIAGRAM

where I_POP = <your internal ID>)?

delete from SNP_DIAGRAM

where I_POP = <your internal ID>?

commit；

--- 

当您打开集成接口旁边时，它会创建一个新的映射和流程映射

转载于:https://my.oschina.net/u/727883/blog/343803