topic problem in production client in Application Development and Automation Discussions

problem in production client

Former Member — Fri, 28 Sep 2007 10:23:56 GMT

dear friends,

i am facing problem on following issue.

a ALV report in devlopement client execute normally but the same report in the production client does not perform well.

that is unable to execute and there is excessive load on the database server.

can anybody suggest me where will be the exact problem.

thanks & regard,

vijay chavan.

Re: problem in production client

Former Member — Fri, 28 Sep 2007 13:26:44 GMT

Hi,

If you are using the ECC 6.0. then you can use the code inspector check( T : CODE :SCI). You might have called the loop inside the loop.

In devel client you might not have so many data's as in the production. So check your code in the code inspector.

Thanks

Yogesh

Re: problem in production client

Former Member — Fri, 28 Sep 2007 13:36:31 GMT

Use transaction ST05 to help with database performance.

Rob

Re: problem in production client

Former Member — Mon, 01 Oct 2007 05:59:33 GMT

Go step by step with break points and check the data selected in SELECT statements and then check for loop where you are geting values in final internal table. Wather all condition get true and data is updated in final table or not. Because some time final table is not updated for wrong data which not stisfy all conditions.

so best method put break points and check for data flow inside your program in production server

Rewards if useful.........

Minal