Getting Dump during execute Program

[Former Member]

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

[rainer_hbenthal]

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

[VivekG]

Hi,

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

Vivek

[Former Member]

Hi,

How exactly I can get dump analysis in ST22?

Thanks

Devinder

[Former Member]

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

[Former Member]

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

[SuhaSaha]

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

[Former Member]

Hi Saha,

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

Thanks

Devinder

[rainer_hbenthal]

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.

[Former Member]

Hi,

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

give another solution

Thanks

Devinder

[rainer_hbenthal]

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.

[Former Member]

hi

Could you tell what error u got?

Thanks & Regards

Surender Kumar.S

[Former Member]

Hi,

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

[Former Member]

Hi Tomislav Uroic,

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

Thanks

Devinder