This discussion is archived
3 Replies Latest reply: Dec 4, 2012 5:21 AM by PeakIndicators_Alastair RSS

ORA-00942 while exporting scenarios from an execution repository

Vesko Jel Newbie
Currently Being Moderated
I'm trying to export all scenarios from the command line:

#startcmd.sh OdiExportAllScen -TODIR=/some/dir

but I get following error:

java.lang.RuntimeException: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiExportAllScen
at oracle.odi.oditools.OdiAbstractToolRunner$3.doAction(OdiAbstractToolRunner.java:197)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.oditools.OdiAbstractToolRunner.executeConnectedCoreTool(OdiAbstractToolRunner.java:184)
at oracle.odi.oditools.OdiAbstractToolRunner.access$0(OdiAbstractToolRunner.java:180)
at oracle.odi.oditools.OdiAbstractToolRunner$2.doInTransactionWithoutResult(OdiAbstractToolRunner.java:147)
at oracle.odi.core.persistence.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:21)
at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:99)
at oracle.odi.oditools.OdiAbstractToolRunner.executeCoreTool(OdiAbstractToolRunner.java:143)
at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:48)
at oracle.odi.ToolRunner.main(ToolRunner.java:74)
Caused by: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiExportAllScen
at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:176)
at oracle.odi.oditools.OdiAbstractToolRunner.access$1(OdiAbstractToolRunner.java:168)
at oracle.odi.oditools.OdiAbstractToolRunner$3.doAction(OdiAbstractToolRunner.java:193)
... 9 more
Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-00942: table or view does not exist


Any idea what's going on?

Edited by: Vesko Jel on Nov 30, 2012 2:37 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points