'ODI-23040 Import File Error' Signaled When Attempting To Import Projects And Models With ODI 11g

(Doc ID 1599783.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.6.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to import objects in Synonym INSERT_UPDATE mode into an Oracle Data Integrator (ODI) 11g Repository, the following error message is displayed:

ODI-23040 Import file error

The following complementary error stack is displayed during the import operation if ODI Studio is launched from a Windows command prompt:

Not a valid option for JRockitoracle.xml.parser.v2.XMLParseException: Expected 'EOF'.
 at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:323)
 at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:376)
 at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:226)
 at com.sunopsis.tools.xml.SnpsXmlObjectParser.parseXmlFile(SnpsXmlObjectParser.java:379)
 at com.sunopsis.tools.xml.SnpsXmlObjectParser.parseXmlFile(SnpsXmlObject

When opening the XML file with a Web browser, following message could be observed:

XML Parsing Error: junk after document element
Location: file:///...MyFolder/MOD_MyModel.xml
Line Number 5339, Column 1:[null]]>

When opening the xml file the file may be incomplete. It is expected to end in "</SunopsisExport>", but it is not, ie:

<Object class="com.sunopsis.dwg.dbobj.SnpReferencedObject">
<Field name="IObject" type="com.sunopsis.sql.DbInt"><![CDATA[3100]]></Field>
<Field name="ObjectPKasString" type="java.lang.String"><![CDATA[5485052]]></Field>
<Field name="ObjectAKasString" type="java.lang.String"><![CDATA[]]></Field>
<Field name="Description" type="java.lang.String"><![CDATA[SNP_PRO

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms