Index Search Operation fails with SBL-OMS-00203 - Not All Records are Indexed
(Doc ID 1329272.1)
Last updated on NOVEMBER 22, 2019
Applies to:Siebel CRM - Version 126.96.36.199  and later
Siebel Call Center - Version 188.8.131.52 SIA and later
Information in this document applies to any platform.
When attempting to index "Service Request" search category, only a partial number of records are indexed (49,500); whereas there are around 1,605,487 records.
All records of the search category should have been indexed.
Steps to Reproduce
The issue can be reproduced intermittently with the following steps and any search category:
1. Navigate to to Administration - Search > Search Index Settings, select "Service Request" search category and click"Index" button.
2. After a while, the column "Status Details" of this search category only shows "49500 rows"; it should have indexed more than 1 million records.
3. The SearchDataProcessor job can exit with messages:
SBL-OMS-00203: Error invoking method "CreateFullIndex" for Business Service "Search Data Processor"
4. Siebel Search functionality on this search category does not work or it works only on records that were indexed successfully.
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