This discussion is archived
0 Replies Latest reply: Jan 29, 2013 8:26 PM by User207063 RSS

unable to import load plan

User207063 Newbie
Currently Being Moderated
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

Legend

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