Page 1 of 1
Error when loading data into hash file
Posted: Thu Nov 04, 2004 1:53 pm
by ksmurthys
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??
Posted: Thu Nov 04, 2004 2:32 pm
by mhester
The first thing that pops into my mind is to check and see if the disk is full?
Posted: Thu Nov 04, 2004 3:24 pm
by ksmurthys
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.
Posted: Thu Nov 04, 2004 3:27 pm
by mhester
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,
Posted: Thu Nov 04, 2004 3:32 pm
by ray.wurlod
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