Job Status 99

bollinenik · Post by **bollinenik** » Mon Jun 01, 2009 12:12 pm

Hi,
I have some sequences which is calling couple of multiple instance jobs along with regular Load jobs, so when I try to call those sequences in one master sequence then I am facing problem called status 99.

" NW_ONE_EPM_SEQ_Recon_Daily_Balance..JobControl (DSWaitForJob): Job NW_ONE_Truncate_Table_before.PS_NW_RCN_D_DD_SF has finished, status = 99 (Not running)"

Master seq is triggering 3 sub sequences and those sub sequences are calling multiple instance jobs. first job is complting with status Finished, but it's not passing the status to next link staying that status is 99 not running.

" " NW_ONE_EPM_SEQ_Recon_Daily_Balance..JobControl (DSWaitForJob): Job NW_ONE_Truncate_Table_before.PS_NW_RCN_D_DD_SF has finished, status = 99 (Not running)""

Any help is appriciated.

mikegohl · Post by **mikegohl** » Mon Jun 01, 2009 3:35 pm

I have the exact same case open with IBM.

preetiv · Post by **preetiv** » Mon Jun 01, 2009 9:54 pm

Hi,

Are you using the same invocation id for all the multiple instance jobs?

Thanks
Preeti

preetiv · Post by **preetiv** » Mon Jun 01, 2009 9:56 pm

Hi,

If you are using the same invocation id for the multiple instance jobs, then try changing the invocation id.

Thanks,
Preeti

bollinenik · Post by **bollinenik** » Mon Jun 01, 2009 10:16 pm

nope , InvocationId is different for each call.

but still it's throughing the same error

Hi Mike-- Could you please share the details if you hear anything form IBM technical support.

ArndW · Post by **ArndW** » Tue Jun 02, 2009 1:46 am

If you have autopurge set for this job, try turning it off and seeing if the error goes away.

ArndW · Post by **ArndW** » Tue Jun 02, 2009 1:47 am

If you have autopurge set for this job, try turning it off and seeing if the error goes away.

chulett · Post by **chulett** » Tue Jun 02, 2009 6:54 am

That sounds familiar, as in a known bug with MI jobs. Let us know!

bollinenik · Post by **bollinenik** » Tue Jun 02, 2009 10:27 am

How can I auto purge off only for specific job, can you please suggest me

chulett · Post by **chulett** » Tue Jun 02, 2009 11:28 am

Director / Job / Clear log...

mikegohl · Post by **mikegohl** » Thu Jun 04, 2009 3:43 pm

Sorry to not get back to you sooner. The tech supporting my case just keeps sending me more questions. I will update the thread if I ever get an answer.

bollinenik · Post by **bollinenik** » Mon Aug 10, 2009 8:07 pm

Hi Mike,
Did you hear any good news from Tech support, please share thsoe details if you have any thing about this probelm.

bollinenik · Post by **bollinenik** » Mon Aug 10, 2009 8:08 pm

Hi Mike,
Did you hear any good news from Tech support, please share thsoe details if you have any thing about this probelm.

mikegohl · Post by **mikegohl** » Mon Aug 10, 2009 8:13 pm

No,

I've moved to a new client. The last thing we did was change the auto purge setting. The problem might of went away.

Sorry!

narayana_382 · Post by **narayana_382** » Mon Aug 10, 2009 8:20 pm

Bollineik, there is a latest patch for 8.0.1 to fix this issue. Support might be able to get this depending upon the operating system and what version level you are running the datastage.