My Oracle Support Banner

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

Last updated on OCTOBER 21, 2022

Applies to:

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

Symptoms

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, other OS platforms have different limits.

STEPS

1. From View1, the user triggers a server process (BS/Workflow) which executes a view navigation to View2.
2. The object manager then receives a "delayed" request that was originally (validly) invoked from View1 e.g. method WriteRecord.
3. Request for View1 is executed in the new context of View2.
4. 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.