TSV_TNEW_PAGE_ALLOC_FAILED error while loading the DATA using DTP

[Former Member]

Hi,

While loading the data using DTP for 2 DSO's we are gettig the error

TSV_TNEW_PAGE_ALLOC_FAILED

can any one kindly help me out regarding the same.

Thank You,

Poornima.

[Former Member]

Hi Poornima,

This could be because,

You are running short of memory during the running of the program. In me experience this is donw to 1 of 2 things:

1. You have internal tables which are massive (too big !!! ). Reduce the size by gathering data from teh database in packets.

2. You are using the sql statement ' select' and use a range table in the select statement that is too big. The database cannot handle unlimited amounts of data in internal tables used with the ' where xyz in s_range_table'.

Regards,

Soundarya.

[Former Member]

Hi Soundarya,

Thanks a lot for the reply. But i found that its running fine in development, where as coming to quality its throwing an error. These happened for Two DSO's. In both the transformations i have identified that the Transformation names are different from Development and Quality..

There are no routines written for them and no select statements have been used

Can you please suggest me regarding the same.

Edited by: Poornima Gayatri on Mar 22, 2010 7:00 AM

[Former Member]

Hi All,

Thanks a lot for the replies. The problem is sovled.

Poornima.

[Former Member]

Hi Poornima,

Can you please elaborate on how you resolved this issue. I am getting the same issue. I appreciate it.

Thanks,

Al