JobAuditReport..BeforeJob (DSAttachJob): Job control 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
mallireddibalaji
Participant
Posts: 24
Joined: Wed Mar 19, 2008 1:13 am

JobAuditReport..BeforeJob (DSAttachJob): Job control error (

Post by mallireddibalaji »

Hi Guru's,


we have the Multiple instance job,
That job getting aborted and giving fatal error as follows:

JobAuditReport..BeforeJob (DSAttachJob): Job control error (-12)
(DSOpenJob) Cannot get shared access to executable file for job XXXX.


what may be the possible reason for this?



Thanks in advance....
M.BALAJI
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
mallireddibalaji
Participant
Posts: 24
Joined: Wed Mar 19, 2008 1:13 am

Post by mallireddibalaji »

chulett wrote:Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :? ...

Yes, In my sequence we are calling the MI job 12 times , but flow is sequential (i.e one MI with some invocation id after this job completion , next MI with different invocation id like this we are running 12 times sequentially by passinf different invocation id's)


Thanks In Advance....
M.BALAJI
Katie09
Participant
Posts: 15
Joined: Sun Jan 11, 2009 5:45 pm
Location: Sheffield

Post by Katie09 »

Though the jobs inside the sequencer are having the sequential flow..
whether there are multiple user trying to run it.

it could happen the job for same instacne ran by diffrent user and it got aborted..

..
Katie09
Participant
Posts: 15
Joined: Sun Jan 11, 2009 5:45 pm
Location: Sheffield

Post by Katie09 »

Though the jobs inside the sequencer are having the sequential flow..
whether there are multiple user trying to run it.

it could happen the job for same instacne ran by diffrent user and it got aborted..

..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

mallireddibalaji wrote:
chulett wrote:Is your multi-instance job running another job 'before job'? If so, is that other job MI as well? :? ...
Yes, In my sequence we are calling the MI job 12 times , but flow is sequential (i.e one MI with some invocation id after this job completion , next MI with different invocation id like this we are running 12 times sequentially by passinf different invocation id's)
That's not what I asked. Your error is coming "before job" and references functions used to run jobs, probably from a custom routine. So let's back up a little and just ask - what exactly is going on in the "before job" section of this multi-instance job? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are you providing an invocation ID in DSAttachJob?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mallireddibalaji
Participant
Posts: 24
Joined: Wed Mar 19, 2008 1:13 am

Post by mallireddibalaji »

ray.wurlod wrote:Are you providing an invocation ID in DSAttachJob? ...

Yes, we are providing the invocation ID to the DSAttachJob.
M.BALAJI
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

So now answer Craig's question. Ideally post your before-job routine code (encased in Code tags).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply