Records Not Deleted From S_SRCH_CHG_TXN Table (Doc ID 2202380.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel eAutomotive - Version 8.1.1.14.15 [IP2014] and later
Information in this document applies to any platform.

Symptoms

Customer is noticing an issue where records in s_srch_chg_txn table are not getting deleted. This is resulting in the table containing more than 10,000 records.

Due to this, only the first 10,000 are ever copied into s_srch_ctgry and processed by OSES.

Questions:
What is the recommended process to clear records out of s_srch_chg_txn table?
Are they supposed to be cleared out automatically? Is this a bug? Or, is there a documented process to delete processed records?

Repro Steps:

1. Install Siebel 8.1.1.14 or IP 2015 or IP 2016.
2. Install OSES version 11.2.2.2
3. Setup Incremental indexer for HTTP or FTP modes.
4. Create (say) 4 Account records and perform full indexing.
5. Check S_SRCH_CHG_TXN Table. There would be 4 records for Account BC.
6. Then add 3 more Account records and perform Incremental index / crawling.
7. Now you will see 6 Account records. Only the last of 3 Account records are deleted from S_SRCH_CHG_TXN, but not all the 3 Account records.
8. This is causing thousands / millions of records getting accumulated in S_SRCH_CHG_TXN Table and thereby creating performance issues.

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