My Oracle Support Banner

SR Attachment Indexing (Doc ID 519204.1)

Last updated on JANUARY 25, 2020

Applies to:

Siebel System Software - Version 7.5.3.2 [16168] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.5.3.2 [16168]

Database: Oracle 8.1.7.4

Application Server OS: Microsoft Windows 2000 Server SP 4

Database Server OS: HP 9000 Series HP-UX



This document was previously published as Siebel SR 38-1629823051.

Symptoms

Hello,

We are unable to generate Hummingbird indexes for Service Request attachments in our production environment.

Twice we have tried generating the SR Attachment Indexes and this is what happens:
1. We login to the application server that is running the Hummingbird Advanced Search engine.
2. We navigate to the Search Indices Screen and start the SR Attachment Indexing process.
3. Monitoring the \temp\search folder we can see the files being moved from the Siebel file system into the folder.
4. When the files are finished being moved they are deleted.
5. None of the following files are created in the siebsrvr\SEARCH\ServerDataSrc\scripts folder: *.dil, FUL_SRVREQ_ATT.FTE, FUL_SRVREQ_ATT.DID
6. There are no files created in the siebsrvr\SEARCH\ServerDataSrc\index folder (ful_srvreq_att.*).
7. There are no logfiles in the siebsrvr\log directory that show anything started\finished\aborted with respect to the indexing process.
8. The only thing we do see is files (TMP*.tmp) in the siebsrvr\SEARCH\ServerDataSrc\temp folder being updated.
9. We do not see any indexing process running in the Task Manager (I have attached a list of all running processes).

We have successfully generated the Solution Attachment indexes in the same environment and they are working fine. We do not want to start the Activity Attachment indexes until we solve the problem with the SR Attachment Index.

There are currently about 135,000 SR Attachments (600,000 Activity Attachments) that need to be indexed and we have successfully generated the SR Attachment Index in our Test environment using the same production data with the same SRF.

We need to understand the indexing process more clearly and how to monitor what is happening AFTER the files have been copied to the temp\search folder so that we can troubleshoot why this is failing.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Message 1
 Message 2
 Message 3

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.