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
Abnormal termination of stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE