error writing a hash file

pkomalla · Post by **pkomalla** » Mon Jun 12, 2006 7:10 am

While running a job which creates a hash file of data in a oracle table, listener was down.When I restarted the job after solving the problem, I got warning saying write error for each record.

But the job was running fine earlier.

Can anyone help me

thanks

chulett · Post by **chulett** » Mon Jun 12, 2006 7:16 am

Copy and paste a warning from the log here.

pkomalla · Post by **pkomalla** » Mon Jun 12, 2006 7:40 am

Link: link_name, 0 rows, last error=2006-06-12 08:50:36\job_name..hashfile_name.link_name: WriteHash() - Write failed for record id 'XXXXX'

This is the error format for each record.

ArndW · Post by **ArndW** » Mon Jun 12, 2006 7:52 am

Is your disk that the hashed file resides on filling up to 100%?

If not, try making your derivation for the key into OCONV(KeyColumn,'MCP') to replace unprintable characters with a '.' and see if that makes a difference.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 12, 2006 2:52 pm

Is there anything unusual about this hashed file - static hashed, 2GB in size, etc.?