Kbase P30366: Fathom - Archiving Locked - cannot be run more than one at a time!
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/4/2009 |
|
Status: Verified
SYMPTOM(s):
Can not compact / purge data in the Fathom trend database
The MonthlyCompaction.out job log file repeats itself
with the following log lines::
Starting data compaction for nosrv017 ...
Archiving Locked - cannot be run more than one at a time
Ending data compaction for nosrv017
Cannot run Fathom Trend database data compaction job
Unable to execute Fathom compaction job
FACT(s) (Environment):
Progress 9.1D
Fathom Management 3.0A
Fathom Management
CAUSE:
The previous data compaction job has 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.
FIX:
Connect to the Fathom trend DB and issue following 4GL code:
FIND FIRST Cf_Control where ID = "Lock_Compact" EXCLUSIVE-LOCK NO-ERROR.
IF AVAILABLE Cf_Control THEN DELETE Cf_Control.
Now you can re-run the data compaction job again.