Reporter: Dollar Universe Reports are empty

Document ID : KB000104916
Last Modified Date : 05/07/2018
Show Technical Document Details
Issue:
Reporter suddenly generates reports with no data on them.
 After investigation, it was discovered that Reporter extraction node had its license expired for a while.  
Environment:
Reporter all versions
Cause:
The reason for the Reports to be empty is usually that Reporter Database does not contain the data from the Dollar Universe / Unijob Executions for the desired period of time.
This information is extracted from the table UNI_EVT_EXTRACTION.

Possible causes for this issue are:
1. Reporter Extractions have stopped being launched: issue can be due to Reporter ( Continuous Extractions) / Internal Scheduler node ( Scheduled Extractions) 
2. The Dollar Universe 6 / Unijob node where the Reporter Client has been installed stopped launching the Extraction Uproc ( which launches unirepadd), for example because its license has expired / launcher or node has been stopped...
3. Dollar Universe Execution nodes are not reachable from Reporter
4. Database issue ( filesystem full / tablespace...)
Resolution:
After having found what of the possible Causes have provoked the issue and fix the Root Cause, please relaunch the Reporter Extractions
Afterwards:
a) If the Execution Statistics have not been purged on the DUAS node ( u_fmhr60 data file), then Reporter will be able to extract those data. 
b) Else, Reporter will not be able to extract information no longer available in the Execution nodes for the Period of time that was purged from the data files.
c) New Reports will contain accurate data provided that the information is available in the Reporter Database.