Throwing exception: APT_BadAlloc: Heap allocation failed.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
Throwing exception: APT_BadAlloc: Heap allocation failed.
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.
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
Naren Babu Ch
Re: Throwing exception: APT_BadAlloc: Heap allocation failed
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?
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?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
Re: Throwing exception: APT_BadAlloc: Heap allocation failed
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.
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
Naren Babu Ch
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
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.
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
Naren Babu Ch
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
-
- Premium Member
- Posts: 76
- Joined: Wed Jan 06, 2016 9:40 am
- Location: Bangalore
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.
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
"You can never have too many knives" -- Logan Nine Fingers