Abnormal termination of stage

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
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Abnormal termination of stage

Post by Nagin »

I have a job failing with the Abnormal termination error. Below is the log entry I got from resetting the job. I understand that the memory is the issue, but I have increased the buffer size in Inter processup to 1024 and time out to 30 sec and still getting the same error. Its a pretty big table, it has about 250 columns. Is there any other setting I can modify to avoid this error.

From previous run
DataStage Job 2693 Phantom 24736
kgefec: fatal error 0
OCI-21503: program terminated by fatal error
OCI-04030: out of process memory when trying to allocate 7840 bytes (Alloc statemen,pref col alloc)
Errors in file :
OCI-21503: program terminated by fatal error
OCI-04030: out of process memory when trying to allocate 7840 bytes (Alloc statemen,pref col alloc)


Thanks alot for your help
I_Server_Whale
Premium Member
Premium Member
Posts: 1255
Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America

Post by I_Server_Whale »

Did you try searching? Check this POST
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Post Reply