Performance Issues with Webi Reports

[#1]

Hello,

Recently we upgraded from BOXI r 3.1 FP 1.3 to BOXI r3.1 SP4 and we ve been hit with major performance problems with respect to our webi reports. Reports which used to refresh within 10 minutes are now taking 40 minutes and eventually time out.We have maintained the same configuration parameters at the Universe level and CMS servers level. We have had the DBA review and perform sql tuning and indexing as well. But still the same. Also we had migrated around 200+ reports from the old environment to new environment. Could it be that there might be compatibility issues with objects and other custom variables created from one version to another version?

Any tips on how to improve performance would be very helpful.

Regards,

Kasturi rangan

[DayaJha]

Hi Kasturi,

Please provide the following details regarding your environment:

• BOBJ Environment (Distributed or Not)
• Web Application Details
• Hardware setup is as per SAP recommended (Regarding number of users & reports)

Thanks,

Daya

[Former Member]

Hello Daya,

BOBJ env is not distributed

Web Application used: Tomcat 5.5.20

Not sure if hardware is SAP recommended since the setup was done by third party(BMC Software).

Let me know in case you need further information. Thanks in advance

Regards,

Kasturi Rangan

[DayaJha]

Hi Kasturi,

Regarding Performance Tuning of Web Application(Tomcat Apache)  you can follow the below Steps for Other details refer JinChong Comments:

Step I: Go to the following Path of Tomcat installed with BOE folder is:

<BO install folder>\Tomcat55\conf

Step II: Take a backup of server.xml file before doing any changes.

Step III: Open the server.xml file for edit.

Find the non-SSL HTTP/1.1 Connector and add following lines into it:

compression="on"

compressionMinSize="2048"

nocompressionUserAgents="gozilla, traviata"

compressableMimeType="text/html,text/xml,text/plain,text/css,

text/javascript,text/json,

application/x-javascript,

application/javascript,application/json"

Save the file and close it.

Step IV: Restart Tomcat so the changes take effect.

Hope this will help you as well. After Completion of Activity please close the thread

Thanks,

Daya

[former_member188911]

Only trace log analysis can determine where time is spent, you should ask who provided the installation to do the analysis.

thanks

Simone

[Former Member]

Hi Daya,

What does the parameter you mentioned above do?

If we have SSL configured, then should the above text still go under the non-SSL HTTP connector or should it go under the SSL connector?

Thanks for the help