on 01-10-2012 4:44 AM
Hi expert,
FBL3N T-code takes lot of time to produced output.
and many times accure TIME_OUT Runtime error.
REgards,
Hi Vivek,
When you run the T-code FBL3N , Monitor SM50 and check the tables and run the statistics on the specified tables using Db20 t-code.
Refer to below link for more information.
http://help.sap.com/saphelp_nwpi71/helpdata/en/45/d59f51b3735594e10000000a1553f7/content.htm
Also
Refer to Note 1135916 - Line items: Help for analysis for long runtime
Check whether a suitable database index has been created in the dictionary (transaction SE11 -> indexes). If no index has been created, create the corresponding index and activate it.
Possible fields may be:
BSIS/BSAS: MANDT, BUKRS, HKONT, BUDAT
BSIK/BSAK: MANDT, BUKRS, LIFNR, BUDAT
BSID/BSAD: MANDT, BUKRS, KUNNR, BUDAT
Regards,
Sravanthi
Edited by: Sravanthi.sap on Jan 9, 2012 10:17 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Vivek
We also face same issue with fbl3n,only solution you can give is to ask the user to run in Background,This tcode search bsis,bsas tables which have lakhs of entries.So better to run in Background..Is your system upgraded from 4.7 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vivek,
Is this a strange behavior, that is noticed recently ??
Check, for the following,
Version changes of the reports that being called thru this Trx.
Tables size, for all tables that are being called.
Stats of these tables & index updates .
check the selection criteria, if any, and try to rebuild index, based on those fields.
check the variant, that being used, may be there could be infinite looping. Try doing a debugging, with help of an ABAPer.
check the cost of the SQL queries, thru ST04 > Wait Event Analysis > session Monitoring > (select the SQL statment) and click 'Explain'.
hope this helps!!
~Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.