My Oracle Support Banner

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 [20436] and later
Siebel Call Center - Version SIA[21219] 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.

Expected Behavior
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 (null) invoking method "(null)" for Business Service "(null)"
  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

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