For all enteries - short dump

[Former Member]

Hi,

I am querying on BKPF table by using for all enteries. In dev system, it's working fine, but when i have transported it to QAS, it's giving me the short dump when for all enteries internal table is empty.

But I have checked the same scenario in dev, it's not giving me the short dump, even if for all enteries table is empty. The short dump is 'STORAGE_PARAMETERS_WRONG_SET' & INCLUDE INCL_INSTALLATION_ERROR. Its looks like a memory problem. For reference, in dev bkpf has records in thousands, but in qas it's' more than million. Can this be the reason. How to fix it? I know i can put a validation on this query when it's initial, but any other solution. Or what is the cause of this error.

2- Tell me one more thing, if for all enteries table is empty, then do it scan all the rows of bkpf table one by one?

Edited by: Sal Khan on Dec 27, 2007 6:01 PM

[former_member156446]

its always mandatory to check for initial of for all entires table..

if its not hitting dump in dev.. its okay... do check for initial or in else statement put exit.

if the table is initial all the entires will be hit and which results in inconsistent data.

[Former Member]

Hi,

If you are using for all entries it is compulsory to check whether that itab is initial or not. If it is initial generally you have to terminate the program, otherwise it will try get all the data from BKPF table, as you know BKPF table is very big.

Thanks,

Sriram Ponna.

[Former Member]

Hi

It's best practice to test for all entries table is not empty then use the select command. otherwise it will try to get all the information from d/b table, if it crosses 2gb data, then it will go for shortdump.

In your dev system, you will not have huge data, so it is working fine. But it will create mess if you transport to Quality/prd

So you have to check that

-Pavan

[Former Member]

Always you have check the internal table values before writing using it in the for all entries ( If not itab[] is initial), Also use Sort and Delete Adjacent duplicates statements based on the key before using that itab in the for all entries.

If the itab is empty then it selects all the values from the BKPF table which may be having more data in Quality system that is why you are getting the dump.

Thanks,

Srinivas