topic Re: ABAP Time Out Dump in Application Development and Automation Discussions

ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 17:30:19 GMT

Hi Everybody,

I am getting time_out dump for this query.

SELECT opbel

augbl

hvorg

tvorg

APPENDING TABLE t_dfkkop_temp

PACKAGE SIZE c_package

FROM dfkkop

FOR ALL ENTRIES IN p_it_dfkkcr

WHERE augbl EQ p_it_dfkkcr-doc1r(12)

AND xragl EQ space.

ENDSELECT.

There is a index on AUGBL field and query is using index as well. Also p_it_dfkkcr is sorted. p_it_dfkkcr has approx 5000 records and package size is 1000.

Expected records are around 6000 and DFKKOP table is in GB's.

Also I tried INTO TABLE but its not working. Any idea how can I avoid time_out dump.

Also If i am using package size, does it completes one DB LUW or SAP LUW. I mean for every packet selection it will complete DB LUW then goes to DBase again. This should avaoid dump. Any idea about this as well.

Thanks for any help.

Re: ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 17:43:29 GMT

Have you tried running it in batch?

Rob

Re: ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 17:49:29 GMT

I cant run this batch

Re: ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 17:56:38 GMT

This table doesn't exist in our system, so it's hard to tell exactly what the problem is. You say AUGBL is a field in a key. Is it the first field? Are there other fields in the key before it?

If not, you may just have to select and process less data and run it multiple times.

Rob

Re: ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 18:56:30 GMT

Hi Durgesh.

A couple of questions...

- Why are you using SELECT ENDSELECT statement?

- Wouldn't it work if you use INTO TABLE instead of APPENDING TABLE?

I would do it this way...

IF NOT p_it_dfkkcr[] IS INITIAL.

SELECT opbel augbl hvorg tvorg

FROM dfkkop

INTO TABLE t_dfkkop_temp

FOR ALL ENTRIES IN p_it_dfkkcr

WHERE augbl EQ p_it_dfkkcr-doc1r(12)

AND xragl EQ space.

ENDIF.

Thanx.

Jesus

Re: ABAP Time Out Dump

Former Member — Thu, 10 Aug 2006 19:16:17 GMT

Yes - using packets won't decrease execution time. It saves memory not time.

Rob