topic Re: Time out dump in sap query external program reference in Application Development and Automation Discussions

Time out dump in sap query external program reference

bala_krishna007 — Wed, 28 Oct 2015 11:10:44 GMT

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

Re: Time out dump in sap query external program reference

former_member185587 — Wed, 28 Oct 2015 11:14:06 GMT

Hi Krishna,

Can you share the dump?

Regards,

Kiran

Re: Time out dump in sap query external program reference

Former Member — Wed, 28 Oct 2015 11:14:36 GMT

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.

Re: Time out dump in sap query external program reference

bala_krishna007 — Wed, 28 Oct 2015 11:18:17 GMT

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

Re: Time out dump in sap query external program reference

Former Member — Wed, 28 Oct 2015 11:21:09 GMT

Hiya,

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

Re: Time out dump in sap query external program reference

former_member183519 — Wed, 28 Oct 2015 11:35:54 GMT

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

Re: Time out dump in sap query external program reference

Former Member — Wed, 28 Oct 2015 11:51:56 GMT

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.

Re: Time out dump in sap query external program reference

RaymondGiuseppi — Wed, 28 Oct 2015 12:02:12 GMT

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

Re: Time out dump in sap query external program reference

bala_krishna007 — Thu, 29 Oct 2015 10:57:20 GMT

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

Re: Time out dump in sap query external program reference

Former Member — Thu, 29 Oct 2015 11:00:43 GMT

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?

Re: Time out dump in sap query external program reference

roberto_forti — Wed, 18 Nov 2015 15:55:33 GMT

Hi Bala,

Implement package size, ok?

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

Regards

Re: Time out dump in sap query external program reference

Former Member — Wed, 18 Nov 2015 16:13:15 GMT

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

Rob