IP2017 Siebel Tools opening Edit Server Scripts And Saving The Changes To Server Script Is Taking 6 minutes (Doc ID 2378058.1)

Last updated on MARCH 23, 2018

Applies to:

Symptoms

PROBLEM DESCRIPTION
--------------------------------------
Server script changes and saving the changes to server script is taking around 6.5 minutes. Please provide the solution to this issue.

Steps to re-produce:
1) Login to Siebel Tools , create a work space and open it.
2) Navigate to BC -->Action -->Edit server scripts -->make some change to script and save it.

ERROR MESSAGES/EXPECTED BEHAVIOR
-----------------------------------------------------------
Attached the logs and we see below steps in log file is taking more time.

ObjMgrBusServiceLog InvokeMethod 4 000000025aa14eb0:0 2018-03-08 13:32:15 Business Service 'Siebel Tools Script Editor' invoke method 'Start' Execute Time: 385.138 seconds.

Line 787337: ObjMgrSqlCursorLog Trace 5 000000025aa14eb0:0 2018-03-08 13:32:05 SQL Cursor with ID 31F87B70 Buscomp: Repository Field, Forward Only: 0, Fetch Rows: 947, Fetch All Time: 140.742 seconds.

ObjMgrSqlCursorLog Trace 5 000000025aa14eb0:0 2018-03-08 13:29:43 SQL Cursor with ID 31F82F30 Buscomp: Repository Field, Forward Only: 0, Fetch Rows: 1279, Fetch All Time: 229.815 seconds.

ENVIRONMENT
-----------------------
The current version used: 17.4 [IP2017]

Cause

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