topic Re: Getting Dump during execute Program in Application Development and Automation Discussions

Getting Dump during execute Program

Former Member — Mon, 29 Mar 2010 06:48:23 GMT

Hi All,

I'm getting Dump error while executing program. Just do let me know if any error in given below query:-

SELECT a_{bukrs a}belnr a_{hkont a}xref2 a_{shkzg a}wrbtr a_{gsber a}zfbdt a~zterm

a_{mwskz a}sgtxt a_{xref1 a}gjahr a_{buzei b}kunnr b_{werks b}menge b_{meins b}matnr b~koart

INTO CORRESPONDING FIELDS OF TABLE it_bsid FROM ( bsid AS a INNER JOIN acctit AS b ON a_{bukrs EQ b}bukrs )

FOR ALL ENTRIES IN it_bkpf

WHERE

a~belnr EQ it_bkpf-belnr

AND a~gjahr EQ it_bkpf-gjahr

AND a~bukrs EQ it_bkpf-bukrs

AND a~gsber IN so_bus.

Thanks.

Devinder

Re: Getting Dump during execute Program

rainer_hbenthal — Mon, 29 Mar 2010 06:54:37 GMT

So, you're getting a dump and you are asking here giving exactly no informnation? Sorry, my glas sphere is out for cleaning.

Re: Getting Dump during execute Program

VivekG — Mon, 29 Mar 2010 07:13:11 GMT

Hi,

Please goto ST22 and give us the dump analysis so that we can exactly tell u whats the error in this query.

Vivek

Re: Getting Dump during execute Program

Former Member — Mon, 29 Mar 2010 07:39:24 GMT

Could you tell what error u got?

Thanks & Regards

Surender Kumar.S

Re: Getting Dump during execute Program

Former Member — Tue, 30 Mar 2010 11:19:27 GMT

Hi,

How exactly I can get dump analysis in ST22?

Thanks

Devinder

Re: Getting Dump during execute Program

Former Member — Tue, 30 Mar 2010 11:38:27 GMT

Hi,

Goto ST22, press start button which will give all the dumps created by you today and select the one which you need to analyse.

There you will find the analysis and the code part which created the dump.

Regards,

Gopal

Re: Getting Dump during execute Program

Former Member — Wed, 31 Mar 2010 07:11:03 GMT

Hi all,

Dump is given below, while execute the select query : -

Error analysis

When the program was running, it was established that more

memory was needed than the operating system is able to provide savely.

To avoid a system crash, you must prevent this

situation.

Last error logged in SAP kernel

Component............ "EM"

Place................ "SAP-Server Development_DVL_01 on host Development (wp

1)"

Version.............. 37

Error code........... 7

Error text........... "Warning: EM-Memory exhausted: Workprocess gets PRIV "

Description.......... " "

System call.......... " "

Module............... "emxx.c"

Line................. 1886

Thanks

Devinder

Re: Getting Dump during execute Program

SuhaSaha — Wed, 31 Mar 2010 07:16:38 GMT

Hello Devinder,

Clearly the reason for this dump is the number of records in the target internal table IT_BSID is too large.

I can see you are using FOR ALL ENTRIES to select the data. Make sure your check IT_BKPF[] is not initial before the select.

BR,

Suhas

Re: Getting Dump during execute Program

Former Member — Wed, 31 Mar 2010 07:21:48 GMT

Hi,

Try to avoid INNER JOIN by using two SELECTs + FOR ALL ENTRIES

Re: Getting Dump during execute Program

Former Member — Wed, 31 Mar 2010 08:43:27 GMT

Hi Tomislav Uroic,

How can I write 2 Select queries with "For all entries".

Thanks

Devinder

Re: Getting Dump during execute Program

Former Member — Wed, 31 Mar 2010 10:04:06 GMT

Hi Saha,

Yes, I have mentioned "Is not Initial" in the IF Condition.. Give me another reason for the same.

Thanks

Devinder

Re: Getting Dump during execute Program

rainer_hbenthal — Wed, 31 Mar 2010 10:15:09 GMT

The reason is well known: you're still retrieving too much data to fit in memory. ZThis cant be changed by replacing join with FAE.

If possible you can deal with the data row by row not reading the whole data into an internal table.Otherwise you are lost.

Re: Getting Dump during execute Program

Former Member — Wed, 31 Mar 2010 10:30:05 GMT

Hi,

I've already used Loop At in my code.. for fetching data row by row.

give another solution

Thanks

Devinder

Re: Getting Dump during execute Program

rainer_hbenthal — Wed, 31 Mar 2010 11:16:55 GMT

You do not understand. If you are using loop at your whole data is stored into application servers main memory und you're getting the error message above.

Do not read the whole data into an internal table, fetch the data row by row using select.... end-select. If you cant do that, limit your result set by being more specfic in the where clause.