Salesforce

Fathom / OEM Data Compact job not purging AR_* tables.

« Go Back

Information

 
TitleFathom / OEM Data Compact job not purging AR_* tables.
URL Namedata-compact-job-not-purging-ar-tables
Article Number000178263
EnvironmentProduct: Progress
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Other: Fathom / OpenEdge Management
Question/Problem Description
The data compact job is setup to compact data older that 90 days and delete data older than 180 days.
The AR_OE_ACTWSProc, AR_OE_ActASProc, AR_OE_ActBrk, and AR_OE_ActServ tables have data older than this which is not being removed.
Steps to Reproduce
Clarifying Information
Error Message
Defect NumberDefect PSC00351001, OCTA-24024
Enhancement Number
Cause
The Data Compact job within Fathom / OEM is not purging data for the following tables:
R_OE_ACTWSProc
AR_OE_ActASProc
AR_OE_ActBrk
AR_OE_ActServ
Resolution
Until the fix is available, use the workaround below.
Workaround
Within the zip file attached to this article are 4 procedure files which can either review the data or optionally delete the data.
Sections of the code are currently commented out.
Specifically the where clause and the delete statement.

To use these pieces of code all the commented code must be un-commented.  (i.e. remove all the /* and */ references within the code samples.
Notes
Keyword Phrase
Last Modified Date7/7/2022 2:07 PM

Powered by