2010 Jul 19 6:56 PM
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
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
2010 Jul 19 7:57 PM
This is a standard SAP program. Have you looked for notes??
There seem to be some that may help.
Rob
2010 Jul 20 5:20 AM
Hi,
After featching data 20-25 minutes, There is unexpected situation happending in program while executing. Pl. Check for notes.
2011 Feb 10 3:38 PM
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?
2011 Feb 10 3:49 PM
2011 Feb 10 4:07 PM
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.
2011 Feb 10 5:01 PM
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
2011 Feb 10 7:11 PM
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.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |