low memory issue

[Former Member]

Hi

We have an interface through which we upload employee attendence data daily after 5 in the evening. If i load data of 1000 employees the interface runs well where as if i run this for 2000 or above the system gets hanged and message says low memory. I checked the system log in SM21 it says TSV_TNEW_PAGE_ALLOC_FAILED.

I have checked everything the heap size area issue (which is coming in ABAP Dump) is already 2gb which is maximum they can allot in extended memory in SAP .

All the memory parameter they have put it to maximum but still the abap dump of heap size area is coming .Our basis guys are telling us to tune sql statement or internal table which is there in programe , as programme is running fine when it has to display 1000 records only it throws error when the same programme run for 5000 records .

One more thing i would like to add on this interface was running fine till Aug 2007 after that this issue has come up.

This is Urgent, Pl help.

Regards,

Quavi.

[former_member256615]

Hi,

can I know the database level of your system..... ?

Thanks

Naren

[Former Member]

Oracle 9i we have and the reason we think for problem is that we are fatching 5000 records in a sigle report if this the cause plz give some solution to overcome this

[former_member433984]

6.40 , 7.00?

do you have /3GB option activated (SAP notes 110172, 546361) in boot.ini?

[Former Member]

we have 6.20

and we have /3GB option activated. we are fetching some 5000 records, in a single report can this cause memory issue. if this is correct pl give me some work around.

Regards,

Quavi.

[former_member433984]

the problem is that the number of records you fetch does not fit into the virtual address space of the work process:

possible solutions:

- modify your transaction to run in several iterations and process limited number of records in one iteration

- install additional 64-bit dialog instance and let the transaction run there