0 Replies Latest reply on Jan 30, 2013 4:26 AM by User207063

    unable to import load plan

    User207063
      Hi,

      We are trying to import a load plan from development work repository into an execution work repository and it errors out with table or view does not exist, looks like its looking for snp_object_id and it does not exists in work repository. I have checked E_CREATE.xml file that gets executed at creation of a execution work repository and it does not have snp_object_id table in it. are there any restrictions on load plan import from dev work repository to a execution work repository. I am able to import same load plan to another dev work repository without any issue.



      error below

      Work Repositories
      com.sunopsis.dwg.SQLWorkReposException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
      at sun.reflect.GeneratedMethodAccessor432.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
      at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
      at $Proxy3.executeUpdate(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor432.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)
      at $Proxy4.executeUpdate(Unknown Source)
      at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:712)
      at com.sunopsis.dwg.dbobj.generated.GeneratedSnpObjectId.insertAction(GeneratedSnpObjectId.java:279)
      at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3288)
      at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3316)
      at com.sunopsis.dwg.DwgObject.createMissingReference(DwgObject.java:8042)
      at com.sunopsis.dwg.DwgObject.correctMissingReference(DwgObject.java:7854)
      at com.sunopsis.dwg.DwgObject.correctMissingReferences(DwgObject.java:8480)
      at com.sunopsis.dwg.DwgObject.correctMissingReferences(DwgObject.java:84