QualityStage standardize stage error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

QualityStage standardize stage error

Post by abc123 »

I have a simple job:

Dataset ---> Standardize ----> Dataset

I get the following error:

STD_Stage: Unable to open control file ./RT_QS156/V0S1/Controls/USADDR2_NAMESTD.DCT for input, reason code 2
No such file or directory

I had created a ruleset called USADDR2. I found the directory but another person can run this job fine.
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Re: QualityStage standardize stage error

Post by bobyon »

abc123 wrote:I have a simple job:

Dataset ---> Standardize ----> Dataset

I get the following error:

STD_Stage: Unable to open control file ./RT_QS156/V0S1/Controls/USADDR2_NAMESTD.DCT for input, reason code 2
No such file or directory

I had created a ruleset called USADDR2. I found the directory but another person can run this job fine.

I am having the same issue. Did you ever find a resolution?

Thanks,
Bob
Bob
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

After designing (or importing) the job, did you provision the server with the files it needs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Post by bobyon »

I did run a Provision ALL on each of the standardization rules in the project before compiling all the jobs. Is that what you are asking or is there something else that needs to be done?
Bob
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Bobyon,

If you ran a "provision all" to this new rule and another person can run the job fine then take a look a permisions

You wrote:

"I had created a ruleset called USADDR2. I found the directory but another person can run this job fine"
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Post by bobyon »

I went back and peformed all the steps again slowly and in order and things went fine. I must have gotten something out of order the first time. MIght have done the compiles before the provisioning.

At any rate, all is well now.
Bob
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Post by bobyon »

I went back and peformed all the steps again slowly and in order and things went fine. I must have gotten something out of order the first time. MIght have done the compiles before the provisioning.

At any rate, all is well now.
Bob
Post Reply