Hi -
Job Description-
I have a simple job which is reading a sequential file, passing the data to a Xformer and then preparing a Hash file as output.
Error-
On running the job I'm receiving the following FATAL error -
DSD.UVOpen "<Hash File Name>" is already in your VOC file as a file definition record.
File name =
File not created.
.|
.|
Appreciate any pointers to what exactly the problem could be and resolution to this?
Thanks in advance,
Nitin
Error -DSD.UVOpen Hash File is already in VOC file..
Moderators: chulett, rschirm, roy
Hello Nitin,
check your Hash-file stage in your job, specifically your file creation options. You are doing a "create" upon a file that already exists, but you can change your settings to remove the error message - if that is what you wish to do, specifically to set the "delete file before create" check box.
check your Hash-file stage in your job, specifically your file creation options. You are doing a "create" upon a file that already exists, but you can change your settings to remove the error message - if that is what you wish to do, specifically to set the "delete file before create" check box.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Error -DSD.UVOpen Hash File is already in VOC file..
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.
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.