Over 500,000 objects in hashed file directory

patonp · Post by **patonp** » Thu Apr 26, 2007 7:23 am

Hi Folks,

One of our jobs failed in production last night, and the director log mentions that an abort was raised in a hashed file stage.

In Windows, the directory specific to the hashed file in question contains over 500K objects, each of which seems related to a specific record. I've never seen this type of behaviour before. Any ideas about what's going on?

Thanks!

Peter

chulett · Post by **chulett** » Thu Apr 26, 2007 7:35 am

Sure. Dynamic hashed file gets 'corrupted', typically resulting in the lose of the .Type30 file. Result is it suddenly becomes a Type 19 (I believe) - one in which each record becomes a separate file.

Delete the directory and it should 'rebuild' fine. Happens sometimes when using the 'Delete' option.

patonp · Post by **patonp** » Thu Apr 26, 2007 8:24 am

Thanks Craig. Would we need to delete the D_ file as well as the directory, or just the directory?

chulett · Post by **chulett** » Thu Apr 26, 2007 8:29 am

Just the directory would suffice. Doing both wouldn't hurt.