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??
Error when loading data into hash file
Moderators: chulett, rschirm, roy
The first thing that pops into my mind is to check and see if the disk is full?
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
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.
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.
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,
Regards,
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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:
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.