1 Reply Latest reply: Jun 11, 2010 11:07 AM by mmontagu RSS

very slow ESS Console initialisation (Oracle DB)

bmcnoob

Hi folks

 

We have the same problem as Palle Hansen from Rabobank. Login to ESS Console when using Oracle, the Console will take one minute to initialise.

 

 

Leonid Boguslavsky adviced:

 

First of all, try to examine GUI trace - to see where it works slow. If it
happens during keywords retrieve stage - its explainable.
As far as I remember, it was always a problem to initialize GUI over slow
connections with limited bandwidth. The reason for this is that during
initialization GUI retrieve full content from keyword table, where
add_info_master is a long column. Since such column can contain up to 2mb
value size Oracle client allocate 2mb for each record disregard to its real
length to transfer it over the network to the GUI side. This is what I
remember from the past.

 

If your trace check prove my guess - try to change add_info_master datatype
in keyword table from long to varchar2 (it allows up to 4k, which is enough
for keywords definitions) and test it again.

 

If it does not help - time to open a case...to check are there also remains
anyone...

 

Here is our GUI trace

 

==>06/11/10 10:53:44  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Groups
==>06/11/10 10:53:44  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Resource
==>06/11/10 10:53:44  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Resource
==>06/11/10 10:53:44  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Resource Type
==>06/11/10 10:53:46  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Version
==>06/11/10 10:53:46  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Value
==>06/11/10 10:53:46  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Policy Group
==>06/11/10 10:53:46  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Attribute name
==>06/11/10 10:53:46  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Type
==>06/11/10 10:53:54  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System
==>06/11/10 10:53:54  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System Administrator
==>06/11/10 10:53:54  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System Type
==>06/11/10 10:53:54  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System Type-Keyword
==>06/11/10 10:53:54  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Allowed Login Times
==>06/11/10 10:53:56  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Tablespace name
==>06/11/10 10:53:56  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Admin
==>06/11/10 10:53:56  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Admin
==>06/11/10 10:53:57  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Name
==>06/11/10 10:53:59  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:TRUST
==>06/11/10 10:54:04  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:TRUST
==>06/11/10 10:54:06  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:TRUST
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:TRUST
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Transaction Code
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Value
==>06/11/10 10:54:07  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:08  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:08  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Default
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Flag
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Day
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Privilege
==>06/11/10 10:54:09  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Privilege
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:End
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Metric
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Fast message retrieval
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:ILS Account
==>06/11/10 10:54:10  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Account
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:High
==>06/11/10 10:54:10  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Label
==>06/11/10 10:54:10  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Keyword Rules
==>06/11/10 10:54:11  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:ENTRY ID
==>06/11/10 10:54:11  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:To date
==>06/11/10 10:54:11  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:SAP CUA Child Systems
==>06/11/10 10:54:11  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Account-Group
==>06/11/10 10:54:11  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Admin Group
==>06/11/10 10:54:12  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Admin Group-Access Rule
==>06/11/10 10:54:12  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Site Table
==>06/11/10 10:54:12  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Value
==>06/11/10 10:54:12  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Template
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:12  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:967 ===>TD Load:  Entity Not found:trans_archive
==>06/11/10 10:54:13  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Transaction
==>06/11/10 10:54:13  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile-Group
==>06/11/10 10:54:13  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Admin
==>06/11/10 10:54:13  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Admin
==>06/11/10 10:54:13  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Limit
==>06/11/10 10:54:14  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Roles
==>06/11/10 10:54:15  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Roles
==>06/11/10 10:54:15  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Roles
==>06/11/10 10:54:15  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:Simple role
==>06/11/10 10:54:15  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:member
==>06/11/10 10:54:15  File:Td.cpp Line:1683 ===>Incorrect number of sub-fields for field:memberOf
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Group
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Person-Profile
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Person-Profile-Managed System
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:User Preferences
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:All Alerts
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:All Audit Details
==>06/11/10 10:54:16  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:All Audits
==>06/11/10 10:54:17  File:Essapi.cpp Line:2326 ===>DB Query Ended. Records Read=4863
==>06/11/10 10:54:17  File:eeDB.cpp Line:607 ===>Sql Query=SELECT * FROM keyword_view ORDER BY keyword_view.entity ASC , keyword_view.rss_type ASC , keyword_view.keyword_order ASC
==>06/11/10 10:54:17  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Permitted Applications
==>06/11/10 10:54:17  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:ACE Key
==>06/11/10 10:54:17  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Ess Administartor Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:ESS Administrator Restriction
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Access Rule Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Audit Audit Information
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Audit Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile-Template Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Keyword Location Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:All Keywords
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Keyword Key
==>06/11/10 10:54:18  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Keywords List
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Keyword User
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Container Key
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Platform Key
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Applications
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Authentication Host
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Password Policy
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Resource Key
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Resource Type
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Resource Type
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System Key
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Managed System Type
==>06/11/10 10:54:19  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:RSS Type Key
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Account Key
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Rules Key
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Account - Group Key
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Account
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Group
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Admin Group Key
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Security Group Restriction
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Admin-Group-Restriction
==>06/11/10 10:54:20  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Template
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Trans View RSS
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Group
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Group Key
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:User Profile RSS Valid View
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Profile
==>06/11/10 10:54:21  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Person View
==>06/11/10 10:54:22  File:Td.cpp Line:881 ===>TD Load:  Finished loading Entity:Person Key
==>06/11/10 10:54:22  File:Essapi.cpp Line:2326 ===>DB Query Ended. Records Read=515
==>06/11/10 10:54:22  File:Td.cpp Line:661 ===>Start updating view labels.
==>06/11/10 10:54:22  File:Td.cpp Line:663 ===>View labels were updated.
==>06/11/10 10:54:22  File:EssFrame.cpp Line:7443 ===>Thread of reading keywords and rules information finished !
==>06/11/10 10:54:28  File:eeDB.cpp Line:607 ===>Sql Query=SELECT * FROM global_parm WHERE( global_parm.gp_key = 1 )
==>06/11/10 10:54:28  File:EssFrame.cpp Line:5509 ===>Data Segment Utilization is not high , 100%  is available
==>06/11/10 10:54:28  File:EssFrame.cpp Line:5522 ===>Log Segment Utilization is not high , 100%  is available
==>06/11/10 10:54:28  File:EssFrame.cpp Line:5535 ===>Index Segment Utilization is not high , 100%  is available
==>06/11/10 10:54:52  File:EssFrame.cpp Line:3169 ===>User Stopped GUI Trace

 

 

Change the add_info_master datatype  in keyword table from long to varchar2. Is this officially supported by BMC? Does this help in our case?

Any other tips how to speed up initialisation?

 

cheers