Unexpected Query Being Executed When Business Object Context Is Lost (Doc ID 2277215.1)

Last updated on JUNE 15, 2017

Applies to:

Siebel Communications CRM - Version 16.6 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.6 [IP2016] version, System Admin

ACTUAL BEHAVIOR
---------------

The object manager is crashing when it is already using lots of memory and is close to its limit (platform dependent).On Linux platform the crashes usually starts to happen when the process size is above 3.5 GB.

EXPECTED BEHAVIOR
-----------------------
The unexpected large number of database fetches should not be fired out of context.

STEPS
-----------------------
From View1, the user triggers a server process (BS/Workflow) which executes a view navigation to View2.
The object manager then receives a "delayed" request that was originally (validly) invoked from View1 e.g. method WriteRecord.
Request for View1 is executed in the new context of View2.
The object manager issues an unbounded query on the driving BC and a large number of database fetches are observed.

Line   32751: EventContext           EvtCtxView          3 0000004858fd0d64:0 2017-04-23 09:43:20 FINS Company Session View
Line   36896: EventContext           EvtCtxApplet        4 0000004858fd0d64:0 2017-04-23 09:43:25 SIS Account Entry Applet (Custom1)
Line   37533: EventContext           EvtCtxView          3 0000004858fd0d64:0 2017-04-23 09:43:26 Activity Detail View
Line   44529: EventContext           EvtCtxApplet        4 0000004858fd0d64:0 2017-04-23 09:43:30 Activity Form Applet (Custom1)
Line   46405: EventContext           EvtCtxView          3 0000004858fd0d64:0 2017-04-23 09:43:32 Account List View
Line   49949: EventContext           EvtCtxView          3 0000004858fd0d64:0 2017-04-23 09:43:32 Activity Detail View
Line   50973: EventContext           EvtCtxApplet       4 0000004858fd0d64:0 2017-04-23 09:43:35 Activity Form Applet (WriteRecord)
Line 270979: ObjMgrSqlCursorLog Trace                    5 0000004858fd0d64:0 2017-04-23 09:44:12 SQL Cursor with ID 10DFCC70 Buscomp: Action, Forward Only: 0, Fetch Rows: 55000, Fetch All Time: 31.052 seconds.

 The error SBL-UIF-00335 can be either displayed on the screen or written to the OM log file.

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