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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms