3 Replies Latest reply: Dec 4, 2012 7:21 AM by PeakIndicators_Alastair RSS

    ORA-00942 while exporting scenarios from an execution repository

    Vesko Jel
      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