topic Re: Program going for dump when selecting into an internal table through RFC. in Application Development and Automation Discussions

Program going for dump when selecting into an internal table through RFC.

Former Member — Mon, 08 Dec 2008 05:19:07 GMT

My program is a RFC. I need to select the full table from a RFC in an internal table. The problem is that the db table has huge data and my program is going for a dump ("TSV_TNEW_PAGE_ALLOC_FAILED")

Dump analysis.

No storage space available for extending the internal table.

What happened?

You attempted to extend an internal table, but the required space was

not available.

How to correct the error

The amount of storage space (in bytes) filled at termination time was:

Roll area...................... 2717424

Extended memory (EM)........... 190442616

Assigned memory (HEAP)......... 10004800

Short area..................... " "

Paging area.................... 106496

Maximum address space.......... 4294967295

As you can see that this is a memory allocation problem.

The problem is that BASIS team can no longer increase the memory, so I need to have a walkaround this problem.

I was previously using CALL FUNCTION 'RFC_READ_TABLE' DESTINATION p_dest in the program. But this FM is going for a dump in the program.

I have created a new custom FM in which I have used the packaging property.

SELECT * FROM db_tab

PACKAGE SIZE 10000

APPENDING TABLE i_tab

But this too is not working.

According to the functionality, we need to have SELECT * and need to extract all the records too.

Is there any way where we can put the data into 2 or 3 internal tables from the rfc select.

Any suggestions would be welcome.

Thanks,

Arindam.

Re: Program going for dump when selecting into an internal table through RFC.

Former Member — Mon, 08 Dec 2008 08:32:01 GMT

Arindam,

As increasing the Roll area memory is not an option i'd suggest you modify your select. Split it up into 2 or more selects based on any one primary key field or based on time periods. The records can be processed in the 2-3 internal tables one after the other or if you arrive at a fewer number of records after certain eliminations then combine the tables at that point.

There are a lot of related threads on this topic in this forum. I'm pasting one below for reference

Re: Program going for dump when selecting into an internal table through RFC.

Former Member — Fri, 02 Jan 2009 09:08:22 GMT

If you do not need all the fields in the Db table, Select only required fields in place of Select *

Re: Program going for dump when selecting into an internal table through RFC.

Former Member — Fri, 02 Jan 2009 09:25:45 GMT

Hi,

Are you calling RFC from other SAP system? If so, you can download the Data to App.Server and FTP to the other using Std Program and then read the data from the same.

Hope this helps you

Raj

Re: Program going for dump when selecting into an internal table through RFC.

Former Member — Fri, 02 Jan 2009 11:29:58 GMT


SELECT * FROM db_tab
PACKAGE SIZE 10000
APPENDING TABLE i_tab
But this too is not working.

Read the documentation carefully!

You should use an INTO or an APPENDING with a refresh somewhere.

Otherwise your table grows again, because a packages added!, and performance is even worse!

Siegfried