OdiImportObject Is Throwing "Table or view does not exist" Error While Importing Datastore in ODI 11g
(Doc ID 2261577.1)
Last updated on SEPTEMBER 14, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]Information in this document applies to any platform.
Symptoms
While trying to import model into Oracle Data Integrator (ODI) 11g, datastore and project using ODIImportObject. It is importing the model but throwing following error while importing datastore:
Caused by: com.sunopsis.dwg.SQLMasterReposException: ORA-00942: table or view does not exist
The command being run is:
sh $ODI_HOME/bin/startcmd.sh OdiImportObject -FILE_NAME="<DATASTORE_EXPORT_FILENAME>.xml" -WORK_REP_NAME=<WORK_REPOSITORY> -IMPORT_MODE=SYNONYM_INSERT_UPDATE
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 |