Error when loading data into hash file

ksmurthys · Post by **ksmurthys** » Thu Nov 04, 2004 1:53 pm

Hi,

I am loading data into hash file from ODBC table.After 465000 rows the job was aborted because of the following error
"LoadHashedFiles.parthsh.DSLink26: ds_uvput() - Write failed for record id 'PS182496L-APC-APFC-BRFXS'"
Key field in tha hash file is part_num,datatype VARCHAR and size 64.

How do i resolve this issue??

mhester · Post by **mhester** » Thu Nov 04, 2004 2:32 pm

The first thing that pops into my mind is to check and see if the disk is full?

ksmurthys · Post by **ksmurthys** » Thu Nov 04, 2004 3:24 pm

Michael,

You are right.Space on datasatge server is full.
My datastage server installed on Wndows Sever SADW(E:drive).Recently we added 100 GB to Windows server SADW(F:drive).
Why datastage server is not taking space from F:drive(added space)?
What are the steps do i take to recognise F:drive by datastage server?

Thanks,
Srirama.

mhester · Post by **mhester** » Thu Nov 04, 2004 3:27 pm

If the Hash is being created in the project then you will have this issue. If you want to create the hash somewhere else then you could search this forum for many posts that talk about such things and how to manage these files.

Regards,

ray.wurlod · Post by **ray.wurlod** » Thu Nov 04, 2004 3:32 pm

Nothing on Windows automatically uses other than the current drive.
Why did you think DataStage would be an execption?

You can specify the location of a hashed file in two ways:

by creating it in a folder on the F: drive

by creating a DataStage account (project) on the F: drive and specifying that the hashed file should be created in that account