Reporter Exceptions Extraction take too long

book

Article ID: 84907

calendar_today

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.

 

Cause

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

Environment

OS: All

Resolution

Workaround :
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