Dump error in select query

[Former Member]

Hey Gurus,

i am working on a requirement in which select query is fetching 8 fields from a ZTABLE.

IF NOT IT_ZQAPP1[] IS INITIAL.

SELECT AUFNR VORNR PROBNR PIPENO NVORNR SHIFT

PSTAT PRODAT FROM ZQAPP INTO CORRESPONDING FIELDS OF TABLE IT_ZQAPP_B

FOR ALL ENTRIES IN IT_ZQAPP1

WHERE AUFNR = IT_ZQAPP1-AUFNR

AND WERKS IN P_WERKS

AND PRODAT LE P_PRODAT.

it works fine for lesser data but throws a dump error TSV_TNEW_PAGE_ALLOC_FAILED for entries more than 70000,

and my requirement is to fetch more than a lac record.

Kindly Suggest the corrections.

Thanks in Advance...

[Former Member]

Hi!

This error occurs typically, when there is no more memory for your ABAP session. This means, you have to do one of the followings:

- restrict your report for smaller intervals, like process only 1 month instead of 6 months together

- rewrite your program, and eliminate/refresh/free the unneccesary internal tables, or columns from internal tables. You might even try to remove unneccesary lines from internal tables

- use SELECT - ENDSELECT instead of SELECT ... INTO statement. This could slower your program, but you'll need less memory usage

Check your memory usage always, with SM04 transaction (Goto - Memory menu).

Regards

Tamá

[Former Member]

Your basis guys can help you on this.

Report this problem to basis guys. They will increase the size of memory.

[Former Member]

It's also possible to use SELECT ENDSELECT with PACKAGE SIZE. When a package size is reached then you can append it to another table to build up a big internal table.

[Former Member]

Hi,

What are the lenght of your field? The sum of total lengths are big?

In the dump, what are the memory that the program try to use ? (and cause TSV_TNEW_PAGE_ALLOC_FAILED)

This problem has a workaround: say to the basis to allow more memory to the process...

Best regards,

Leandro Mengue

[Former Member]

Hi,

In situations like this we need to package size or upto size in the select query.

for syntax and all you can check the SAP documentation

Thanks,

Vinayaka

[Former Member]

Our experience is that, with our particular OS and DBMS, each FAEI hit consumes a bit of SAP memory...in our case, FAEI is only ten rows at a time since we're on DB2, and a few million rows translates to a few hundred thousand round trips with FAEI and a few hundred thousand small bits of memory consumed. Therefore, we see abends citing TSV_TNEW_PAGE_ALLOC_FAILED with FAEI that don't occur when we simply read the entire table and reprocess to eliminate what we didn't need.

Also, if you have other large internal tables that are no longer needed, issue a FREE <itabname> command as soon as no longer needed to reclaim that SAP memory when working with very large sets or subsets.

[Former Member]

Moderator message - Please do not ask or answer basic questions or questions that are easily searchable - thread locked Rob