Hi,
When i try to run a sequence job i am getting ABORT message. i tried importing table definitions, i tried running a job within the sequence individually, but still the error persists.
Thanks in advance,
Vindy
getting Abort error
Moderators: chulett, rschirm, roy
Hello Vindy,
a sequence job usually aborts when one of the jobs or other entities that it calls aborts. You said that you called the jobs within the sequnce individually - did they all run with no errors or warnings?
What is the exact error message that your sequence aborts with? This almost always will contain the cause of the problem or the job that failed.
a sequence job usually aborts when one of the jobs or other entities that it calls aborts. You said that you called the jobs within the sequnce individually - did they all run with no errors or warnings?
What is the exact error message that your sequence aborts with? This almost always will contain the cause of the problem or the job that failed.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
All that tells you is the fact that it tried to run a job called SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM and that job aborted. The next step is to go to the job it tried to run and look at its job log to find out why. What does it say in there?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Well, you are connect to an instance, that's for sure. So, you either connected to the wrong instance, you've spelled the table name incorrectly, you are connecting as someone who doesn't own the table and you haven't specified the owner or you've just plain old specified the owner of the table incorrectly or you've done all that correctly and the user you are connecting as doesn't have select permissions on the table.
Work your way through those and see.
Work your way through those and see.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
What was the log when it got aborted while called from Sequence. When you run in the designer, there may change where you might passed the paramtere values wrongly, where sequence might pass the correct value. And original cause might be different from what you are looking into right now.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'