Run time error In TCODE FAGLL03

[Former Member]

Hi Expert,

when I execute the code FAGLL03 with these single input ( GL Account, Company Code, Profit center ). after 20 and 25 mintue it went into run time error. What is the error in run time analysis is below mention.

Program Name: SAPLFAGL_ITEMS_SELECT

Trigger Location of run time error.

program: SAPLFAGL_ITMES_SELECT

Include: LFAGL_ITMES_SELECTU07

row: 329

Module Type : (FUNCTION)

Module Name: FAGL_GET_ITMES_BSAS

DESCRIBE TABLE < it_itab_data> LINES LD_FAGLPOSE_LINES.

if LD_FAGLPOSE_LINES gt 0.

perform complete_data changing

lT_FAGLPOSE[].

APPEND LINES OF lT_FAGLPOSE TO C_T_FAGLPOSE.

ENDIF.

ELSE

ASSIGN: lr_tab_data->* to <lr_tab_data>

lr_struc_data ->* to <ls_struc_data>

refresh <lt_tab_data>

328 line

=== FETCH NEXT CURSOR I_CURSOR

APPENDING CORRESPONDING FIELDS OF TABLE <lt_tab_data>

PACKAGE SIGE id_MAXIMUM_LINES

DELTA_DBCNT = SY-DBCNT - OLD_DBCNT.

OLD_DBCNT = SY-DBCNT.

DESCRIBE TABLE < it_itab_data> LINES LD_FAGLPOSE_LINES.

if LINES LD_FAGLPOSE_LINES gt 0.

if i_read _bseg is initial.

perform convert _data using

<lt_tab_data>

Ir_struc_flexa

Ir_struc_table1

lr_struc_data

lr_tab_data

changing

lt_FAGLPOSE[].

refresh <lt_tab_data> " 987950

please tell me hoe can i resolve this problem so that when we run this tcode it will not go in run time error.

Thanks.

Edited by: Rob Burbank on Jul 19, 2010 2:54 PM

[Former Member]

This is a standard SAP program. Have you looked for notes??

There seem to be some that may help.

Rob

[ravi_lanjewar]

Hi,

After featching data 20-25 minutes, There is unexpected situation happending in program while executing. Pl. Check for notes.

[former_member204746]

Hi,

we have the same exact issue.

I looked for notes but could not find anything new.

subh12 (or anyone else), can you supply solution for this?

[raymond_giuseppi]

Is there any SQL error message in SM21 System Log ?

Regards,

Raymond

[former_member204746]

Hi Raymond,

no, we have no SQL errors in SM21. we only get a TIME_OUT standard SM21 entries:

FAGLL03 AB 0 Run-time error "TIME_OUT" occurred

FAGLL03 AB 1 > Short dump "110208 123352 v372 PRD00 " generated

Note that this program times out at exactly the same pace as the original poster stated. problem looks to be identical.

We are presently using SAP ECC 7.01 (EHP4) with Basis SP 7.01 SPS5.

[Former Member]

Hi Eric,

Since the runtime is caused by a time-out, did you investigate if the following notes is applicable?

[Note 1135916 - Line items: Help for analysis for long runtime|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1135916]

This note outlines on how to analyze this transaction and its course of action.

Kind regards,

Robert

[former_member204746]

Thanks Robert,

this is an excellent note. I will probably create a few indexes and try this out. I'm pretty sure it will fix our issue.

thanks again.