Generic Job -- Unable to see the log

chulett · Post by **chulett** » Mon Feb 08, 2010 11:22 am

I've never seen a CLEAR.FILE hang. Have you tried exporting the job to a .dsx and then immediately importing it back? That will delete / recreate everything and assign it a new number.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 08, 2010 3:55 pm

CLEAR.FILE can hang. It attempts to take a special table-level lock, and will be thwarted if any other process has any record locked in the table (hashed file). For example if someone has the job log open in Director, or has a Monitor open, then such a lock exists.

chulett · Post by **chulett** » Mon Feb 08, 2010 3:57 pm

Figured it could, just never seen it.

Any such lock would foil the export/import trick as well, I would think.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 08, 2010 4:05 pm

Indeed.

Best practice tip #Rnd(42): never have Director log or monitor open nor Designer design area open when exporting/importing that job.