Unexpected Query Being Executed When Business Object Context Is Lost
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.
On : 16.6 [IP2016] version, System Admin
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.
The unexpected large number of database fetches should not be fired out of context.
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 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.
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