Job Multiple Instance Fail

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

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

Post by ray.wurlod »

Each instance is logged separately, at least logically (the entries are all in the same table, but each is inspected through its own "view"). You open each instance's log in Director.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

Ray,

I can't see the log of the instance that gave mistake, it doesn't appear in the director.
See the log of the sequence. When the job multiple instance is called it begins and it concludes with the status = 99, this provokes the abort of the sequence.

Item #: 4
Event ID: 1011
Timestamp: 2009-03-06 10:30:29
Type: Info
User Name: SERVER85|isadmin
Message Id: IIS-DSTAGE-RUN-I-0019
Message: SeqChamaRTExecJob.SeqDocSiatcProposta.JobControl (DSWaitForJob): Waiting for job SeqDocSiatcProposta to finish

Item #: 5
Event ID: 1012
Timestamp: 2009-03-06 10:30:29
Type: Info
User Name: SERVER85|isadmin
Message Id: IIS-DSTAGE-RUN-I-0019
Message: SeqChamaRTExecJob.SeqDocSiatcProposta.JobControl (DSWaitForJob): Job SeqDocSiatcProposta has finished, status = 99 (Not running)
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Where's your InvocationID? It looks to me like you're running your MI job in a non-MI mode as I would think it would say "Waiting for job SeqDocSiatcProposta.??? to finish" otherwise. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

Do an exact search on "status = 99 (Not running)". This seems to be a bug related to auto-purge and multi-instance for version 8x.

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

Post by ray.wurlod »

Check that you are supplying the invocation ID correctly. There does not appear to be an invocation ID in these messages.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

Mike,

I saw that post, but don't solve the problem. I think this is another problem.

Thanks
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

We think so, too. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

Forgive me, in fact, the job that is multiple instance is the sequence and not the job server.

After accomplishing more tests, I noticed that what really happens is the following:

I have two sequences, and the sequence father is not multiple instance, but the son is.
The sequence son, is invoked inside several times of the sequence father.

Usually, the mistake happens when the sequence son is invoked simultaneously at once, in other words, the fact of invoking the multiple instance sequence simultaneously several times is provoking the mistake.
I know this because I change the job father, placing the calls for the sequence son in sequence and the error ended.

But this doesn't solve the problem because sometimes I need to execut in parallel and not in sequence.
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Do you have your auto-purge enabled? That has caused some issues for me in the past when multi-instance log details have disappeared on me.
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

I tured off the auto-purge, however the error persisted.
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You do understand that, for any multi-instance job to work "in parallel" that each invocation id must be unique amongst any running invocations, yes?
-craig

"You can never have too many knives" -- Logan Nine Fingers
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

Yes, for each instance a different id is passed.
The ID is passed though a different parameter for each instance.
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

Yes, for each instance a different id is passed.
The ID is passed though a different parameter for each instance.
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please verify that this is, in fact, truly happening. The log messages you've posted so far seem to indicate otherwise.
-craig

"You can never have too many knives" -- Logan Nine Fingers
marcelo_almeida
Premium Member
Premium Member
Posts: 46
Joined: Wed Jun 28, 2006 9:54 am
Location: Brasília - Brazil

Post by marcelo_almeida »

You are correct.

But as I said this morning, the problem is with the sequence (SeqChamaRTExecJob.SeqDocSiatcProposta) and not with the job server (SeqDocSiatcProposta).
The log I posted is the job sequence. The job of multiple instances is the job sequence and it is having problems.
Marcelo Almeida
antoniomarcelo@gmail.com
Brazil
Post Reply