topic Time out Error due to Large data in Application Development and Automation Discussions

Time out Error due to Large data

Former Member — Wed, 28 May 2008 12:00:45 GMT

Hello friends,

I am SAP-ABAPER .

I have one report.There is input screen of date & so.

If I enter 1 to 10 days , then it execure successfuly,

but enter 30 or more days then it gives time out error.

I checked follwoinf things,

1) Query is right as per standards,

2) Not any join condition in that report

3) proper use where clause.

**********************************************************

how I can solve prob.

**********************************************************

Thanks & regards,

Rahul S. Shinde.

Re: Time out Error due to Large data

Former Member — Wed, 28 May 2008 12:03:52 GMT

U can only run it in background mode

Max

Re: Time out Error due to Large data

Former Member — Wed, 28 May 2008 12:04:30 GMT

Hi,

Where exactly it is showing performance issue?

Paste your code.

Thanks,

Sriram Ponna.

Re: Time out Error due to Large data

Former Member — Wed, 28 May 2008 12:05:18 GMT

Hello,

take alook to OSS Note 779123 'Memory-related terminations at runtime'

and also.....

Please debug the program and see where is the program getting timed out , in the select statement or some where else , beacuse based on that only can further action be deterined

*************Reward points,if found useful

Re: Time out Error due to Large data

Former Member — Wed, 28 May 2008 12:07:29 GMT

Hi,

If you getting problem while read data from database then use the below way of reading.

data:n type i,

days_from type i,

days_to type i.

n = days_to - days_from / 10.

days_from = 1.

days_to = 10.

if n = 0.

n = 1.

endif.

do n times

days_from = days_from + 10.

days_to = days_to + 10.

enddo

This will definatly helps you.

Rgds,

Bujji

Re: Time out Error due to Large data

vinod_vemuru2 — Wed, 28 May 2008 12:10:43 GMT

Hi Rahul,

Two solutions.

1. Run the report as batch job if u don't have to download data to presentation server.(Safe way to go ahead)

2. Ask Basis person to increase the default timeout level.(Not safe as per system load and configurations)

Time out was because of huge amount data for the given selection criteria.

U can check the report output in spool(SP01 transaction) and ofcource u can download/convert to PDF too:-) if u run in background.

Thanks,

Vinod.