topic Re: Getting timeout error while executing my report in Application Development and Automation Discussions

Getting timeout error while executing my report

Former Member — Mon, 09 Aug 2010 16:11:07 GMT

Hi experts,

I need to get data from a Ztable which is having more than 64 millions of records. That query itself is taking more than 20 min to execute. I have used package size while retrieving tha data but still taking same time to execute, Giving me the TIMEOUT error .

Provide some suggetions to use different types of SELECT quries that can be used to improve the performance.

Thanks & Regards,

Bhanu

Re: Getting timeout error while executing my report

Sandeep_Panghal — Mon, 09 Aug 2010 16:18:42 GMT

1.use OPEN CURSOR with package size

2. try to process the program in background and also

Re: Getting timeout error while executing my report

Jelena_Perfiljeva — Mon, 09 Aug 2010 21:16:25 GMT

There is a separate forum dedicated specifically to the performance issues, there are many suggestions already available there. Please use Search. Also use the standard performance analysis tools available in SAP.

If the program has already been optimized to the max, you might want to consider running in "batches". E.g. create a parameter (e.g. a date) to limit selection and run the program several times.

In any case, a program that is reading 64 mil. records should not be run in foreground. Also I'd question its purpose and the business requirements for such program.

Re: Getting timeout error while executing my report

Former Member — Tue, 10 Aug 2010 06:50:22 GMT

Hi ,

I am working as an abaper for Service Management module.

I need to show the prmise details inthe output of alv. Before that i need to get the meter reading details and need to do some calculations, by which i need to show idle one (Here only i need to hit a ZTABLE which is having more than 64 million records). For that idle premise user can select multiple pemises by using check boxes and can create notification by pressing a pushbutton 'CREATE IS NOTIFICATION' which exist on the application toolbar . So i can not run this report in background.

Thanks & regards,

Bhanu.

Re: Getting timeout error while executing my report

Former Member — Fri, 05 Nov 2010 12:08:43 GMT

Resolved.