Hash File Corrupted

[satheesh_color]

Hi All,

Regularly we are building the hash file by using the job with the following command:CREATE.FILE HashFile DYNAMIC MINIMUM.MODULUS 150000 GROUP.SIZE 2 SEQ.NUM SPLIT.LOAD 80 MERGE.LOAD 50 LARGE.RECORD 4096.

Today the job was aborted and saying that "WriteHash() - Write failed for record id '1005971
514
07' "
We then try to rerun the same job it throws the following errors;
DSD.UVOpen "HashFile" is already in your VOC file as a file definition record.
File name =
File not created.

DataStage Job 55 Phantom 11597
Program "DSD.UVOpen": Line 456, WARNING: Internal file corruption detected during file open!
File must be repaired, possible truncation.
hsize: 4096
bsize: 4096
fsize: 553547776
Job Aborted after Fatal Error logged.


Please suggest me on how to resolve this issue..

Thanks & regards,
Satheesh

[ray.wurlod]

In the Hashed File stage you have create file checked, so click on the Options tab and also check "delete file before create".

This error arises from you (or somebody) not deleting the hashed file correctly. To fix the error you need to execute three commands from the Administrator client command window.

Code: Select all

DELETE VOC hashedfilename

SH -c "rm -rf hashedfilepath"

SH -c "rm -rf D_hashedfilepath"

And please note that the correct terminology is "hashed" file, not "hash" file.

Finally, it's normal practice to allow some leeway in LARGE.RECORD - it is usually set to or below 80% of the group buffer size. You have set it to 100% of the group buffer size which, while not illegal, is likely to be hugely sub-optimal.

[satheesh_color]

Thanks for you valuable information.

Satheesh.R