Skip to Content

ALV report getting dump in Production server

Hi All,

My ALV report runs perfectly in development server. But gets dump in Production server. I am taking data from tables S120 and S003 and so on. But not getting why this report getting dump in production server. If I remove the data taken from table S003, then the report runs well. Here is a piece of code of my program. Please help me.

SELECT sptag
         werks
         matnr
         vrkme
         vkmng
         umsgvp
         umsgvo
        umsgeo_01
    INTO CORRESPONDING FIELDS OF TABLE t_s120
    FROM s120 
    WHERE werks IN s_werks
    AND   matnr IN s_matnr
    AND   sptag IN s_sptag.

  IF t_s120[] IS NOT INITIAL.
    SELECT matnr
         umkzwi1
         INTO CORRESPONDING FIELDS OF TABLE t_s003
        FROM s003
        FOR ALL ENTRIES IN t_s120
        WHERE matnr = t_s120-matnr.
       ENDIF.
     DELETE ADJACENT DUPLICATES FROM t_s003.
LOOP AT t_s120 INTO w_s120.
    MOVE-CORRESPONDING w_s120 TO w_final.
    READ TABLE t_s003 INTO w_s003 WITH KEY matnr = w_s120-matnr.
    IF sy-subrc EQ 0.
    w_final-umkzwi1 = w_s003-umkzwi1.
    ENDIF.

endloop.

With regards,

Tripod.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 22, 2011 at 10:58 AM

    Hi,

    Could you please tell what the dump says.

    Add a comment
    10|10000 characters needed characters exceeded

    • > The dump is showing - " No roll storage space of length 2046992 available for internal storage."

      This means that the ABAP runtime environment is not able to find a contiguous memory of length 2046992(bytes?) in the roll area(internal session in which the program is loaded)

      If I remove the data taken from table S003, then the report runs well.

      You need to check if you can restrict you select on S030 by adding additional filters in the WHERE clause.

      If this is not possible check if you can release the memory allocated to some of the resources viz., variables, internal tables object references etc., used by the program when the select on S030 is made!

      BR,

      Suhas

  • Posted on Jun 22, 2011 at 11:26 AM

    There are often many more records in production than in development server. If you cannot restrict programmatically the volume of data to be stored (*), check with basis team if they can change the following parameters :

    - [em/initial_size_MB: Extended Memory Pool Size|http://help.sap.com/saphelp_nw70/helpdata/en/02/9626e7538111d1891b0000e8322f96/frameset.htm]

    - [ztta/roll_area: Roll Area|http://help.sap.com/saphelp_nw70/helpdata/en/02/96274f538111d1891b0000e8322f96/frameset.htm]|http://help.sap.com/saphelp_nw70/helpdata/en/02/96274f538111d1891b0000e8322f96/frameset.htm]

    - [ztta/roll_extension: Extended Memory Limit |http://help.sap.com/saphelp_nw70/helpdata/en/02/9626b3538111d1891b0000e8322f96/frameset.htm]

    - [ztta/roll_extension_dia: EM Quota for Dialog Processes|http://help.sap.com/saphelp_nw70/helpdata/en/4b/95242c6a5a46fe9aac980b1248cb2a/frameset.htm]

    - [ztta/roll_extension_nondia: EM Quota for Non-Dialog Work Processes|http://help.sap.com/saphelp_nw70/helpdata/en/dd/d0256805734b8b849c14c9cb33a266/frameset.htm]

    During execution use transaction SM04 (menu goto memory) or ST02 to check memory usage.

    Regards,

    Raymond

    (*) only declare useful fields in internal tables, free memory as soon it is no longer required, dont duplicate data (work itab and final itab), etc.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 22, 2011 at 11:33 AM

    Hi.,

    As suggested Free some unused memory used for variables, also check above parameters with basis team.,

    reg your code: before DELETE ADJACENT DUPLICATES FROM t_s003.

    sort t_s003 by key field.

    hope this helps u.,

    Thanks & Regards,

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 22, 2011 at 11:38 AM

    Hi tripod,

    to save memory, you do not need table t_s120. Select into t_fiinal, loop at t_final. You do not need both tables.

    To speed up performance, you should sort t_s003 and read it BINARY SEARCH. You can also LOOP AT ... ASSIGNING <field-symbol>.

    Regards,

    Clemens

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Tripod.

      You can run report in background. When you press F9, you get to the "Background Print parameter" screen.

      Here uncheck "Delete after Print" option and set print parameters accordingly. Imean "Time of printing" in General properties. Change it to "Send to SAP spooler for Now".

      I think this will solve ur problem if your report has some output. List will be there in spool. So, when you select Job and click on spool, you will be able to see list output.

      Regards,

      Vishram

  • Posted on Jun 27, 2011 at 07:54 AM

    I guess the background job will not work. In either way it goes for a dump due to memory issue. try to change the select statement.

    use PACKAGE SIZE.

    SELECT fields..... FROM tablebame...

    INTO TABLE it_in PACKAGE SIZE 200.

    package size number can be any number, depends how many records can internal table or your select takes

    Edited by: ssm on Jun 27, 2011 1:25 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Tripod,

      after the first select, issue COMMIT WORK statement. This resets the timeout counter. Probably you may get it through.

      You can run an ALV report without trouble in background,. it will create a list in the spool, but you should set a default layout before.

      If you got an empty spool, check the run time. Make sure the report can find data to display. Try to run SE16 in grid mode using F9 in background.

      Regards,

      Clemens

  • Posted on Jul 01, 2011 at 05:55 AM

    Hi,

    This seems to be an issue with memory assignment. You should talk to your Basis team.

    Also check if you can resrtict the no of records being fetched from S003.

    And if you are fetching only 2 fields from S003, then try removing into corresponding fields and declare an internal table with the req. fields alone.

    Suzie

    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.