10-29-2015 3:56 AM
Hi Friends,
I have a report with 2 big queries, reading all Open POs and PRs, then looping to calculate the PO count, PR Count and other values.
Problem is after running the report I am getting Log Off popup.
I used the progress indicator in side the loop to keep the program running, still issue is coming.
Thanks,
Prasad.
10-29-2015 5:42 AM
Hi Lakshmi,
I think you are using the FM 'SAP_GUI_PROGRESS_INDICATOR' , as I remember this will also handles timeouts.
My suggestion is process the logic of progress BAR for selected line of records.
Example: executes process bar logic for every 20000 records once or even less in a loop(Do not execute for each record in a loop).
And also use commit work statement after the FM this will remove your timeout/logoff error.
Note: First try to optimize your code, if nested loop exists try to implement parallel cursor.
Regards,
Shadab.
10-29-2015 4:10 AM
you need to work step by step.
First remove progress indicator code then check..
if still issue coming then look for another.
also show your code. from where it occurs.
-Avirat
10-29-2015 4:39 AM
10-29-2015 5:06 AM
Hi,
If I give the selection parameter to limit the number of records then its working fine, otherwise without any selection screen values, its loging off.
I dont know why loging off popup is coming, thats what the issue.
Thanks,
Prasad.
10-29-2015 5:26 AM
Hi Lakshmi,
Is the system giving any dump??
I think this is because the report is taking too much time to execute, check once with the BASIS consultant.
Regards,
Shadab.
10-29-2015 5:42 AM
Hi Lakshmi,
I think you are using the FM 'SAP_GUI_PROGRESS_INDICATOR' , as I remember this will also handles timeouts.
My suggestion is process the logic of progress BAR for selected line of records.
Example: executes process bar logic for every 20000 records once or even less in a loop(Do not execute for each record in a loop).
And also use commit work statement after the FM this will remove your timeout/logoff error.
Note: First try to optimize your code, if nested loop exists try to implement parallel cursor.
Regards,
Shadab.
10-29-2015 5:56 AM
hi prasad,
could u post your code here
so that your issue can be fixed
10-29-2015 6:39 AM
Hi Lakshmi,
You may refer to below links for using Open, Fetch and Close CURSOR statements.
It may help.
http://scn.sap.com/thread/1760961
https://help.sap.com/saphelp_470/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm
Thanks and Regards,
Vikram
10-29-2015 9:38 AM
Thanks to all for your inputs, I came to know the issue, its regarding continues usage of progress indicator status inside the loop.
11-18-2015 4:00 PM
Hi Lakshmi,
Implement package size, ok?
Select ... appending table it_...[] package size 1000 where ..."
Regards