got Job aborted message, but?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
anwarsait
Participant
Posts: 1
Joined: Sun Jul 23, 2006 11:22 pm

got Job aborted message, but?

Post by anwarsait »

Hi,

I was running batch of ETL datastage server jobs from a Main sequence Job. I got job aborted message in the Main job status window, but i noticed from job log message that all the ETL server jobs completed successfully.

I was getting below mentioned warning message from MainJob log.
MainJob..Controller problem:Error Calling(sub job name), code=-2(..)
MainJob..Will execute error activity:ExceptionalHandler
MainJob..Jobcontrol(DSSendMail): Parameter 4((job is not in right state(compiled not running))does not start with..

MainJob...... Routine DSSendMail did not finish Ok, return code='-19'

what could be the reason for getting such warning messages..

Your suggestions and help will be highly appreciated..

Thankx
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Could be a case, where the job that has been reported as not in runnable state might not have been triggered for that particular run, or might be running by some other sequence at the same time.
Check that job log to find the Controller that calls it.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
sudhakar_viswa
Participant
Posts: 85
Joined: Fri Nov 18, 2005 5:35 am

Post by sudhakar_viswa »

Hi anwarsait,

The one of the job in batch is not in runnable state. Try to specify invocation ID and run it. Because one job is used by many other sequences at that time this error will occur.

Regards,
-- sudhakar
i need to know datastage
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Make sure the job is enabled with "Multiple Instance" for the case above.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply