topic Re: Time Out error for select statement in Application Development and Automation Discussions

Time Out error for select statement

Former Member — Thu, 08 Nov 2012 14:25:09 GMT

Hi Folks,

OPEN CURSOR WITH HOLD c1 FOR SELECT ordid ordno FROM /1OM/ORDR7MP3100
FOR ALL ENTRIES IN gt_po_details
where ordid = gt_po_details-ordid AND prtid = gt_po_details-prtidto.
DO.

>>>>>>>>>> FETCH NEXT CURSOR c1 INTO TABLE gt_po4 PACKAGE SIZE 10000.

IF SY-SUBRC EQ 0.
     APPEND LINES OF gt_po4 TO gt_po_numbers.
     ELSE.
       EXIT.
    ENDIF.
ENDDO.
   CLOSE CURSOR c1.
ENDIF.

ordid is primary key.i written select statement sequence is same as DB table field sequence.

This select statement is trying to get 200000 records from DB level.

AT fetch statement line its giving time out error.

Please help me to avoid timeout error.

Thanks in advance

Re: Time Out error for select statement

former_member214709 — Fri, 09 Nov 2012 08:36:50 GMT

Dear Srinivas,

You can use the Function Module :

SAPGUI_PROGRESS_INDICATOR

Regards

Dinesh

Re: Time Out error for select statement

volker_borowski2 — Fri, 09 Nov 2012 10:09:25 GMT

Humm,

using a package size of 10000 for a FAE with PK WHERE clause seems useless to me.

Did you do an SQL Trace, to verify how many fetches are executed before the timeout and

what the real statement that is executed against the DB looks like?

Volker