Reporter Exceptions Extraction take too long

Document ID : KB000084907
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

 
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: More indexes are required to improve the insertion performances in the table UNI_EVT_INTERVENTIONS
Resolution:
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
Additional Information:
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)