iStore Search Insert Program Takes Long Time and Fails ORA-01555: snapshot too old

(Doc ID 2283272.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Quoting - Version 12.1.3 and later
Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Prod:  12.1.3 version, HTML User Interface

Followed solution of running "iStore Search Insert" program as per below MOS Doc:
>> Adding Product to a Quote Error: "You have encountered an unexpected error. Please contact the system administrator for assistance." Java Stack Error: "ORA-20000: Oracle Text error. DRG-10599: column is not indexed" (Doc ID 1383709.1)

However, DBA had to kill the program after 16.5 hours since it was consuming lot of resources in Prod.

Since program was incomplete, and index was not available yet, users were unable to search any items and add it to Quote.
 

ERROR (concurrent program log)
-----------------------
Cause: FDPSTP failed due to ORA-01555: snapshot too old: rollback segment number 1607 with name "_SYSSMU1607_2800607589$" too small
ORA-06512: at "APPS.IBE_SEARCH_SETUP_PVT", line 478
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "iStore Search Insert" concurrent program
2. See..program fails

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Quoting business users are unable to search/add items to Quotes.

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