Heap allocation failed.
Moderators: chulett, rschirm, roy
Heap allocation failed.
Any thoughts on below error??
APT_CombinedOperatorController,0: Current heap size: 1,595,049,352 bytes in 66,276,970 blocks
BC_Enterprise_6,0: Failure during execution of operator logic.
ODBC_Enterprise_6,0: Input 0 consumed 1616342 records.
APT_CombinedOperatorController,0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
node_node1: Player 2 terminated unexpectedly.
PT_CombinedOperatorController,1: Current heap size: 1,595,049,328 bytes in 66,276,969 blocks
ODBC_Enterprise_6,1: Failure during execution of operator logic.
APT_CombinedOperatorController,1: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
ode_node2: Player 1 terminated unexpectedly.
Oracle_Enterprise_0,0: Failure during execution of operator logic.
Oracle_Enterprise_0,0: Fatal Error: Unable to allocate communication resources
APT_CombinedOperatorController,0: Current heap size: 1,595,049,352 bytes in 66,276,970 blocks
BC_Enterprise_6,0: Failure during execution of operator logic.
ODBC_Enterprise_6,0: Input 0 consumed 1616342 records.
APT_CombinedOperatorController,0: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
node_node1: Player 2 terminated unexpectedly.
PT_CombinedOperatorController,1: Current heap size: 1,595,049,328 bytes in 66,276,969 blocks
ODBC_Enterprise_6,1: Failure during execution of operator logic.
APT_CombinedOperatorController,1: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed.
ode_node2: Player 1 terminated unexpectedly.
Oracle_Enterprise_0,0: Failure during execution of operator logic.
Oracle_Enterprise_0,0: Fatal Error: Unable to allocate communication resources
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
There is more to it than a DB stage to DB stage. The "Heap" is used when sorting (or repartitioning), so perhaps you could explain a bit more about what you are doing.
Last edited by ArndW on Fri Oct 13, 2006 3:10 pm, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Does that mean Oracle to Oracle with no other stages?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Many lakhs of rows in a single transation? Note from the message that it is coming from the ODBC driver; this means that something relating to the database has run out of memory - probably your enormous transaction.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
I think, may be here problem is pertaining loading the data from one database to other database with out any stage between them. Just, try out this option, Use a Copy stage between these two stages and try out to load the data. Here Copy Stage work as an optimizer. It will provide buffer to hold the rows while datastage is processing rows.
If you do include a copy stage between the two databases to avoid the space issue, please ensure that property Force is set to "True". Else the copy process will be eliminated for optimization purposes.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact: