Skip to Content

Time out dump in sap query external program reference

Hi ,

I am getting a time out dump for a query which uses external programe as reference, strangely its dumping after the first selct query itself which is from VBEP table which has only 1800 records for that selection.

I know we can use key fields in where condition, but I am using based on VBELN , lifsp , edatu and bmeng.

Please suggest as this is happening in prod system.

Thanks,

Balu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 11:14 AM

    Hi Krishna,

    Can you share the dump?

    Regards,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 11:14 AM

    Hi,

    How do you know it is dumping in VBEP? TIME_OUT short dump often points to the wrong select statement. Since you are selecting using VBELN , I don't think it is the problem with VBEP. Check out other select statement also.

    R

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 11:35 AM

    Hello Bala,

    my suggestion would be :

    1) create secondary index on vbak based on fields VBELN , lifsp , edatu and bmeng in SE11.

    2) optimize your select query by using basic thing, like dont use select * , dont use into corresponding table of fields etc.


    3) make use of abap trace is possible, to cehck which statement taken how much time (in   micro seconds)


    Regards,

    Hitesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2015 at 11:51 AM

    Hi Bala,

    The maximum time to run any program is defined by parameter rdisp/max_wprun_time. If your program crosses this time then the dump TIME_OUT occurs.

    You can resolve the issue by either increasing the time defined by this parameter or by running your program in the background.

    Thanks,

    Mayur.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 12:02 PM

    Did you (before posting)

    Regards,

    Raymond

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Balakrishna t Krishna

      What are the other selects you are using?

      You said the problem you found out was in Select from VBAK. Can you paste the code for selection from VBAK?

  • Nov 18, 2015 at 03:55 PM

    Hi Bala,

    Implement package size, ok?

    Select vbeln... appending table it_vbak[] package size 1000 where vbeln eq ..."

    Regards

    Add comment
    10|10000 characters needed characters exceeded