topic Re: Dump error in select query in Application Development and Automation Discussions

Dump error in select query

Former Member — Mon, 18 Oct 2010 12:47:27 GMT

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...

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:04:58 GMT

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á

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:09:08 GMT

Your basis guys can help you on this.

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

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:09:40 GMT

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.

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:12:06 GMT

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

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:14:45 GMT

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

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:23:12 GMT

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.

Re: Dump error in select query

Former Member — Mon, 18 Oct 2010 13:37:49 GMT

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