My Oracle Support Banner

Index Search Operation fails with SBL-OMS-00203, Not All Records are Indexed (Doc ID 1329272.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0.0.10 [20436] and later
Siebel Call Center - Version 8.1.1.3 SIA[21219] and later
Information in this document applies to any platform.
***Checked for relevance on 14-Oct-2013***

Symptoms

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.

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.