Controller problem

arunverma · Post by **arunverma** » Tue Jun 08, 2004 11:39 pm

can any body help with following error ,

In our application , We have created extraction job sequencer and this sequencer call 5 Data extraction job parallely , but job sequencer could not triggered all extarction and give following error

J0BlaSrc..JobControl (@J3BlaSrc): Controller problem: Error calling DSAttachJob(J3BlaSrc)
(DSGetJobInfo) Failed to open RT_STATUS1886 file.
(DSOpenJob) Cannot open job J3BlaSrc - not a runnable job

amitdurve · Post by **amitdurve** » Tue Jun 08, 2004 11:58 pm

Check if the job being called is in runable state ("compiled"/"finished"/"has been reset").
Try running the sequence job after recompiling the jobs being controlled(the child jobs).

Sreenivasulu · Post by **Sreenivasulu** » Wed Jun 09, 2004 12:03 am

Set the jobs in the sequencer to "Reset" Mode. This would make the uncompiled jobs compile and run automatically

Regards

arunverma · Post by **arunverma** » Wed Jun 09, 2004 12:10 am

amitdurve wrote:Check if the job being called is in runable state ("compiled"/"finished"/"has been reset").
Try running the sequence job after recompiling the jobs being controlled(the child jobs).

Job is in runable state , this is working for last six month.

arun

arunverma · Post by **arunverma** » Wed Jun 09, 2004 12:11 am

Yest all job is in reset mode , it is working for last six month , we faced this problem yesterday onle .

arun

amitdurve · Post by **amitdurve** » Wed Jun 09, 2004 12:22 am

Can you try running the child job alone in test environment.
Can you open the child job?

arunverma · Post by **arunverma** » Wed Jun 09, 2004 12:33 am

NO ,

This job is in production , nobody can open , we test all child job and Individually , working fine . reset option seted

arun

amitdurve · Post by **amitdurve** » Wed Jun 09, 2004 12:35 am

Save this child job which cannot be invoked, with some other name. Use this new name to call it from the sequencer.

arunverma · Post by **arunverma** » Wed Jun 09, 2004 1:30 am

Hi amitdurve ,

We can change job name this is running application , if we change chaild job , we have to change a lot of place , but probelm is why it not triggred ,
is any other solution .

Arun

amitdurve · Post by **amitdurve** » Wed Jun 09, 2004 4:58 am

I am not sure about this one, but I think the problem will be solved if the DataStage server is restarted.
I am not sure why this problem exactly happens.

ogmios · Post by **ogmios** » Wed Jun 09, 2004 9:34 am

my 2 cents, your T30FILES is set too low. You run a lot of jobs at the same time and you hit the limit. Search for T30FILES on this site.

And if that's not it look at the access rights of the physical directory RT_STATUS1886 in your project.

Ogmios

arunverma · Post by **arunverma** » Wed Jun 09, 2004 11:01 pm

Yest it is true that this time a lot of process run , let it me search file and test ,
then i will reply

Thanks

Arun

ray.wurlod · Post by **ray.wurlod** » Thu Jun 10, 2004 12:38 am

The command to monitor how many dynamic hashed files are open on the system (that is, the figure that is limited by T30FILE) is

Code: Select all

ANALYZE.SHM -d

You need to be in the UV account to execute ANALYZE.SHM from the TCL prompt, or you can execute analyze.shm -d (or smat -d) from the operating system command prompt. Make sure that the DataStage bin directory is in PATH, otherwise you'll need to type in the full pathname of the command.

Each line in the report represents one open dynamic hashed file. Beware that, on an 80 column display, the report wraps around; better is to capture the output into a file, pipe it through wc, or some similar method for answering the "how many" question.

Notes

smat stands for "shared memory analysis tool"; it's the old name for the analyze.shm command, but they use exactly the same executable.

The option is case sensitive; it must be lower case.

arunverma · Post by **arunverma** » Thu Jun 10, 2004 1:48 am

We have checked in confing file that T30FILES values is 1000 , should we increase more .

arunverma · Post by **arunverma** » Thu Jun 10, 2004 1:54 am

Hi Ray ,

Is it related to controler problem ?

Thanks & Regards

arun