Start Loop in DS7.1

DSguru2B · Post by **DSguru2B** » Mon Jul 10, 2006 1:24 pm

Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.

chulett · Post by **chulett** » Mon Jul 10, 2006 1:33 pm

pmadhavi wrote:I diasabled the mutli instance option long back. Only for the first value of the csv file, the job is running successfully. But for 2nd onwards, it is showing the following warning in the main job:
<jobname>..Transformer_0 (DSRunJob): Job control error (-2)
(DSRunJob) Job <sequencejob> is not in a runnable state

Three pages now, eh? Hope they can afford the bill when it comes due.

Guessing here that with the multi-instance option 'disabled long back' the job is not in a runnable state because it is still running from the first value's launch.

pmadhavi · Post by **pmadhavi** » Mon Jul 10, 2006 1:34 pm

DSguru2B wrote:Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.

Please find the below code in the routine which is calling the sequence job.

$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle1 = DSAttachJob (<jobname>, DSJ.ERRWARN)
ParamName="Number"

ParamValue=Arg1

DsErrCode = DSSetParam(JobHandle1, ParamName, ParamValue)
ErrCode = DSRunJob(JobHandle1 , DSJ.RUNNORMAL)
Result = DSGetJobInfo (JobHandle1, DSJ.JOBSTATUS )
ErrCode1 = DSDetachJob(JobHandle1)

if DsErrCode=0 then Ans=Result
else Ans=Result
--------------------------------------
please find the log of the sequence below:
there's no warnings; its runnign fine and it is showing the log for the first value from the csv.

TestInvocation..JobControl (@Coordinator): Summary of sequence run
13:44:34: Sequence started
13:44:34: Job_Activity_0 (JOB <job1>) started
13:44:38: Job_Activity_0 finished, status=1 [Finished OK]
13:44:39: Job_Activity_1 (JOB <job2>) started
13:44:45: Job_Activity_1 finished, status=1 [Finished OK]
13:44:47: Job_Activity_5 (JOB <job3>) started
13:44:49: Job_Activity_5 finished, status=1 [Finished OK]
13:44:49: Sequence finished OK
(Mainjob) <- TestInvocation: Job under control finished.
-------------------------------------------

And i am using DSRunJob routine instead of Utilityjobrun.

chulett · Post by **chulett** » Mon Jul 10, 2006 1:36 pm

Ummm... where's the 'Wait for the job to complete' part?

chulett · Post by **chulett** » Mon Jul 10, 2006 1:43 pm

Specifically, you can't check for status until it has completed. Well, you can but you won't get what you are thinking you are getting.

Code: Select all

DsErrCode = DSSetParam(JobHandle1, ParamName, ParamValue) 
ErrCode = DSRunJob(JobHandle1, DSJ.RUNNORMAL) 
ErrCode = DSWaitForJob(JobHandle1)
Result = DSGetJobInfo(JobHandle1, DSJ.JOBSTATUS) 
ErrCode1 = DSDetachJob(JobHandle1)

Which means your error *is* because it was still running, hence not in a 'runable' status...

DSguru2B · Post by **DSguru2B** » Mon Jul 10, 2006 1:56 pm

Bingo, Craig is the saviour of the day.
So you were using DSJobRun() huh? And all this while i was under the impression that you were using the Utility. Because the utility is smart enough to wait for the job.

chulett · Post by **chulett** » Mon Jul 10, 2006 2:45 pm

Or perhaps purposely not waiting because of the (removed) multi-instance capabilities... as long as all the InvocationIDs were unique.

That all goes out the window with MI disabled.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 10, 2006 5:54 pm

It's not a bad idea to check that DSSetParam() has worked correctly.

pmadhavi · Post by **pmadhavi** » Tue Jul 11, 2006 10:12 am

ray.wurlod wrote: It's not a bad idea to check that DSSetParam() has worked correctly.

Thanks a lot to all of u guys.
I just added the wait command and it worked fine.