Pls help me with run time errors

[aarif_baig]

HIi abapers,

My problem is that i have developed a report which is working fine on development server

But the same report is giving runtime errors on production server

pls help me out....

and one more thing data is same on dev. server and prd. server

[Former Member]

Can u give the error message?

Anirban

[aarif_baig]

it is related to execution time.....

[aarif_baig]

boss its time out error

[former_member182354]

Hey Asif turn on ST05 'SQL tracer' and see which is the SQL statement which is eating off the processing time and try to optimize the same.

Raghav

[aarif_baig]

its not like that bro its working fine on development server,

the problem is on prdn. server

howevere the dat is same on both the server

[Former Member]

Dear Aarif,

see if that is timeout error, then u have to do the performance tuning of the report.

other wise go to the runtime error,

go to source code extract..

u will get where the prog is giving dump.

Regards

Sachhidananda

Edited by: sachhidananda tripathy on Sep 17, 2008 9:56 AM

[Former Member]

Hi,

Even if the data is same on both the system , the settings internally will be different and the parameter for time out will be less in production system,so try to improve your report performance by checking the coding once again and try to see which tables its taking time and other parameters to improve performance.Once have a talk with Basis People about this.

Thanks

Sudharshan

[Former Member]

Hi

If you've problem of performance you should do a trace of your program in order to get the bottle neck: see trx like SE30 and ST05.

Max

[Former Member]

Try executing the Report in Background.

Usually on the Prod Server the data is vast so u need to execute in the background.