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
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)
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).