Coredumps When Using IntegrityCheck On Large Customers (Doc ID 2302212.1)

Last updated on AUGUST 29, 2017

Applies to:

Siebel CRM - Version 15.18 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.18 [IP2015] version, Order Management

After shifting production system from IP15.13 to IP15.18 customer is observing error message "SBL-DBC-00105 / ORA-0100: maximum open cursors exceeded" often in conjunction with coredumps during order submit when the verification of an order containing promotion group product for a large customer is invoked.

They could narrow down the issue already to BS 'ISS Promotion Management Service' method 'IntegrityCheck'. They compared an execution of that BS method on PS13 against PS18 and it could be noticed that on PS18 SQL statements against S_PROD_INT (based on BC "Internal Product - ISS Admin") are present which are not occurring on PS13. Additionally it seems that on PS18 for each SQL query a new DB cursor is used where on PS13 it's mostly using the same.

ERROR
-----------------------
SBL-DBC-00105 / ORA-0100: maximum open cursors exceeded


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