WriteHash() - Write failed for record id 'CHER'

padmalavanya · Post by **padmalavanya** » Thu Oct 04, 2012 7:05 am

The job runs every day but fails once in week with this error

WriteHash() - Write failed for record id 'CHER'

From previous run
DataStage Job 788 Phantom 230
Program "DSD.UVClose": Line 56, WRITE attempt on read-only file.

please help with this

Thanks

ArndW · Post by **ArndW** » Thu Oct 04, 2012 8:29 am

If it is the same file and the same record and the same user then I'd see if the hashed file might be broken at that address. Try a "RESIZE filename * * *" from the DataStage command line when the file isn't being used and see if the error subsequently goes away. If the RESIZE shows problems, then you would need to do a UVFIXFILE.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 04, 2012 3:23 pm

The error message indicates that you (the user name under which connection is made) do not have write permission to the hashed file.