0 Replies Latest reply on Jan 24, 2014 4:21 AM by user277913 - oracle

    Migration Import Issue

    user277913 - oracle

      Hi All,
          Please help me sort the issue with the migration. When I try to import the contents from server1 to server2, I am facing an issue with the import. Some table seems to be missing because of which i am not able to import any content to the server2. Adding to the worry is that the table which is missing is also not shown. The export of contents from server1 seems to have gone fine and no issues have been caused. Below I have pasted the error log generated by the archive on import. Please look at the log and let me know if you could help me out with the same. Thanks in Advance.


       

      Import error for archive 'test' in collection 'nacismkpl203usoraclecom10100': Unable to execute service INSERT_NEW and function validateStandard.
      Unable to create the result set for query 'select * from where dDocName='GMKP_040460''. ORA-00903: invalid table name
      java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name. [ Details ]

       

      An error has occurred. The stack trace below shows more information.

      !csImportErrorForArchiveInCollection,test,nacismkpl203usoraclecom10100!csServiceDataException,INSERT_NEW,validateStandard!$!csDbUnableToCreateResultSet,select * from where dDocName='GMKP_040460'!$ORA-00903: invalid table name<br>!syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name<br>
      intradoc.common.ServiceException: !csServiceDataException,INSERT_NEW,validateStandard!$
        at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2115)
        at intradoc.server.Service.buildServiceException(Service.java:2260)
        at intradoc.server.Service.createServiceExceptionEx(Service.java:2254)
        at intradoc.server.Service.createServiceException(Service.java:2249)
        at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1766)
        at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1716)
        at intradoc.server.Service.doAction(Service.java:477)
        at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
        at intradoc.server.Service.doActions(Service.java:472)
        at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1322)
        at intradoc.server.Service.executeSubServiceCode(Service.java:3866)
        at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1200)
        at intradoc.server.Service.executeServiceEx(Service.java:3861)
        at intradoc.server.Service.executeService(Service.java:3845)
        at intradoc.server.ArchiveCheckinHandler.processCheckinArchive(ArchiveCheckinHandler.java:188)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
        at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
        at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
        at dynamicconverter.DynConverterHandler.processCheckinArchive(DynConverterHandler.java:2678)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
        at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
        at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
        at intradoc.server.Service.doCodeEx(Service.java:533)
        at intradoc.server.Service.doCode(Service.java:505)
        at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
        at intradoc.server.Service.doAction(Service.java:477)
        at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
        at intradoc.server.Service.doActions(Service.java:472)
        at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
        at intradoc.server.Service.executeActions(Service.java:458)
        at intradoc.server.ServiceRequestImplementor.doRequestInternalEx(ServiceRequestImplementor.java:936)
        at intradoc.server.Service.doRequestInternal(Service.java:1923)
        at intradoc.server.archive.ArchiveHandler.executeCommand(ArchiveHandler.java:1509)
        at sitestudio.SSArchiveHandler.executeCommand(Unknown Source)
        at intradoc.server.archive.ArchiveHandler.processBatch(ArchiveHandler.java:2386)
        at intradoc.server.archive.ArchiveHandler.importExportFile(ArchiveHandler.java:1978)
        at intradoc.server.archive.ArchiveHandler.doImport(ArchiveHandler.java:1805)
        at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:265)
        at intradoc.server.archive.ArchiverMonitor.doArchiving(ArchiverMonitor.java:565)
        at intradoc.server.archive.ArchiverMonitor$4.run(ArchiverMonitor.java:652)
        at java.lang.Thread.run(Thread.java:662)
      Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet,select * from where dDocName='GMKP_040460'!$ORA-00903: invalid table name


      at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
        at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:791)
        at com.oracle.gmkp.custom.CustomFilter.DuplicateFileCheck(CustomFilter.java:69)
        at com.oracle.gmkp.custom.CustomFilter.doFilter(CustomFilter.java:49)
        at intradoc.shared.PluginFilters.filterWithAction(PluginFilters.java:115)
        at intradoc.shared.PluginFilters.filter(PluginFilters.java:68)
        at intradoc.server.DocServiceHandler.validateStandard(DocServiceHandler.java:1168)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
        at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
        at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
        at intradoc.server.Service.doCodeEx(Service.java:533)
        at intradoc.server.Service.doCode(Service.java:506)
        at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
        at intradoc.server.Service.doAction(Service.java:477)
        at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
        at intradoc.server.Service.doActions(Service.java:473)
        at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1323)
        at intradoc.server.Service.executeSubServiceCode(Service.java:3867)
        at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1200)
        at intradoc.server.Service.executeServiceEx(Service.java:3862)
        at intradoc.server.Service.executeService(Service.java:3846)
        at intradoc.server.ArchiveCheckinHandler.processCheckinArchive(ArchiveCheckinHandler.java:189)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
        at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
        at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
        at dynamicconverter.DynConverterHandler.processCheckinArchive(DynConverterHandler.java:2678)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
        at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
        at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
        at intradoc.server.Service.doCodeEx(Service.java:533)
        at intradoc.server.Service.doCode(Service.java:506)
        at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
        at intradoc.server.Service.doAction(Service.java:477)
        at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
        at intradoc.server.Service.doActions(Service.java:473)
        at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
        at intradoc.server.Service.executeActions(Service.java:458)
        at intradoc.server.ServiceRequestImplementor.doRequestInternalEx(ServiceRequestImplementor.java:936)
        at intradoc.server.Service.doRequestInternal(Service.java:1924)
        at intradoc.server.archive.ArchiveHandler.executeCommand(ArchiveHandler.java:1509)
        at sitestudio.SSArchiveHandler.executeCommand(Unknown Source)
        at intradoc.server.archive.ArchiveHandler.processBatch(ArchiveHandler.java:2386)
        at intradoc.server.archive.ArchiveHandler.importExportFile(ArchiveHandler.java:1981)
        at intradoc.server.archive.ArchiveHandler.doImport(ArchiveHandler.java:1805)
        at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:265)
        at intradoc.server.archive.ArchiverMonitor.doArchiving(ArchiverMonitor.java:565)
        at intradoc.server.archive.ArchiverMonitor$4.run(ArchiverMonitor.java:652)
        at java.lang.Thread.run(Thread.java:662)
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name