Error in hash file creation
Moderators: chulett, rschirm, roy
Error in hash file creation
Hi..
I am a newbie here.Thankful to everyone for making this place fantastic knolwedge hub.
I have a problem with my hash job and resulting in the error like below.So far I have not seen this kind of error.Can anyone help me.
X..X.Trans_Dummy: DSD.UVOpen "X" is already in your VOC file as a file definition record.
File name =
File not created.
here "X" is the hash file name that i want to create.
Thanks.
Vasu.
I am a newbie here.Thankful to everyone for making this place fantastic knolwedge hub.
I have a problem with my hash job and resulting in the error like below.So far I have not seen this kind of error.Can anyone help me.
X..X.Trans_Dummy: DSD.UVOpen "X" is already in your VOC file as a file definition record.
File name =
File not created.
here "X" is the hash file name that i want to create.
Thanks.
Vasu.
Regards.
vasu
vasu
Hi Vasu...
Even after enabling this option you are getting the same error...Then can you check this:
Even after enabling this option you are getting the same error...Then can you check this:
This was discussed previously..and this is given by 'rmrama'.You can do a search on "DSD.UVOpen "X" is already in your VOC file as a file definition record" in the forum based on search for all terms.. You have few posts on this...I got the same error message after physically deleting the hash file folder created by a job. To get the problem solved, I:
1 - logged into Administrator, and issued the statement "select * from VOC where NAME = 'xxxx'"
2 - Based on the result, I then issued the statement "delete from VOC where NAME = 'xxxx' ".
The steps above will help you remove the existence of your hash file within the Datastage VOC file. Some point of note:
1 - The hash files I created were stored in folders and not project. I accidentally deleted the folder holding the DATA.30, OVER.30, etc. After the steps above, I had to delete the corresponding D_XXXX file to completely remove the existence of the hash file before re-running the job.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You may need to remove all three components of the hashed file manually before you can proceed. Something, somewhere, has gotten out of sync.
Remove the data portion of the hashed file with
Remove the dictionary portion of the hashed file with
Remove the VOC entry for the hashed file with
Remove the data portion of the hashed file with
Code: Select all
rm -rf hashedfile
Code: Select all
rm -f D_hashedfile
Code: Select all
`cat /.dshome`/bin/dssh "DELETE FROM VOC WHERE @ID = 'hashedfile';"
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.
Does
rescue.
Code: Select all
DELETE.FILE X
Success consists of getting up just one more time than you fall.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need to be on the server machine. Change directory to your project directory and execute the given commands there.
An alternative is to use the Administrator client command window. In that case the UNIX commands are each "wrapped" with an SH verb.
An alternative is to use the Administrator client command window. In that case the UNIX commands are each "wrapped" with an SH verb.
Code: Select all
SH -c "rm -rf hashedfile"
SH -c "rm -f D_hashedfile"
DELETE FROM VOC WHERE @ID = 'hashedfile';
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.