Forum Stats

  • 3,769,238 Users
  • 2,252,937 Discussions
  • 7,874,957 Comments

Discussions

Archiver - Import error - Unsuccessful import

plishelpme
plishelpme Member Posts: 14
edited Aug 21, 2017 3:17AM in WebCenter Content

Hi People,

Trying to import contents in a server but im getting the below error and hence forth importing is aborted.

Import error for archive 'wcc_prod_backup1' in collection '1085731468010': Unable to execute service INSERT_NEW and function prepareInsertNew. [ Details ]

An error has occurred. The stack trace below shows more information. !csImportErrorForArchiveInCollection,wcc_prod_backup1,1085731468010!csServiceDataException,INSERT_NEW,prepareInsertNew!$!$ intradoc.common.ServiceException: !csServiceDataException,INSERT_NEW,prepareInsertNew!$ Import error for archive 'wcc_prod_backup1' in collection '1085731468010': Unable to execute service INSERT_NEW and function prepareInsertNew. [ Details ] An error has occurred. The stack trace below shows more information. !csImportErrorForArchiveInCollection,wcc_prod_backup1,1085731468010!csServiceDataException,INSERT_NEW,prepareInsertNew!$!$ intradoc.common.ServiceException: !csServiceDataException,INSERT_NEW,prepareInsertNew!$         at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2115)         at intradoc.server.Service.buildServiceException(Service.java:2337)         at intradoc.server.Service.createServiceExceptionEx(Service.java:2331)         at intradoc.server.Service.createServiceException(Service.java:2326)         at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1766)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1716)         at intradoc.server.Service.doAction(Service.java:547)         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)         at intradoc.server.Service.doActions(Service.java:542)         at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1322)         at intradoc.server.Service.executeSubServiceCode(Service.java:4034)         at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1200)         at intradoc.server.Service.executeServiceEx(Service.java:4029)         at intradoc.server.Service.executeService(Service.java:4013)         at intradoc.server.ArchiveCheckinHandler.processCheckinArchive(ArchiveCheckinHandler.java:196)         at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)         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:603)         at intradoc.server.Service.doCode(Service.java:575)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)         at intradoc.server.Service.doAction(Service.java:547)         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)         at intradoc.server.Service.doActions(Service.java:542)         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)         at intradoc.server.Service.executeActions(Service.java:528)         at intradoc.server.ServiceRequestImplementor.doRequestInternalEx(ServiceRequestImplementor.java:936)         at intradoc.server.Service.doRequestInternal(Service.java:1989)         at intradoc.server.archive.ArchiveHandler.executeCommand(ArchiveHandler.java:1563)         at intradoc.server.archive.ArchiveHandler.processBatch(ArchiveHandler.java:2475)         at intradoc.server.archive.ArchiveHandler.importExportFile(ArchiveHandler.java:2059)         at intradoc.server.archive.ArchiveHandler.doImport(ArchiveHandler.java:1858)         at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:266)         at intradoc.server.archive.ArchiverMonitor.doArchiving(ArchiverMonitor.java:581)         at intradoc.server.archive.ArchiverMonitor$4.run(ArchiverMonitor.java:668)         at java.lang.Thread.run(Thread.java:662) Caused by: intradoc.data.DataException:         at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2553)         at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:586)         at intradoc.server.DocServiceHandler.addRevClassesEntry(DocServiceHandler.java:676)         at intradoc.server.DocServiceHandler.makeNewRevClass(DocServiceHandler.java:627)         at intradoc.server.DocServiceHandler.prepareInsertNew(DocServiceHandler.java:462)         at sun.reflect.GeneratedMethodAccessor192.invoke(Unknown Source)         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:603)         at intradoc.server.Service.doCode(Service.java:575)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)         ... 33 more        at intradoc.server.Service.buildServiceException(Service.java:2337)         at intradoc.server.Service.createServiceExceptionEx(Service.java:2331)         at intradoc.server.Service.createServiceException(Service.java:2326)         at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1766)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1716)         at intradoc.server.Service.doAction(Service.java:547)         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)         at intradoc.server.Service.doActions(Service.java:542)         at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1322)         at intradoc.server.Service.executeSubServiceCode(Service.java:4034)         at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1200)         at intradoc.server.Service.executeServiceEx(Service.java:4029)         at intradoc.server.Service.executeService(Service.java:4013)         at intradoc.server.ArchiveCheckinHandler.processCheckinArchive(ArchiveCheckinHandler.java:196)         at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)         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:603)         at intradoc.server.Service.doCode(Service.java:575)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)         at intradoc.server.Service.doAction(Service.java:547)         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)         at intradoc.server.Service.doActions(Service.java:542)         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)         at intradoc.server.Service.executeActions(Service.java:528)         at intradoc.server.ServiceRequestImplementor.doRequestInternalEx(ServiceRequestImplementor.java:936)         at intradoc.server.Service.doRequestInternal(Service.java:1989)         at intradoc.server.archive.ArchiveHandler.executeCommand(ArchiveHandler.java:1563)         at intradoc.server.archive.ArchiveHandler.processBatch(ArchiveHandler.java:2475)         at intradoc.server.archive.ArchiveHandler.importExportFile(ArchiveHandler.java:2059)         at intradoc.server.archive.ArchiveHandler.doImport(ArchiveHandler.java:1858)         at intradoc.server.archive.ArchiveHandler.doArchiving(ArchiveHandler.java:266)         at intradoc.server.archive.ArchiverMonitor.doArchiving(ArchiverMonitor.java:581)         at intradoc.server.archive.ArchiverMonitor$4.run(ArchiverMonitor.java:668)         at java.lang.Thread.run(Thread.java:662) Caused by: intradoc.data.DataException:         at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2553)         at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:586)         at intradoc.server.DocServiceHandler.addRevClassesEntry(DocServiceHandler.java:676)         at intradoc.server.DocServiceHandler.makeNewRevClass(DocServiceHandler.java:627)         at intradoc.server.DocServiceHandler.prepareInsertNew(DocServiceHandler.java:462)         at sun.reflect.GeneratedMethodAccessor192.invoke(Unknown Source)         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:603)         at intradoc.server.Service.doCode(Service.java:575)         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)         ... 33 more

Can anyone please guide me through this problem ?

Thanks,

Goutham

Tagged:

Answers

  • Raja Kummathi
    Raja Kummathi Member Posts: 742 Silver Badge
    edited Aug 17, 2017 9:09AM

    Hi ,

    Enable systemdatabase , archiver and acrhiberlocks trace from system audit information will give more information.

    For more info

    https://docs.oracle.com/cd/E21043_01/doc.1111/e11011/c07_archive002.htm#i3268170

    7.2.40 INSERT_NEW

    Subservice used during a CHECKIN_ARCHIVE when the system has discovered no prior item with the specified dDocName. This subservice is used during a batch load and during an archive import operation. It adds a new content item into the system and creates new IDs (such as dID, dRevClassID) for it.

    Location: IdcHomeDir/resources/core/templates/std_services.htm

    To disallow the check in of empty files, set the following: ValidatePrimaryFileNotEmpty=1

    --Raja

  • plishelpme
    plishelpme Member Posts: 14
    edited Aug 17, 2017 9:51AM

    Hi Raja,


    Im migrating a lot of contents hence i have given a part of the Server output after enabling Archiver, archiverlocks, SystemDatabase.

    >systemdatabase/6      08.17 08:40:56.291     index update work      1.04 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.291     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.291     index update work WHERE dRevClassID = 109171

    systemdatabase/6      08.17 08:40:56.291     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.291     index update work      Batched query added at index 72: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.291     index update work WHERE dRevClassID = 109171

    systemdatabase/6      08.17 08:40:56.291     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.291     index update work AND (dID <= 93511 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.294     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.294     index update work      begin tran - soft

    >archiver/6    08.17 08:40:56.295     Archive run        1,111.0,180.0,!csExportingArchiveInCollection\wcc_prod_backup1\1085731398010!csProgressDeletingContentItem

    >systemdatabase/6      08.17 08:40:56.296     Archive run    begin tran - soft

    >systemdatabase/6      08.17 08:40:56.297     index update work      2.27 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 108060[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.298     index update work      0.94 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.298     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.298     index update work WHERE dRevClassID = 108060

    systemdatabase/6      08.17 08:40:56.298     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.298     index update work      Batched query added at index 73: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.298     index update work WHERE dRevClassID = 108060

    systemdatabase/6      08.17 08:40:56.298     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.298     index update work AND (dID <= 92409 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.299 Archive run    2.11 ms. SELECT/*+ USE_NL (Revisions DocMeta) LEADING(Revisions)INDEX (Revisions PK_Revisions)*/ Revisions.*, DocMeta.*

    systemdatabase/6      08.17 08:40:56.299     Archive run FROM Revisions, DocMeta

    systemdatabase/6      08.17 08:40:56.299     Archive run WHERE Revisions.dID=93203 AND Revisions.dID = DocMeta.dID[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.301     Archive run    1.65 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dDocName = 'TMS_PROD1033286'[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.302     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.302     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.303     Archive run    1.21 ms. INSERT INTO DocumentHistory (dActionMillis, dActionDate, dID, dRevClassID, dUser, dDocName, dAction, dSecurityGroup)

    systemdatabase/6      08.17 08:40:56.303     Archive run values(192236301, {ts '2017-08-17 08:40:00.000'}, 93203, 108862, 'weblogic', 'TMS_PROD1033286', 'Delete Revision', 'TMS_CAD')[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.303     index update work      0.81 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 107198[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.304     index update work      1.01 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.304     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.304     index update work WHERE dRevClassID = 107198

    systemdatabase/6      08.17 08:40:56.304     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.304     Archive run    0.93 ms. SELECT * FROM ProjectDocuments where dDocName='TMS_PROD1033286'[Executed. Returned row(s): false]

    >systemdatabase/6      08.17 08:40:56.305     index update work      Batched query added at index 74: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.305     index update work WHERE dRevClassID = 107198

    systemdatabase/6      08.17 08:40:56.305     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.305     index update work AND (dID <= 91567 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.306     Archive run    1.17 ms. SELECT * FROM RefineryJobs WHERE dID = 93203 AND dConversionState <> 'Finished'[Executed. Returned row(s): false]

    >systemdatabase/6      08.17 08:40:56.307     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.307     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.307     Archive run    1.26 ms. UPDATE RevClasses SET dDocLastModifier = 'weblogic', dDocLastModifiedDate = {ts '2015-08-14 14:12:46.585'} WHERE dRevClassID = 108862[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.308     index update work      0.70 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 107575[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.309     Archive run    1.17 ms. SELECT * FROM FolderFiles WHERE dDocName='TMS_PROD1033286'[Executed. Returned row(s): false]

    >systemdatabase/6      08.17 08:40:56.311     index update work      2.64 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.311     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.311     index update work WHERE dRevClassID = 107575

    systemdatabase/6      08.17 08:40:56.311     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.311     Archive run    2.15 ms. SELECT * FROM FolderFiles WHERE dDocName='TMS_PROD1033286' AND fLinkRank=0[Executed. Returned row(s): false]

    >systemdatabase/6      08.17 08:40:56.311     index update work      Batched query added at index 75: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.311     index update work WHERE dRevClassID = 107575

    systemdatabase/6      08.17 08:40:56.311     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.311     index update work AND (dID <= 91935 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.313     Archive run    1.25 ms. UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dRevRank=dRevRank-1 WHERE dRevClassID=108862 and dID<93203[Executed. 0 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.314     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.314     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.314     Archive run    1.14 ms. SELECT/*+ INDEX (Documents dID_2_Documents)*/ * FROM Documents WHERE Documents.dID=93203[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.315     index update work      0.81 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 109203[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.316     index update work      0.72 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.316     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.316     index update work WHERE dRevClassID = 109203

    systemdatabase/6      08.17 08:40:56.316     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.316 index update work      Batched query added at index 76: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.316     index update work WHERE dRevClassID = 109203

    systemdatabase/6      08.17 08:40:56.316     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.316     index update work AND (dID <= 93543 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.318     Archive run    1.24 ms. UPDATE/*+ INDEX (Revisions PK_Revisions)*/ Revisions

    systemdatabase/6      08.17 08:40:56.318     Archive run SET dStatus = 'DELETED', dReleaseState = 'U', dIndexerState = ' '

    systemdatabase/6      08.17 08:40:56.318     Archive run WHERE dID=93203[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.319     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.319     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.320     Archive run    1.20 ms. SELECT/*+ INDEX (Revisions dDocName_Revisions)*/ Revisions.dRevClassID

    systemdatabase/6      08.17 08:40:56.320     Archive run FROM Revisions

    systemdatabase/6      08.17 08:40:56.320     Archive run WHERE (Revisions.dDocName='TMS_PROD1033286' AND Revisions.dStatus<>'DELETED')[Executed. Returned row(s): false]

    >systemdatabase/6      08.17 08:40:56.320     index update work      0.86 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 108637[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.323     index update work      2.89 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.323     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.323     index update work WHERE dRevClassID = 108637

    systemdatabase/6      08.17 08:40:56.323     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.323     Archive run    3.11 ms. DELETE FROM Subscription WHERE dSubscriptionID='TMS_PROD1033286' AND dSubscriptionType='Basic'[Executed. 0 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.323     index update work Batched query added at index 77: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.323     index update work WHERE dRevClassID = 108637

    systemdatabase/6      08.17 08:40:56.323     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.323     index update work AND (dID <= 92980 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.326     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.326     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.328     index update work      1.09 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 106692[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.331     index update work      3.09 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.331     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.331     index update work WHERE dRevClassID = 106692

    systemdatabase/6      08.17 08:40:56.331     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.332     index update work      Batched query added at index 78: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.332     index update work WHERE dRevClassID = 106692

    systemdatabase/6      08.17 08:40:56.332 index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.332     index update work AND (dID <= 91070 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.334     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.335     index update work      begin tran - soft

    >systemdatabase/6      08.17 08:40:56.338     index update work      3.09 ms. UPDATE RevClasses SET dRevClassID = dRevClassID WHERE dRevClassID = 109239[Executed. 1 row(s) affected.]

    >systemdatabase/6      08.17 08:40:56.338     Archive run    tran committed

    >systemdatabase/6      08.17 08:40:56.341     index update work 2.75 ms. SELECT/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup

    systemdatabase/6      08.17 08:40:56.341     index update work FROM Revisions

    systemdatabase/6      08.17 08:40:56.341     index update work WHERE dRevClassID = 109239

    systemdatabase/6      08.17 08:40:56.341     index update work ORDER BY dID DESC[Executed. Returned row(s): true]

    >systemdatabase/6      08.17 08:40:56.342     index update work      Batched query added at index 79: UPDATE/*+ INDEX (Revisions dRevClassID_2_Revisions)*/ Revisions SET dIndexerState = 'A'

    systemdatabase/6      08.17 08:40:56.342     index update work WHERE dRevClassID = 109239

    systemdatabase/6      08.17 08:40:56.342     index update work AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)

    systemdatabase/6      08.17 08:40:56.342     index update work AND (dID <= 93579 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))

    >systemdatabase/6      08.17 08:40:56.344     index update work      rollback tran

    >systemdatabase/6      08.17 08:40:56.345     index update work      begin tran - soft

    Thanks,

    Goutham

  • plishelpme
    plishelpme Member Posts: 14
    edited Aug 17, 2017 9:53AM

    Please note that the first time i imported the same thing the contents were successfully imported i didnt have any issue in it.
    To make sure, i removed all the imported contents by exporting the same and then again when i imported the same archive im facing these issues.

  • Raja Kummathi
    Raja Kummathi Member Posts: 742 Silver Badge
    edited Aug 18, 2017 3:37AM

    Hi,

    This issue may occurs when you do export with delete after immediate import. Make sure all document should delete with archiver  from the server and then import will success.

    --Raja

  • plishelpme
    plishelpme Member Posts: 14
    edited Aug 18, 2017 5:40AM

    Yeah Raja i did export with delete immediately after an import.
    Right now i have cleared all the datas from the content server and Storage.

    Is there anything to be done in archive.hda or exports.hda ?

  • Raja Kummathi
    Raja Kummathi Member Posts: 742 Silver Badge
    edited Aug 18, 2017 6:19AM

    Hi Gotham,

    Nothing required to do with archiver.hda and export.hda file. Make sure before import all documents should delete from the content server.

    --Raja

  • plishelpme
    plishelpme Member Posts: 14
    edited Aug 21, 2017 1:13AM

    Hi Raja,

    I tried after deleting the datas from the content server. Im getting the same error again.
    Is there any other possibility ?

  • Raja Kummathi
    Raja Kummathi Member Posts: 742 Silver Badge
    edited Aug 21, 2017 2:25AM

    Hi,

    Are you using "Insert Revision/Create Revision" import option?

    Use "update import option and let me know  results.

    pastedImage_1.png

    --Raja

  • plishelpme
    plishelpme Member Posts: 14
    edited Aug 21, 2017 3:17AM

    Archiver_Import.PNG

    Hi Raja i have been using this option when i tried the import all this while.

This discussion has been closed.