Time out Error due to Large data

[Former Member]

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.

[Former Member]

Hi

U can only run it in background mode

Max

[Former Member]

Hi,

Where exactly it is showing performance issue?

Paste your code.

Thanks,

Sriram Ponna.

[Former Member]

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

[Former Member]

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

<your select query or processing of your code>

days_from = days_from + 10.

days_to = days_to + 10.

enddo

This will definatly helps you.

Rgds,

Bujji

[vinod_vemuru2]

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.