Salesforce

Can't compact trend database

« Go Back

Information

 
TitleCan't compact trend database
URL Name000027248
Article Number000167517
EnvironmentProduct: 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 MessageArchiving 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 Date11/8/2016 11:41 AM

Powered by