Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Time out Error

Dear All,

I use the parallel way to get data from two large table. the SQL is below:

CALL FUNCTION 'ZIMMA011'

STARTING NEW TASK l_taskname

DESTINATION IN GROUP l_srv_grp

PERFORMING return_back_this_task

ON END OF TASK

TABLES

it_in = lt_component

it_plant = gs_werks

it_storl = gs_lgort

it_bwart1 = s_bwart1

it_bwart2 = s_bwart2

it_date = lt_date.

In function ZIMMA011 the code is :

SELECT msegmblnr msegzeile mkpfbudat mkpfcpudt mkpfcputm msegmatnr

msegmenge msegmeins mseg~shkzg

msegwerks mseglgort

mseg~bwart

FROM mkpf JOIN mseg

ON mkpfmblnr = msegmblnr

INTO CORRESPONDING FIELDS OF TABLE it_out

FOR ALL ENTRIES IN it_in

WHERE matnr = it_in-matnr

AND werks IN it_plant

AND lgort IN it_lgort

AND ( bwart IN it_bwart1 OR bwart IN it_bwart2 )

AND cpudt IN it_date.

the inner table has 2000 records, when I run foreground it is OK, but short dump with CALL_FUNCTION_REMOTE_ERROR result from Time limit exceeded.

The error point:

1449 *&RECEIVE RESULTS FROM aRFC calls

1450 REFRESH lt_mseg.

===== RECEIVE RESULTS FROM FUNCTION 'ZIMMA011'

1452 TABLES

1453 it_out = lt_mseg.

1454

1455 IF l_taskname <> 'TASK'.

1456 g_running = g_running - 1.

1457 ENDIF.

Edited by: zheng michael on Apr 8, 2010 2:30 AM

Edited by: Rob Burbank on Apr 8, 2010 9:08 AM

Former Member
Not what you were looking for? View more on this topic or Ask a question