Throwing exception: APT_BadAlloc: Heap allocation failed.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Throwing exception: APT_BadAlloc: Heap allocation failed.

Post by Naren12345babu »

ETL job is using ODBC stage to extract .DBF file.

I am getting below error

Throwing exception: APT_BadAlloc: Heap allocation failed.

I tried checking other threads , but did not get much help

Please help here.
Thanks
Naren Babu Ch
mouthou
Participant
Posts: 208
Joined: Sun Jul 04, 2004 11:57 pm

Re: Throwing exception: APT_BadAlloc: Heap allocation failed

Post by mouthou »

Heap allocation is a generic error related to buffering and memory allocation. Not much direct answer for this error as the job needs to be completely checked. But to begin with, are you getting this issue when using ODBC stage only? Can you try replacing it with some other stage as source and check for now? It helps to isolate the insufficient DB settings interrupting with DS operations.

Since you seem to be extracting a database file, volume of records fetched is also in question. Can you give a simple pic of job design to see how big the job is?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How wide are the rows? There are default maxima that can be overridden with parameters MAXFETCHBUFF and MAXFETCHCOLS in the uvodbc.config file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Re: Throwing exception: APT_BadAlloc: Heap allocation failed

Post by Naren12345babu »

What are the other stages I can use to extract data from DBT files.
Also, I checked for number of bytes per block size, and i got "ODBC_Connector_0,0: Current heap size: 6071520 bytes in 19603 blocks".

Hope this is help ful.

Any idea how to move furhter? what are the other stages that can be used to extract DBT files.
Thanks
Naren Babu Ch
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Post by Naren12345babu »

Ray, I cannot use uvodbc.config as the configuration seems to be very different where I am working , all values from uvodbc are not present in odbc. Infact when I check uvodbc file, I see only one ODBC connection. but could not get an update.

I also see that columns with ntext are causing this issue.

are there any environment variables that can be used here.
Thanks
Naren Babu Ch
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Post by Naren12345babu »

Ray, can you provide me syntax of using these paramters in uvodbc.config
Thanks
Naren Babu Ch
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

Post by Naren12345babu »

the datatypes is ntext
Thanks
Naren Babu Ch
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You're not the first person here wondering about things like that.

Suggestion: take one of those values like MAXFETCHBUFF and use it in an exact search here, then go through the results. Right now that one finds 37 other posts that include it. I would start with the resolved ones first but people don't always mark their topics so don't restrict yourself to just those.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply