Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Full text index failed.

Rohit.KumarFeb 24 2016 — edited Feb 25 2016

Hi All ,

I have check-in one .pdf file in content server(Oracle 10gR3) and encounter with below mention error.

Full text index failed. Unexpected failure by Indexer.   

we are getting this error only for this single pdf file. we check-in the same pdf file in Oracle 11g and we didn't encounter with this error.

So I can say that indexer of oracle 11g is able to index this file but Oracle 10gR3 not.

please also find log trace from system audit info with enable of below mention tracing section.

system, indexer, requestaudit, searchcache, searchquery, systemdatabase

requestaudit 02.25 01:40:17.213 IdcServerThread-85 RESUBMIT_FOR_CONVERSION [dID=19297][dDocName=XDEV004819][dUser=xxxx] 1.114(secs)
systemdatabase 02.25 01:40:17.226 IdcServerThread-86 assigning connection
systemdatabase 02.25 01:40:17.226 IdcServerThread-86 SELECT Revisions.*, Documents.*, DocMeta.*
  FROM Revisions, Documents, DocMeta
  WHERE Revisions.dID=19297 AND Revisions.dID=Documents.dID AND DocMeta.dID = Documents.dID
  AND Revisions.dStatus<>'DELETED' AND Documents.dIsPrimary<>0

systemdatabase 02.25 01:40:17.235 IdcServerThread-86 Finished query (0.0090): SELECT Revisions.*, Documents.*, DocMeta.*
  FROM Revisions, Documents, DocMeta
  WHERE Revisions.dID=19297 AND Revisions.dID=Documents.dID AND DocMeta.dID = Documents.dID
  AND Revisions.dStatus<>'DELETED' AND Documents.dIsPrimary<>0
systemdatabase 02.25 01:40:17.242 IdcServerThread-86 SELECT dFormat, dIsPrimary FROM Documents WHERE (dIsWebFormat=0 AND Documents.dID=19297)
systemdatabase 02.25 01:40:17.251 IdcServerThread-86 Finished query (0.0090): SELECT dFormat, dIsPrimary FROM Documents WHERE (dIsWebFormat=0 AND Documents.dID=19297)
systemdatabase 02.25 01:40:17.259 IdcServerThread-86 SELECT * FROM RelatedTypes
  ORDER BY dLinkTypeID
systemdatabase 02.25 01:40:17.267 IdcServerThread-86 Finished query (0.0080): SELECT * FROM RelatedTypes
  ORDER BY dLinkTypeID
systemdatabase 02.25 01:40:17.276 IdcServerThread-86 SELECT DISTINCT dLinkTypeID AS dLinkTypeID, dIsParent AS dIsParent
  FROM RelatedContent
  WHERE dSource = 'CS' AND dID = 19297
systemdatabase 02.25 01:40:17.291 IdcServerThread-86 Finished query (0.015): SELECT DISTINCT dLinkTypeID AS dLinkTypeID, dIsParent AS dIsParent
  FROM RelatedContent
  WHERE dSource = 'CS' AND dID = 19297
systemdatabase 02.25 01:40:17.292 IdcServerThread-86 SELECT DISTINCT dLinkTypeID AS dLinkTypeID, dIsParent AS dIsParent
  FROM RelatedContent
  WHERE dSource = 'CS' AND dDocName = 'XDEV004819'
systemdatabase 02.25 01:40:17.300 IdcServerThread-86 Finished query (0.0070): SELECT DISTINCT dLinkTypeID AS dLinkTypeID, dIsParent AS dIsParent
  FROM RelatedContent
  WHERE dSource = 'CS' AND dDocName = 'XDEV004819'
systemdatabase 02.25 01:40:17.300 IdcServerThread-86 SELECT *
  FROM Subscription
  WHERE dSubscriptionAlias = 'ACCSIT' AND dSubscriptionID = 'XDEV004819'
   AND dSubscriptionType = 'Basic'
systemdatabase 02.25 01:40:17.335 IdcServerThread-86 Finished query (0.035): SELECT *
  FROM Subscription
  WHERE dSubscriptionAlias = 'ACCSIT' AND dSubscriptionID = 'XDEV004819'
   AND dSubscriptionType = 'Basic'
systemdatabase 02.25 01:40:17.335 IdcServerThread-86 SELECT Documents.dFormat, Revisions.dInDate, Revisions.dOutDate, Revisions.dStatus, Revisions.dProcessingState,
  Revisions.dRevLabel, Documents.dID, Revisions.dDocName, Revisions.dRevisionID
  FROM Revisions, Documents
  WHERE Revisions.dID = Documents.dID
  AND ((Revisions.dStatus<>'DELETED') AND (Documents.dIsPrimary<>0) AND
  (Revisions.dRevClassID=4819))
  ORDER BY Revisions.dRevisionID DESC

systemdatabase 02.25 01:40:17.343 IdcServerThread-86 Finished query (0.0080): SELECT Documents.dFormat, Revisions.dInDate, Revisions.dOutDate, Revisions.dStatus, Revisions.dProcessingState,
  Revisions.dRevLabel, Documents.dID, Revisions.dDocName, Revisions.dRevisionID
  FROM Revisions, Documents
  WHERE Revisions.dID = Documents.dID
  AND ((Revisions.dStatus<>'DELETED') AND (Documents.dIsPrimary<>0) AND
  (Revisions.dRevClassID=4819))
  ORDER BY Revisions.dRevisionID DESC
systemdatabase 02.25 01:40:17.351 IdcServerThread-86 release pool connection
systemdatabase 02.25 01:40:17.879 IdcServerThread-86 assigning connection
systemdatabase 02.25 01:40:17.879 IdcServerThread-86 SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=2
systemdatabase 02.25 01:40:17.894 IdcServerThread-86 Finished query (0.015): SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=2
systemdatabase 02.25 01:40:17.899 IdcServerThread-86 SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=3
systemdatabase 02.25 01:40:17.906 IdcServerThread-86 Finished query (0.0070): SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=3
systemdatabase 02.25 01:40:17.911 IdcServerThread-86 SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=1
systemdatabase 02.25 01:40:17.920 IdcServerThread-86 Finished query (0.0090): SELECT * FROM Collections, ColMeta WHERE Collections.dCollectionID=ColMeta.dCollectionID AND Collections.dCollectionID=1
systemdatabase 02.25 01:40:18.041 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntContentGroup
systemdatabase 02.25 01:40:18.060 IdcServerThread-86 Finished query (0.019): SELECT max(schModifyTimestamp) FROM IntContentGroup
systemdatabase 02.25 01:40:18.074 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntOwner
systemdatabase 02.25 01:40:18.088 IdcServerThread-86 Finished query (0.014): SELECT max(schModifyTimestamp) FROM IntOwner
systemdatabase 02.25 01:40:18.150 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntContentType
systemdatabase 02.25 01:40:18.156 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntContentType
systemdatabase 02.25 01:40:18.252 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib1
systemdatabase 02.25 01:40:18.257 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntResourceLib1
systemdatabase 02.25 01:40:18.268 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib2
systemdatabase 02.25 01:40:18.273 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntResourceLib2
systemdatabase 02.25 01:40:18.284 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib3
systemdatabase 02.25 01:40:18.289 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntResourceLib3
systemdatabase 02.25 01:40:18.301 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib4
systemdatabase 02.25 01:40:18.306 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntResourceLib4
systemdatabase 02.25 01:40:18.316 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib5
systemdatabase 02.25 01:40:18.322 IdcServerThread-86 Finished query (0.0060): SELECT max(schModifyTimestamp) FROM IntResourceLib5
systemdatabase 02.25 01:40:18.337 IdcServerThread-86 SELECT max(schModifyTimestamp) FROM IntResourceLib6
systemdatabase 02.25 01:40:18.342 IdcServerThread-86 Finished query (0.0050): SELECT max(schModifyTimestamp) FROM IntResourceLib6
systemdatabase 02.25 01:40:18.358 IdcServerThread-86 SELECT DISTINCT child.ProfileTrigger, child.ProfileTriggerName, child.schCreateTimestamp, child.schModifyTimestamp, child.schSourceID, child.dSecurityGroup, child.dDocAccount FROM ProfileTrigger child WHERE child.ProfileTrigger=null ORDER BY child.ProfileTriggerName ASC
systemdatabase 02.25 01:40:18.368 IdcServerThread-86 Finished query (0.01): SELECT DISTINCT child.ProfileTrigger, child.ProfileTriggerName, child.schCreateTimestamp, child.schModifyTimestamp, child.schSourceID, child.dSecurityGroup, child.dDocAccount FROM ProfileTrigger child WHERE child.ProfileTrigger=null ORDER BY child.ProfileTriggerName ASC
systemdatabase 02.25 01:40:18.490 IdcServerThread-86 SELECT     WorkflowHistory.dWfStepName, WorkflowHistory.dAction, WorkflowHistory.dID, WorkflowHistory.dDocName,
                      WorkflowHistory.dActionDate, WorkflowHistory.dUser, WFHistoryComments.dComments,
                      WFHistoryComments.correctStepName, cast ( WorkflowHistory.dActionDate as varchar(16) ) concat ',' concat substr( ('00' concat cast ( char(WorkflowHistory.dActionMillis) as varchar(20))) , length( rtrim('00' concat cast ( char(WorkflowHistory.dActionMillis) as varchar(5))) ) -4,5   ) as expr1
FROM         WorkflowHistory LEFT OUTER JOIN
                      WFHistoryComments ON WorkflowHistory.dActionDate = WFHistoryComments.dActionDate AND
                      WorkflowHistory.dActionMillis = WFHistoryComments.dActionMillis
WHERE     (WorkflowHistory.dID = 19297)
ORDER BY expr1 DESC
systemdatabase 02.25 01:40:18.521 IdcServerThread-86 Finished query (0.031): SELECT     WorkflowHistory.dWfStepName, WorkflowHistory.dAction, WorkflowHistory.dID, WorkflowHistory.dDocName,
                      WorkflowHistory.dActionDate, WorkflowHistory.dUser, WFHistoryComments.dComments,
                      WFHistoryComments.correctStepName, cast ( WorkflowHistory.dActionDate as varchar(16) ) concat ',' concat substr( ('00' concat cast ( char(WorkflowHistory.dActionMillis) as varchar(20))) , length( rtrim('00' concat cast ( char(WorkflowHistory.dActionMillis) as varchar(5))) ) -4,5   ) as expr1
FROM         WorkflowHistory LEFT OUTER JOIN
                      WFHistoryComments ON WorkflowHistory.dActionDate = WFHistoryComments.dActionDate AND
                      WorkflowHistory.dActionMillis = WFHistoryComments.dActionMillis
WHERE     (WorkflowHistory.dID = 19297)
ORDER BY expr1 DESC
systemdatabase 02.25 01:40:18.524 IdcServerThread-86 SELECT     QbeTaskHistory.Approver, QbeTaskHistory.PublishDate, QBETask.TaskName
FROM         QbeTaskHistory INNER JOIN
                      QBETask ON QbeTaskHistory.TaskId = QBETask.TaskId AND QbeTaskHistory.DocID = cast ( '19297' as bigint )
systemdatabase 02.25 01:40:18.543 IdcServerThread-86 Finished query (0.019): SELECT     QbeTaskHistory.Approver, QbeTaskHistory.PublishDate, QBETask.TaskName
FROM         QbeTaskHistory INNER JOIN
                      QBETask ON QbeTaskHistory.TaskId = QBETask.TaskId AND QbeTaskHistory.DocID = cast ( '19297' as bigint )
systemdatabase 02.25 01:40:18.554 IdcServerThread-86 release pool connection
requestaudit 02.25 01:40:18.555 IdcServerThread-86 DOC_INFO [dID=19297][dDocName=XDEV004819][dDocTitle=Testing indexer][dUser=ACCSIT][dSecurityGroup=AAP][xCollectionID=0] 1.332(secs)
systemdatabase 02.25 01:40:33.122 SubjectManager begin tran
systemdatabase 02.25 01:40:33.122 SubjectManager assigning connection
systemdatabase 02.25 01:40:33.126 SubjectManager SELECT Revisions.*, Documents.*, DocMeta.*
  FROM Revisions, Documents, DocMeta
  WHERE Revisions.dID=19297 AND Revisions.dID=Documents.dID AND DocMeta.dID = Documents.dID
  AND Revisions.dStatus<>'DELETED' AND Documents.dIsWebFormat<>0

systemdatabase 02.25 01:40:33.143 SubjectManager Finished query (0.017): SELECT Revisions.*, Documents.*, DocMeta.*
  FROM Revisions, Documents, DocMeta
  WHERE Revisions.dID=19297 AND Revisions.dID=Documents.dID AND DocMeta.dID = Documents.dID
  AND Revisions.dStatus<>'DELETED' AND Documents.dIsWebFormat<>0
systemdatabase 02.25 01:40:33.143 SubjectManager SELECT Max(Revisions.dID) AS dID
  FROM Revisions
  WHERE (Revisions.dRevClassID=4819 AND Revisions.dStatus<>'DELETED')

systemdatabase 02.25 01:40:33.151 SubjectManager Finished query (0.0080): SELECT Max(Revisions.dID) AS dID
  FROM Revisions
  WHERE (Revisions.dRevClassID=4819 AND Revisions.dStatus<>'DELETED')
systemdatabase 02.25 01:40:33.154 SubjectManager UPDATE Revisions SET dStatus = 'DONE', dProcessingState = 'I', dReleaseState = 'U', dWorkflowState = '',  dMessage= 'One or more steps reported errors. ''Warning, line 1: Invalid option
EXOpenExport() failed: file is password protected or encrypted (0x000B)''. Conversion had 2 errors. See log for details.',
  dWebExtension = 'pdf', dRendition1 = '', dRendition2 = ''
  WHERE dID = 19297

systemdatabase 02.25 01:40:33.162 SubjectManager Finished query (0.0070): UPDATE Revisions SET dStatus = 'DONE', dProcessingState = 'I', dReleaseState = 'U', dWorkflowState = '',  dMessage= 'One or more steps reported errors. ''Warning, line 1: Invalid option
EXOpenExport() failed: file is password protected or encrypted (0x000B)''. Conversion had 2 errors. See log for details.',
  dWebExtension = 'pdf', dRendition1 = '', dRendition2 = ''
  WHERE dID = 19297
systemdatabase 02.25 01:40:33.162 SubjectManager UPDATE Documents SET dOriginalName = 'xdev004819~1.pdf', dFormat = 'application/pdf', dExtension = 'pdf', dFileSize = 138276
  WHERE dDocID = 65014
systemdatabase 02.25 01:40:33.170 SubjectManager Finished query (0.0080): UPDATE Documents SET dOriginalName = 'xdev004819~1.pdf', dFormat = 'application/pdf', dExtension = 'pdf', dFileSize = 138276
  WHERE dDocID = 65014
systemdatabase 02.25 01:40:33.181 SubjectManager commit tran
systemdatabase 02.25 01:40:33.225 SubjectManager release pool connection
indexer 02.25 01:40:33.288 index update work normalizeVdkVersion() found '4.' for '4.'
indexer 02.25 01:40:33.288 index update work normalizeVdkVersion() returning '4.' with path 'vdk4' for '4.'
indexer 02.25 01:40:33.290 index update work findOSPathComponent() returning '_rs6k43' for vdk '4.'.
systemdatabase 02.25 01:40:33.442 index update work assigning connection
systemdatabase 02.25 01:40:33.442 index update work SELECT dID, dRevClassID, dReleaseState, dDocName, dSecurityGroup FROM Revisions
  WHERE (Revisions.dStatus='RELEASED' OR Revisions.dStatus='DONE') AND
  Revisions.dOutDate < {ts '2016-02-25 01:41:33.442'}

systemdatabase 02.25 01:40:33.456 index update work Finished query (0.014): SELECT dID, dRevClassID, dReleaseState, dDocName, dSecurityGroup FROM Revisions
  WHERE (Revisions.dStatus='RELEASED' OR Revisions.dStatus='DONE') AND
  Revisions.dOutDate < {ts '2016-02-25 01:41:33.442'}
systemdatabase 02.25 01:40:33.456 index update work SELECT dID
  FROM Revisions
  WHERE Revisions.dReleaseState = 'N' AND Revisions.dStatus in ('DONE', 'RELEASED', 'DELETED')
  AND Revisions.dInDate<={ts '2016-02-25 01:41:33.442'}

systemdatabase 02.25 01:40:33.470 index update work Finished query (0.014): SELECT dID
  FROM Revisions
  WHERE Revisions.dReleaseState = 'N' AND Revisions.dStatus in ('DONE', 'RELEASED', 'DELETED')
  AND Revisions.dInDate<={ts '2016-02-25 01:41:33.442'}
systemdatabase 02.25 01:40:33.519 index update work begin tran
systemdatabase 02.25 01:40:33.525 index update work SELECT dRevClassID
  FROM Revisions
  WHERE ((dReleaseState in ('R', 'U', 'I', 'D') OR dStatus = 'DELETED')
  AND (dIndexerState is null OR dIndexerState in (' ', 'Y'))
  AND (dStatus <> 'GENWWW'))

systemdatabase 02.25 01:40:33.531 index update work Finished query (0.0060): SELECT dRevClassID
  FROM Revisions
  WHERE ((dReleaseState in ('R', 'U', 'I', 'D') OR dStatus = 'DELETED')
  AND (dIndexerState is null OR dIndexerState in (' ', 'Y'))
  AND (dStatus <> 'GENWWW'))
systemdatabase 02.25 01:40:33.543 index update work commit tran
systemdatabase 02.25 01:40:33.543 index update work SELECT dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup
  FROM Revisions
  WHERE dRevClassID = 4819
  ORDER BY dID DESC

systemdatabase 02.25 01:40:33.550 index update work Finished query (0.0070): SELECT dID, dIndexerState, dReleaseState, dStatus, dRevClassID, dDocName, dSecurityGroup
  FROM Revisions
  WHERE dRevClassID = 4819
  ORDER BY dID DESC
systemdatabase 02.25 01:40:33.550 index update work begin tran
systemdatabase 02.25 01:40:33.557 index update work UPDATE Revisions SET dIndexerState = 'A'
  WHERE dRevClassID = 4819
  AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)
  AND (dID <= 19297 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))
systemdatabase 02.25 01:40:33.566 index update work Finished query (0.0080): UPDATE Revisions SET dIndexerState = 'A'
  WHERE dRevClassID = 4819
  AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)
  AND (dID <= 19297 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))
systemdatabase 02.25 01:40:33.575 index update work commit tran
indexer 02.25 01:40:33.598 index update work Saving 1 update changes
indexer 02.25 01:40:33.696 index update work IndexerBulkLoader doing 'IndexAdditions' with m_change '+'
systemdatabase 02.25 01:40:33.733 index update work release pool connection
systemdatabase 02.25 01:40:33.739 index update work assigning connection
systemdatabase 02.25 01:40:33.739 index update work SELECT Revisions.*, Documents.*, DocMeta.*, DocTypes.dGif
     FROM Revisions,Documents,DocMeta,DocTypes
     WHERE Revisions.dID = 19297
       AND Revisions.dID = Documents.dID
       AND Revisions.dID = DocMeta.dID
       AND DocTypes.dDocType = Revisions.dDocType
       AND Revisions.dIndexerState in ('A', 'Y')

systemdatabase 02.25 01:40:33.760 index update work Finished query (0.021): SELECT Revisions.*, Documents.*, DocMeta.*, DocTypes.dGif
     FROM Revisions,Documents,DocMeta,DocTypes
     WHERE Revisions.dID = 19297
       AND Revisions.dID = Documents.dID
       AND Revisions.dID = DocMeta.dID
       AND DocTypes.dDocType = Revisions.dDocType
       AND Revisions.dIndexerState in ('A', 'Y')
systemdatabase 02.25 01:40:33.773 index update work SELECT dID, dDocName, dDocType, dRevLabel, dSecurityGroup, dWebExtension, dDocAccount
  FROM Revisions
  WHERE dRevClassID = 4819
  AND dStatus in ('RELEASED', 'EXPIRED')
  AND dReleaseState in ('Y', 'U', 'I', 'D')
  ORDER BY dID DESC

systemdatabase 02.25 01:40:33.789 index update work Finished query (0.015): SELECT dID, dDocName, dDocType, dRevLabel, dSecurityGroup, dWebExtension, dDocAccount
  FROM Revisions
  WHERE dRevClassID = 4819
  AND dStatus in ('RELEASED', 'EXPIRED')
  AND dReleaseState in ('Y', 'U', 'I', 'D')
  ORDER BY dID DESC
indexer 02.25 01:40:33.791 index update work Removing tilde on file /optnonaix/stellent_local/stxdev/weblayout/groups/aap/documents/adacct/xdev004819~1.pdf
system 02.25 01:40:33.795 index update work Renamed from /optnonaix/stellent_local/stxdev/weblayout/groups/aap/documents/adacct/xdev004819~1.pdf to /optnonaix/stellent_local/stxdev/weblayout/groups/aap/documents/adacct/xdev004819.pdf
indexer 02.25 01:40:33.797 index update work webFormat is application/pdf
indexer 02.25 01:40:33.797 index update work loadRecordWebChange(): indexWebFile: true ii.m_indexWebFile: true m_retryIndexing: false m_isFirstRetry: true
systemdatabase 02.25 01:40:33.797 index update work release pool connection
indexer 02.25 01:40:33.823 index update work Adding content items to index from /optnonaix/stellent_local/stxdev/search/index2/bulkload/14033.txt.
indexer 02.25 01:40:33.836 index update work /usr/bin/env LIBPATH=/optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/:/optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/filters /optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/mkvdk -vdkhome /optnonaix/stellent_local/stxdev/shared/search/vdk4/common -update -autodel -datefmt YMD -locale englishx -collection /optnonaix/stellent_local/stxdev/search/index2/intradocbasic/ -bulk /optnonaix/stellent_local/stxdev/search/index2/bulkload/14033.txt
indexer 02.25 01:40:33.872 index update work indexer has 629.995 seconds to generate more output
indexer 02.25 01:40:33.872 index update work stdOutFinished: false stdErrFinished: false
indexer 02.25 01:40:34.901 stdout read 58 bytes
indexer 02.25 01:40:34.902 stdout mkvdk - Verity, Inc. Version 4.5.1 (_rs6k43, Jan 28 2004)
indexer 02.25 01:40:35.572 stdout read 164 bytes
indexer 02.25 01:40:35.572 stdout BulkInserting into /optnonaix/stellent_local/stxdev/search/index2/intradocbasic (276) from /optnonaix/stellent_local/stxdev/search/index2/bulkload/14033.txt (0, 0)
indexer 02.25 01:40:35.584 stdout read 54 bytes
indexer 02.25 01:40:35.584 stdout Initializing dataset 00000276.ddd, index 00000276.did
indexer 02.25 01:40:44.128 stderr read 29 bytes
indexer 02.25 01:40:44.129 stderr Error opening /tmp/PDFkJfMab

indexer 02.25 01:40:44.156 stderr read 42 bytes
indexer 02.25 01:40:44.156 stderr Acrobat exception: Could not repair file.

indexer 02.25 01:40:44.791 stderr read 99 bytes
indexer 02.25 01:40:44.791 stderr Warn    E2-0527 (Document Index): Document 1 (z78646576303034383139): Stream error (-2) - SKIPPING

indexer 02.25 01:40:44.791 stdout read 60 bytes
indexer 02.25 01:40:44.791 stdout Totals (0 documents): 0 para  0 sent  0 word  (176 Kb used)
indexer 02.25 01:40:45.226 stdout read 106 bytes
indexer 02.25 01:40:45.226 stdout (9983 ms) Indexed 0 docs into /optnonaix/stellent_local/stxdev/search/index2/intradocbasic/parts/00000276
indexer 02.25 01:40:45.308 stderr read 33 bytes
indexer 02.25 01:40:45.308 stderr BadKeys:
  z78646576303034383139

indexer 02.25 01:40:54.584 stdout read 11 bytes
indexer 02.25 01:40:54.584 stdout mkvdk done
indexer 02.25 01:40:54.690 index update work indexer has 609.176 seconds to generate more output
indexer 02.25 01:40:54.690 index update work stdOutFinished: false stdErrFinished: false
indexer 02.25 01:40:54.690 index update work indexer has 609.176 seconds to generate more output
indexer 02.25 01:40:54.690 index update work stdOutFinished: true stdErrFinished: false
indexer 02.25 01:40:54.691 index update work indexer has 609.175 seconds to generate more output
indexer 02.25 01:40:54.691 index update work stdOutFinished: true stdErrFinished: true
indexer 02.25 01:40:54.696 index update work Indexer failed to index all documents.
indexer 02.25 01:40:54.730 index update work setting change on '19297' to '!'
systemdatabase 02.25 01:40:54.730 index update work assigning connection
systemdatabase 02.25 01:40:54.863 index update work UPDATE Revisions SET dProcessingState='M', dMessage='!csIndexerFailure'
  WHERE dID=19297 AND dStatus<>'DELETED'
systemdatabase 02.25 01:40:55.087 index update work Finished query (0.224): UPDATE Revisions SET dProcessingState='M', dMessage='!csIndexerFailure'
  WHERE dID=19297 AND dStatus<>'DELETED'
indexer 02.25 01:40:55.087 index update work after handling indexing results: hasError: true m_retryIndexing: false m_isFirstRetry: true metaOnlyCount: 0 aSize: 1
systemdatabase 02.25 01:40:55.107 index update work release pool connection
indexer 02.25 01:40:55.185 index update work IndexerBulkLoader doing 'IndexRetries' with m_change '*'
indexer 02.25 01:40:55.252 index update work IndexerBulkLoader doing 'IndexRetries' with m_change '!'
systemdatabase 02.25 01:40:55.291 index update work assigning connection
systemdatabase 02.25 01:40:55.291 index update work SELECT Revisions.*, Documents.*, DocMeta.*, DocTypes.dGif
     FROM Revisions,Documents,DocMeta,DocTypes
     WHERE Revisions.dID = 19297
       AND Revisions.dID = Documents.dID
       AND Revisions.dID = DocMeta.dID
       AND DocTypes.dDocType = Revisions.dDocType
       AND Revisions.dIndexerState in ('A', 'Y')

systemdatabase 02.25 01:40:55.295 index update work Finished query (0.0040): SELECT Revisions.*, Documents.*, DocMeta.*, DocTypes.dGif
     FROM Revisions,Documents,DocMeta,DocTypes
     WHERE Revisions.dID = 19297
       AND Revisions.dID = Documents.dID
       AND Revisions.dID = DocMeta.dID
       AND DocTypes.dDocType = Revisions.dDocType
       AND Revisions.dIndexerState in ('A', 'Y')
systemdatabase 02.25 01:40:55.299 index update work SELECT dID, dDocName, dDocType, dRevLabel, dSecurityGroup, dWebExtension, dDocAccount
  FROM Revisions
  WHERE dRevClassID = 4819
  AND dStatus in ('RELEASED', 'EXPIRED')
  AND dReleaseState in ('Y', 'U', 'I', 'D')
  ORDER BY dID DESC

systemdatabase 02.25 01:40:55.309 index update work Finished query (0.01): SELECT dID, dDocName, dDocType, dRevLabel, dSecurityGroup, dWebExtension, dDocAccount
  FROM Revisions
  WHERE dRevClassID = 4819
  AND dStatus in ('RELEASED', 'EXPIRED')
  AND dReleaseState in ('Y', 'U', 'I', 'D')
  ORDER BY dID DESC
indexer 02.25 01:40:55.309 index update work File /optnonaix/stellent_local/stxdev/weblayout/groups/aap/documents/adacct/xdev004819~1.pdf not present, going with version without tilde
indexer 02.25 01:40:55.310 index update work loadRecordWebChange(): indexWebFile: false ii.m_indexWebFile: false m_retryIndexing: true m_isFirstRetry: false
systemdatabase 02.25 01:40:55.310 index update work release pool connection
indexer 02.25 01:40:55.315 index update work Adding content items to index from /optnonaix/stellent_local/stxdev/search/index2/bulkload/14055.txt.
indexer 02.25 01:40:55.319 index update work /usr/bin/env LIBPATH=/optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/:/optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/filters /optnonaix/stellent_local/stxdev/shared/search/vdk4/_rs6k43/bin/mkvdk -vdkhome /optnonaix/stellent_local/stxdev/shared/search/vdk4/common -update -autodel -datefmt YMD -locale englishx -collection /optnonaix/stellent_local/stxdev/search/index2/intradocbasic/ -bulk /optnonaix/stellent_local/stxdev/search/index2/bulkload/14055.txt
indexer 02.25 01:40:55.411 index update work indexer has 630.0 seconds to generate more output
indexer 02.25 01:40:55.411 index update work stdOutFinished: false stdErrFinished: false
indexer 02.25 01:40:55.413 stdout read 58 bytes
indexer 02.25 01:40:55.413 stdout mkvdk - Verity, Inc. Version 4.5.1 (_rs6k43, Jan 28 2004)
indexer 02.25 01:40:56.668 stdout read 164 bytes
indexer 02.25 01:40:56.668 stdout BulkInserting into /optnonaix/stellent_local/stxdev/search/index2/intradocbasic (276) from /optnonaix/stellent_local/stxdev/search/index2/bulkload/14055.txt (0, 0)
indexer 02.25 01:40:56.678 stdout read 54 bytes
indexer 02.25 01:40:56.678 stdout Initializing dataset 00000276.ddd, index 00000276.did
indexer 02.25 01:40:56.763 stdout read 61 bytes
indexer 02.25 01:40:56.763 stdout Totals (1 documents): 1 para  1 sent  8 word  (1392 Kb used)
indexer 02.25 01:40:57.166 stdout read 27 bytes
indexer 02.25 01:40:57.166 stdout Optimizing database layout
searchcache 02.25 01:40:57.369 SubjectManager Cache invalidated by change in released documents state,  creating new search cache
searchcache 02.25 01:40:57.369 SearchCache Approximately 0 of the available cache space is used.
indexer 02.25 01:40:57.728 stdout read 106 bytes
indexer 02.25 01:40:57.728 stdout (1453 ms) Indexed 1 docs into /optnonaix/stellent_local/stxdev/search/index2/intradocbasic/parts/00000276
indexer 02.25 01:40:58.445 stdout read 29 bytes
indexer 02.25 01:40:58.445 stdout Writing partition index data
indexer 02.25 01:40:58.634 stdout read 11 bytes
indexer 02.25 01:40:58.634 stdout mkvdk done
indexer 02.25 01:40:58.738 index update work saw interesting text 'Optimizing database layout', increasing timeAllowed by 600.0 seconds.
indexer 02.25 01:40:58.739 index update work indexer has 1226.671 seconds to generate more output
indexer 02.25 01:40:58.739 index update work stdOutFinished: false stdErrFinished: false
indexer 02.25 01:40:58.739 index update work indexer has 1226.671 seconds to generate more output
indexer 02.25 01:40:58.739 index update work stdOutFinished: true stdErrFinished: false
indexer 02.25 01:40:58.739 index update work indexer has 1226.671 seconds to generate more output
indexer 02.25 01:40:58.739 index update work stdOutFinished: true stdErrFinished: true
indexer 02.25 01:40:58.751 index update work setting change on '19297' to 'I'
indexer 02.25 01:40:58.751 index update work after handling indexing results: hasError: false m_retryIndexing: true m_isFirstRetry: false metaOnlyCount: 0 aSize: 1
systemdatabase 02.25 01:40:58.856 index update work assigning connection
systemdatabase 02.25 01:40:58.856 index update work SELECT count(*) from Subscription
systemdatabase 02.25 01:40:58.860 index update work Finished query (0.0040): SELECT count(*) from Subscription
systemdatabase 02.25 01:40:59.097 index update work SELECT dID FROM Revisions
  WHERE dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.106 index update work Finished query (0.0090): SELECT dID FROM Revisions
  WHERE dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.106 index update work SELECT dID FROM Revisions
  WHERE dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.111 index update work Finished query (0.0050): SELECT dID FROM Revisions
  WHERE dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.111 index update work DELETE FROM Revisions WHERE Revisions.dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.123 index update work Finished query (0.012): DELETE FROM Revisions WHERE Revisions.dStatus='DELETED' AND dIndexerState = 'A'
systemdatabase 02.25 01:40:59.123 index update work UPDATE Revisions
  SET dStatus = 'REVIEW', dReleaseState = 'E'
  WHERE dReleaseState = 'D' AND dIndexerState = 'A'
  AND dWorkflowState in ('W', 'R')
systemdatabase 02.25 01:40:59.130 index update work Finished query (0.0070): UPDATE Revisions
  SET dStatus = 'REVIEW', dReleaseState = 'E'
  WHERE dReleaseState = 'D' AND dIndexerState = 'A'
  AND dWorkflowState in ('W', 'R')
systemdatabase 02.25 01:40:59.130 index update work UPDATE Revisions
  SET dStatus = 'EDIT', dReleaseState = 'E'
  WHERE dReleaseState = 'D' AND dIndexerState = 'A'
  AND dWorkflowState in ('E')
systemdatabase 02.25 01:40:59.135 index update work Finished query (0.0050): UPDATE Revisions
  SET dStatus = 'EDIT', dReleaseState = 'E'
  WHERE dReleaseState = 'D' AND dIndexerState = 'A'
  AND dWorkflowState in ('E')
indexer 02.25 01:40:59.139 index update work cleanup for dID 19297 change is I origChange is +
systemdatabase 02.25 01:40:59.139 index update work UPDATE Revisions
  SET dStatus = 'RELEASED', dReleaseState = 'Y',
  dIndexerState = ' ', dReleaseDate={ts '2016-02-25 01:40:59.061'}
  WHERE dID=19297 AND dIndexerState = 'A'

please let me know to resolve this issue.

Regards

Rohit Kumar

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2016
Added on Feb 24 2016
4 comments
1,103 views