Reporter Exceptions Extraction take too long
search cancel

Reporter Exceptions Extraction take too long


Article ID: 84907


Updated On:


CA Automic Dollar Universe


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.



OS: All


Cause type:Defect
Root Cause: More indexes are required to improve the insertion performances in the table UNI_EVT_INTERVENTIONS


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