Heap allocation failed

Sakthi_Sst · Post by **Sakthi_Sst** » Thu Dec 21, 2006 12:34 am

Hi All,

My issue would be "Heap allocation failed" when running around 505 million data.
1.I have a 8 node system datastage server
2.Source is Teradata in Datastage 7.5.1PX.
3.Reading from a Teradata Enterprise stage.
4.It reads upto 260 million records and then job aborts with an error "Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed." iam using SessionsPerPlayer=2,RequestedSessions=8 in the DB options in teradata stage.
The data is not passing the read stage.

My Question,

1.what is the maximum number of SessionsPerPlayer and RequestedSessions for 1 node that can be specified?
2.what is the maximum number of SessionsPerPlayer and RequestedSessions i need to specify in my case?
2.Any workarounds for this error?
3.Any websites where i can get more information about Sessions per players.

Thanks and Regards,
Sakthivel T

keshav0307 · Post by **keshav0307** » Thu Dec 21, 2006 6:45 am

try some search, many people got this error viewtopic.php?t=104344&postdays=0&posto ... on&start=0

RequestedSessions =number of nodes * SessionsPerPlayer[/url][/code]

Sakthi_Sst · Post by **Sakthi_Sst** » Thu Dec 21, 2006 7:09 am

Hi,

I got the calculation but im not sure how many sessions per player i can specify for a node.

RequestedSessions =number of nodes * SessionsPerPlayer

RequestedSessions =1 * SessionsPerPlayer(?) //for 1 node

Thanks,
Sakthi...

keshav0307 · Post by **keshav0307** » Thu Dec 21, 2006 7:17 am

it will depend on the type of stages you have in your job.
if you have many Teradata enterprise stages, then you should consider about the number of FAST LOAD/FAST export you can run on your teradat server....
eg. if you have 4 TEE stages and your condiguration file has 8 nodes with 2 sessionsperplayer, then it will actually invoke 64 FAST load/FAST EXPORT sessions on teradata..