Heap allocation error - ODBC stage
Posted: Thu Oct 20, 2011 3:18 am
Hi
One of our parallel jobs fetches data from Oracle 10g and inserts into a SQL server table. The job design is as follows:
Oracle Enterprise > Transformer > ODBC Enterprise
The job nees to fetch and populate approx 20 million records. The job is failing due to the following error.
odbcwrt_EX_POST_RESULTS,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed.
I have searched the forum for similar kind of errors and have applied some of the suggestions on the ODBC stage as following:
I have set the APT_DISABLE_COMBINATION to true.
1) Set Insert array size to a low value - I set it to 10 still the job fails
2) Set insert array size to 1 and set the row commit interval to a positive integer - I set array size to 1 and commit interval from 10, 1000, 2000 and 50,000. Still the job fails on all occasions.
3) I have also tried to set the execution mode to sequential. But to no sucecess.
Could you please let me know how can I proceed to find out the reason and resolve the issue?
Regards
Rohit
One of our parallel jobs fetches data from Oracle 10g and inserts into a SQL server table. The job design is as follows:
Oracle Enterprise > Transformer > ODBC Enterprise
The job nees to fetch and populate approx 20 million records. The job is failing due to the following error.
odbcwrt_EX_POST_RESULTS,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed.
I have searched the forum for similar kind of errors and have applied some of the suggestions on the ODBC stage as following:
I have set the APT_DISABLE_COMBINATION to true.
1) Set Insert array size to a low value - I set it to 10 still the job fails
2) Set insert array size to 1 and set the row commit interval to a positive integer - I set array size to 1 and commit interval from 10, 1000, 2000 and 50,000. Still the job fails on all occasions.
3) I have also tried to set the execution mode to sequential. But to no sucecess.
Could you please let me know how can I proceed to find out the reason and resolve the issue?
Regards
Rohit