Abnormal termination of the jobs

lax · Post by **lax** » Wed Dec 15, 2004 5:53 am

Hi All,
I have to run a job on ascential datastage with around an estimate of 600000 rows of data. The job terminates with warning" Abnormal termination of the job at the stage XXX"
However, when i run this job with giving the "limit " <say limit of 350000> it runs with no issues. Else directly running this job terminates it with warning.

Can anyone help me in troubleshooting this map.

Thanks in Advance
Laxmi

kcbland · Post by **kcbland** » Wed Dec 15, 2004 6:13 am

Tell us what stages are in the job doing what, we have no clue where to begin.

lax · Post by **lax** » Thu Dec 16, 2004 3:46 am

Hi,
This is a smple job with two transformation stages. the first transformer stage eliminates all the empty spaces using "StringSpaces" . The second transformer has three hash file lookups performed. The schema looks something like this:

Source---->Transf Stage---------> Transf stage----------------> Target
.....................[Null handling]-----[ three lookups]

Looking ahead for response from the group
laxmi

chulett · Post by **chulett** » Thu Dec 16, 2004 7:55 am

And "StringSpaces" is what, a custom routine or transform? Can you post the code for that as well?

Which stage is the "XXX" stage that aborts?