Time out dump in sap query external program reference

[bala_krishna007]

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

[former_member185587]

Hi Krishna,

Can you share the dump?

Regards,

Kiran

[Former Member]

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

[bala_krishna007]

Hi Rudra,

Thanks for your reply , I am saying this is dumping at VBEP table because the first select is on VBEP table and after that its fectching data from VBAK table where its giving dump.

Thanks,

Balu

[Former Member]

Hiya,

There you go. Paste the codeof the select clause from VBAK.

R

[former_member183519]

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

[Former Member]

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.

[raymond_giuseppi]

Did you (before posting)

• Execute a SQL trace (ST01) to analyze access plan
• Read the reference note for SD (185530 - Performance: Customer developments in SD)

Regards,

Raymond

[bala_krishna007]

Yes I did run a trace before posting and there was no query taking more time.

[Former Member]

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?

[roberto_forti]

Hi Bala,

Implement package size, ok?

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

Regards

[Former Member]

If it were a memory issue, PACKAGE SIZE might help, but not for a timeout.

Rob