topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Mon, 21 Jul 2008 01:04:40 GMT

devlopement it is working properly moving in to production server it showing the error like time out hat could be the problem

Re: reports

nikhil_chitre — Mon, 21 Jul 2008 01:26:41 GMT

Hi,

It could be because you program is taking long time for execution.

probably your select statement is taking very long.

Development client has less data compared to production so you did not get time out dump.

Try to Run your program in background in production and check what the result is .

also analyse your program SE30.

Regards,

Nikhil

Edited by: Nikhil A Chitre on Jul 21, 2008 11:26 AM

Re: reports

venkatasriram_mygapula — Mon, 21 Jul 2008 01:59:47 GMT

Hi,

in the production server there are huge data compare with development client. so first of all u need to check the performance in your program in the transaction code se30.

if it takes time apply some performance techniques like

every time check sy-subrc and sort internal table use read statements with binary search. better to use hashed tables instead of standard tabel.

Regards.

Sriram.

Re: reports

former_member125931 — Mon, 21 Jul 2008 03:03:26 GMT

It is due toamount of data in PRD,you should tune your program check the performance in se30 transaction in Development.

now perform below steps in development server

first go to ST05 transaction and active trace there,come to your program execute it again goto ST05 deactive the trace then display trace ,here you can obser which table was taking time for executing,

now change your select query in where condition use primary keys and create the Index for the table which has taken more time,now check the performance in se30 by rpviding your program name.

if you need more help regarding changing your query and how to index we will help you here.

Edited by: Sree on Jul 21, 2008 5:03 AM