Problem with VOC File.

[kondeti]

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.

[ray.wurlod]

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

Code: Select all

DELETE FROM VOC WHERE @ID = 'hOCC_FACT';

In short, the actual problem is between the keyboard and the chair.

[kondeti]

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.

[ray.wurlod]

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.

[zulfi123786]

I provided a complete solution. And corrected your erroneous syntax.

Its really good to have such people who support the learners........ :D

[zulfi123786]

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

[ray.wurlod]

See this thread
Read UniVerse System Description manual.