Reporter Exceptions Extraction take too long
Article ID: 84907
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Error Message :
No error message displayed.
Product: Reporter extracting Dollar Universe 6 nodes
Reporter takes too long to extract data from all nodes and also the total time is growing daily.
Most of the nodes that need more than 30 minutes are using most of the time to extract Exceptions.
No error message displayed.
Product: Reporter extracting Dollar Universe 6 nodes
Reporter takes too long to extract data from all nodes and also the total time is growing daily.
Most of the nodes that need more than 30 minutes are using most of the time to extract Exceptions.
Environment
OS: All
Cause
Cause type:Defect
Root Cause: More indexes are required to improve the insertion performances in the table UNI_EVT_INTERVENTIONS
Root Cause: More indexes are required to improve the insertion performances in the table UNI_EVT_INTERVENTIONS
Resolution
Workaround :
The following indexes needs to be added manually on the table UNI_EVT_INTERVENTIONS
Solution: Upgrade to a fix version listed below or a newer version if available.
Starting on version 6.9.01, these indexes will be created when installing Reporter Server, else, the sql script included needs to be executed to add them to the existing database.
Fix Status: Released
Fix Version(s):
Component: Reporter
Dollar Universe 6.9.01- Available
The following indexes needs to be added manually on the table UNI_EVT_INTERVENTIONS
(HISTORY_OEXID_NUMSESSION,DATASOURCE_ID,HISTORY_OEXID_NUMPROC,HISTORY_OEXID_NUMLAUNCH,HISTORY_OEXID_SUBTYPE)
Solution: Upgrade to a fix version listed below or a newer version if available.
Starting on version 6.9.01, these indexes will be created when installing Reporter Server, else, the sql script included needs to be executed to add them to the existing database.
Fix Status: Released
Fix Version(s):
Component: Reporter
Dollar Universe 6.9.01- Available
Feedback
Yes
No
Powered by
