Query over 'Order Entry - Line Items' Generated By Business Service 'VORD Projected Asset Cache' Invoke Method 'Initialize' Taking Longer Than Required And Causing Database Timeout
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 22.214.171.124.1 [IP2013] and later
Information in this document applies to any platform.
The web service BeginConfiguration is called but returns the error:
Error running sub-process 'ConfiguratorWebChannelBeginConfig' at step 'Begin Configuration Subprocess'.(SBL-BPR-00183).
The error occurs when invoking service 'VORD Projected Asset Cache', method 'Initialize' at step 'Initialize Projected Asset'.
(SBL-BPR-00162). An error has occurred executing a Sql statement (SBL-DBC-00105), as of ORA-00040: active time limit exceeded - call aborted.
In the example reported the time to run the SQL was 66.858 seconds.
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