Index Search Operation fails with SBL-OMS-00203, Not All Records are Indexed
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 18.104.22.168  and later
Siebel Call Center - Version 22.214.171.124 SIA and later
Information in this document applies to any platform.
***Checked for relevance on 14-Oct-2013***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms