TSV_TNEW_PAGE_ALLOC_FAILED with BAPI_AR_ACC_GETOPENITEMS

[Former Member]

hi all,

I am using BAPI_AR_ACC_GETOPENITEMS to get open tems, process and update to a Ztable.The structure in the BAPI is having 111 Fields. Of which I am using only 16 fields. I think we cannot restrict the selection of fields only to particular fileds. When I am executing the program with same variant it is giving following runtime errors:

Sometimes TSV_TNEW_PAGE_ALLOC_FAILED ( at Append Lineitems) and sometimes TIME_OUT.

Most of the times I am getting first error.

1)My first question is Why I am getting two errors whrn I execute with same variant?

2)How to avoid TSV_TNEW_PAGE_ALLOC_FAILED

3) How to avoid TIME_OUT error?

I have searched in SDN for TSV_TNEW_PAGE_ALLOC_FAILED. There are many posts but I could not find a solution which supports my requirement?

Can anyone please help.

Regards,

Murthy.

[Former Member]

Hi,

It is becaz of memory problem. Contact your BASIS person.

Regards

[Former Member]

(1) It seems that based on the selection criteria a huge amount of data is selected. Since there are other users in the system as well as other processes running at some point your report just can't grab any more memory because all memory is already used by your report and other users. You get different dumps because of different system resources available.

If the DB is not very busy it returns the results much faster => you run out of memory

If the DB is very busy you reach the limit for an online transaction and get the TIME_OUT dump

(2) Either BASIS need to add more memory to the application server you report is running on or you need to restrict the selection by running two or three smaller sets rather than one big one

(3) Just schedule the job in bacjground, there is no time out limit for background jobs - However if the results are represented in an ALV grid or other user interaction is necessary this option doens't work.

Hope that helps,

Michael

[Former Member]

Hi Michael,

I scheduled the job in the background, but still it is giving the memory error TSV_TNEW_PAGE_ALLOC_FAILED. I can't change the functionality, please

help me.

Regards,

Ch.Murthy.

[Former Member]

If you can't change the selection criteria, here is what else you might want to try:

(1) If you haven't already done so check if there are any SAP notes adressing this issue.

(2) Get Basis to add more memory

(3) Schedule the job during the night when no other jobs are running

(4) Choose an application server with no users on it when you run it

(5) Analyze your coding and check if you can minimize the memory use before and after you call the BAPI (e.g. free internal tables you are no longer using etc.

(6) Double check that the data you pass into the BAPI is restrictive enough

(7) If all that doesn't help and the dump is clearly caused by the BAPI (not your Z-Code) you should think about raising an OSS

Hope that helps,

Michael