"OdiToolException: Error while running ODI Tool OdiImportObject" Signalled When Running the ODI 11g OdiImportObject Tool From Command Line With "startcmd" Script
(Doc ID 1549386.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.6.3 [Release 11gR1]Information in this document applies to any platform.
Symptoms
When using the Oracle Data Integrator (ODI) version 11.1.1.5 or 11.1.1.6.x tool called OdiImportObject with the startcmd script with the following syntax:
.../startcmd.sh OdiImportObject -FILE_NAME="<FILE NAME>" "-WORK_REP_NAME=<WORK REPOSITORY NAME>" "-IMPORT_MODE=<IMPORT MODE>"
the following message is signaled and execution is interrupted:
OracleDI: Starting Command : OdiImportObject -FILE_NAME=<FILE NAME> -WORK_REP_NAME=<WORK REPOSITORY NAME> -IMPORT_MODE=<IMPORT MODE> ...
java.lang.RuntimeException: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiImportObject
at oracle.odi.oditools.OdiAbstractToolRunner$4.doAction(OdiAbstractToolRunner.java:216)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:183)
at oracle.odi.oditools.OdiAbstractToolRunner.executeConnectedCoreTool(OdiAbstractToolRunner.java:203)
....
Caused by: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiImportObject
at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:174)
at oracle.odi.oditools.OdiAbstractToolRunner.access$1(OdiAbstractToolRunner.java:166)
at oracle.odi.oditools.OdiAbstractToolRunner$4.doAction(OdiAbstractToolRunner.java:212)
.. 9 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |