Information

Title	Can't compact trend database

URL Name	000027248

Article Number	000167517

Environment	Product: OpenEdge Management Version: 10.x, 11.x OS: All supported platforms

Question/Problem Description

Running trend Data Compaction job fails when multiple jobs are running.
Cannot run Fathom Trend database data compaction job
Unable to execute Fathom compaction job

Steps to Reproduce

Clarifying Information

Error Message	Archiving Locked - cannot be run more than once at a time! Ending data compaction for <>

Defect Number

Enhancement Number

Cause

The previous Data Compaction job failed. To avoid double execution of this job, the "lock" record has been created within the Fathom trend DB. Since the job crashed, the "lock" record is still there.

Resolution

Clear the lock record by connecting to the Fathom Trend database and running following ABL/4GL code:

FIND FIRST Cf_Control where ID = "Lock_Compact" EXCLUSIVE-LOCK NO-ERROR.
    IF AVAILABLE Cf_Control THEN DELETE Cf_Control.

Pay special attention to any failures when the data compaction job is run again.

Workaround

Notes

Keyword Phrase

Last Modified Date	11/8/2016 11:41 AM

Can't compact trend database

Information