Hi Everyone,
One of my DataStage is aborting in production environment and it is throwing below error message. I am trying to generate a hash file from my job, Then this problem is happening.
"GSO04_Occ_Fact_Load..tMap2: |GSO04_Occ_Fact_Load..hOCC_Fact.lhOCC_Fact: DSD.UVOpen "hOCC_FACT" is already in your VOC file as a file definition record.
File name =
File not created."
I did the below steps to resolve this issue.
-- First I copied the existing hash file "hOCC_FACT" from another directory.
-- I executed DELETE.hOCC.FACT command in Administrator.
Then I am getting one more error i.e.,
"Verb "delete.hocc_fact" is not in your VOC"
Since, it is a production box. So, I stopped my research activities. Can anyone have any Idea about this? Thank you.
Problem with VOC File.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no problem with your VOC file. You have not understood the syntax and requirements.
1. You need to copy not only hOCC_FACT but also D_hOCC_FACT to the other directory.
2. You need to delete a record from VOC, not construct a command. Use a standard SQL statement such as
In short, the actual problem is between the keyboard and the chair.
1. You need to copy not only hOCC_FACT but also D_hOCC_FACT to the other directory.
2. You need to delete a record from VOC, not construct a command. Use a standard SQL statement such as
Code: Select all
DELETE FROM VOC WHERE @ID = 'hOCC_FACT';
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.
Thanks for your quick response.
Yes, I did the same thing.
1. I copied "hOCC_FACT" folder and "D_hOCC_FACT" file into another directory.
2. I executed DELETE.hOCC_FACT command in administrator still i am getting the same error.
"Verb "delete.hocc_fact" is not in your VOC"
Can you please tel how to resolve this issue. Thank you.
Yes, I did the same thing.
1. I copied "hOCC_FACT" folder and "D_hOCC_FACT" file into another directory.
2. I executed DELETE.hOCC_FACT command in administrator still i am getting the same error.
"Verb "delete.hocc_fact" is not in your VOC"
Can you please tel how to resolve this issue. Thank you.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I provided a complete solution. And corrected your erroneous syntax.
You need to obtain premium membership to see my complete reply.
Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are funded. It's not expensive, at less than 30c per day, and the benefits do outweigh the costs.
You need to obtain premium membership to see my complete reply.
Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are funded. It's not expensive, at less than 30c per day, and the benefits do outweigh the costs.
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.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Heard the term VOC many a times but dont actually know what it is except that it is a file that contains a list of functions. Could anyone highlight what this file is and its significance. I checked in some of the guides but didnot find any reference, if any one can provide the reference to the documentation it would be very helpful
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: