Heap Allocation failed
Posted: Wed Dec 19, 2007 5:11 am
Hi,
One the jobs in production is failing with error : APT_CombinedOperatorController,1: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
The job is simple: DataSet to ODBC without any stage in between. There is no repartioning done by us. It is set to Auto.
I searched on DSX a lot for heap problems. But it did not help till now. We made the prod user limits to unlimited for all options. Still the job is failing with the same error. In the first run we ran it with many other jobs and it failed. In the second run we ran it alone when there was no other job running. Still it failed.
The only possible thing to be tried now is database limits. Or DB user is not a windows user. I think it is just created for DB accesses. So just wondering how can one check DB users limit to see what could be the problem.
If nothing works out, then we are going to add a copy stage (forced = true) and give it try. Will post the results.
Any suggestion by that time are welcome.
One the jobs in production is failing with error : APT_CombinedOperatorController,1: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
The job is simple: DataSet to ODBC without any stage in between. There is no repartioning done by us. It is set to Auto.
I searched on DSX a lot for heap problems. But it did not help till now. We made the prod user limits to unlimited for all options. Still the job is failing with the same error. In the first run we ran it with many other jobs and it failed. In the second run we ran it alone when there was no other job running. Still it failed.
The only possible thing to be tried now is database limits. Or DB user is not a windows user. I think it is just created for DB accesses. So just wondering how can one check DB users limit to see what could be the problem.
If nothing works out, then we are going to add a copy stage (forced = true) and give it try. Will post the results.
Any suggestion by that time are welcome.