Reporter: Incomplete Purge of table UNI_EVT_LOG

Products

• CA Automic Dollar Universe

Issue/Introduction

In Reporter, UNI_EVT_LOG contains many more rows than UNI_EVT_EXTRACTIONS which is not expected.

Reporter Purge does not reduce the number.

Environment

Release :6.x

Component : Reporter

Cause

Purge of Reporter did not purge orphan rows.

Resolution

Update to a fix version listed below or a newer version if available.

Fix version(s): 

Component: Reporter 

Dollar Universe 6.10.11 - Released 2nd October 2019

Additional Information

New request for purging orphan records has been done:

 delete UNI_EVT_LOG where LOG_ID in (select l.LOG_ID from UNI_EVT_LOG l left join UNI_EVT_EXTRACTIONS e on l.LOG_ID = e.LOG_ID left join UNI_EVT_PURGES p on l.LOG_ID = p.LOG_ID left join UNI_EVT_REPORTS r on l.LOG_ID = r.LOG_ID where p.LOG_ID is null and e.LOG_ID is null and .LOG_ID is null )