Skip to Content
author's profile photo Former Member
Former Member

For all enteries - short dump

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 27, 2007 at 05:02 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2007 at 05:06 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 27, 2007 at 05:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2007 at 05:18 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.