Before job abort with no other messages

lsnovick · Post by **lsnovick** » Mon Feb 20, 2012 10:03 am

I am on a new project that is using 7.5.1. I have never had this type of error. I do not receive any other errors other than:

Attempting to Cleanup after ABORT raised in stage testEMPLoad..BeforeJob

The job now only has a Relational to transformation to hash now. I broke down the job to find out what is it having an issue with. I need help figuring out where to look.

chulett · Post by **chulett** » Mon Feb 20, 2012 10:31 am

First thing to try is to Reset the aborted job and see if a 'From previous run...' message is added to the log. If so, post the contents.

lsnovick · Post by **lsnovick** » Mon Feb 20, 2012 11:17 am

It just gives me the error Unable to open file....

I am trying to write to the hash file so it does not exist yet.

chulett · Post by **chulett** » Mon Feb 20, 2012 11:35 am

That sounds like the normal reset message, so did it not add the 'From previous run...' entry? Are you actually doing anything 'before job'?

lsnovick · Post by **lsnovick** » Mon Feb 20, 2012 11:38 am

It is not doing anything before the job.

That is what is upsetting. Where could it be having an issue?

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 8:57 pm

lsnovick wrote:Attempting to Cleanup after ABORT raised in stage testEMPLoad..BeforeJob

What stage is testEMPLoad? Did you develop this job from scratch or took a copy of existing job? You don't see anything in BeforeJob or JobControl tab of Job Properties?

chulett · Post by **chulett** » Tue Feb 21, 2012 8:00 am

Server job aborts report an active stage, which typically means the transformer but the error could be anywhere. And without the clue from doing a Reset, they can be difficult to track down.

DSXchange

Before job abort with no other messages

Before job abort with no other messages

Re: Before job abort with no other messages