Datastage batch job failures

Angelok · Post by **Angelok** » Thu Mar 29, 2012 11:28 am

Has anybody ever experienced a batch job failure, where the Source Stage says that it's "Starting" and the Target stage is "Waiting".? After 6 hours, the job fails and there is nothing in the Director Log.

Thank you,

PaulVL · Post by **PaulVL** » Thu Mar 29, 2012 12:41 pm

Not a lot to go on here.

There is always something in the log. You just did say why the job aborted. What is the abort message?

Angelok · Post by **Angelok** » Thu Mar 29, 2012 12:52 pm

This is the message from the UNIX Log. It times out after 6 hours.

DataStage output is: Waiting for job...
Error 81002 waiting for job

Status code = 81002
ERROR: Job did not run

chulett · Post by **chulett** » Thu Mar 29, 2012 3:57 pm

There are 10 other matches for "Error 81002" if you do an exact search here, see if any of them help.

Also, what is your project level timeout value set to, 21600?

kandyshandy · Post by **kandyshandy** » Thu Mar 29, 2012 9:35 pm

Does the job run if you run it manually? What is your job design?

Angelok · Post by **Angelok** » Fri Mar 30, 2012 10:05 am

kandyshandy wrote:Does the job run if you run it manually? What is your job design?

Yes, after restarting the job, it always completes successfully.

The job design contains some data checking and a couple of look ups. It also goes through our firewall and the Vendor's Firewall as well. I am thinking that it may be running into some Network issue?

I have never seen this failure message for jobs that run within our Organization.

Angelok · Post by **Angelok** » Fri Mar 30, 2012 10:27 am

chulett wrote:Also, what is your project level timeout value set to, 21600?

Thnak you,

Llet me check with the Admin Group.

chulett · Post by **chulett** » Fri Mar 30, 2012 10:35 am

Angelok wrote:Yes, after restarting the job, it always completes successfully.

That smacks of a resource issue, probably on your source / vendor side. Can you go into a little more detail on your source and the "data checking" you are doing?

Angelok · Post by **Angelok** » Fri Mar 30, 2012 2:24 pm

Hi Craig,

The Source tables are located in an Oracle (9i) Database. Datastage connects through a DB_Link.

As far as the Data checking goes, it's very basic, just simple validations. Actually, most of the Datastage jobs are just straight pulls. The interface contains 18 jobs, and almost all have failed with the same message (81002), at one time or another over the past year.

Thank you,
Angelo