Reporter extractions hang

Document ID : KB000085914
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
No Error

Patch level detected:Reporter 6.1.00
Product Version: Dollar.Universe 6.1.01

Description :Reporter extractions hang. Running extraction are not finishing. No new extractions start.
A large number of Extractions are scheduled or the Continuous Extraction is configured.

When running the SQL command below, a very high number of records is returned
SQL> select count(*) from REPOWNER.UNI_EVT_EXTRACTIONS;

COUNT(*)
----------
1384527
Environment:
OS: Linux
Cause:
Cause type:
Configuration
Root Cause: The tabel that keeps track WHEN past extractions took place is not purged properly. This is likely to happen when Continuous Extraction is used with the default value for Extraction History (180 days)
Resolution:
Workaround: Kill the reporter process. Then in mgr/server.conf apply the following: useDBChecker = false. Restart the Reporter server.

Solution: Reduce the Extraction History (In UVC, Reporter Node Settings, Maintenance, Purge for Reporter set Extraction History=7). Run a manual purge to cleardown the Extraction History immeadiately (UVC, Administration, Reporter DB, Extraction purges. Click Purge).

Fix Status: No Fix

Additional Information:
Workaround :
N/A