Reporter extractions hang

book

Article ID: 85914

calendar_today

Updated On:

Products

CA Automic Dollar Universe

Issue/Introduction

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

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)

Environment

OS: Linux

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