Tomcat Performance issue in SAP Business Objects 4.1 SP7

A New Installation of SAP Business Objects 4.1 SP7 with default Tomcat 7.0 Installation comes with (-Xmx) = 2048M & MaxPermSize = 384M.

However in some cases when there are multiple users login & execution of reports are happening then this memory is quite low & you can see the performance issue in your BO server where Adaptive Processing Server started responding very slow & sometime it’s hang while creating OLAP connections.

Some errors can be visible in logging directory of Tomcat on below file –

/usr/sap//bin
However in the BO system setenv.sh defined parameter to use bobjenv.sh file for memory related parameters.

We can increase the Tomcat memory on below file as per SAP recommendation –

/usr/sap/SID/sap_bobj/tomcat/bin/bobjenv.sh

Create a backup of original file & change the parameter of above file as per below notes.

Please Note – Before updating any Tomcat memory parameter, shut down the BO application & Tomcat, update the parameter & Restart the Tomcat & BO applications.

Verify the Memory of Tomcat in Linux –

ps -ef | grep tomcat ——— see the new memory parameter.

Reference SAP Notes –
2405536 – Best Practice: The popular combinations of Tomcat Max Memory Pool size and MaxPermSize
2075671 – Best Practice: How to identify Tomcat crash, unresponsive or hanging issue

SAP Business Objects 4.1 SP07 Installation Error

Hello All,

During an Installation of SAP Business Objects 4.1 SP07 with DB2 11.1 Database, we have encountered an error after giving CMS DB & Port & click on Continue –

Database access error. Reason Loading shared object failed. First tried to load library db2 and failed because of error: [db2: cannot open shared object file: No such file or directory]. Second tried to load library libdb2.so and failed because of error: [/usr/lib64/libxml2.so.2: symbol gzopen64, version ZLIB_1.2.3.3 not defined in file libz.so.1 with link time reference]. (FWB 00090)

As this error is misleading where SAP suggest to perform some steps at DB2 level for SAP note search for BO 4.1 but in our case this error is something related to Library files which are missing in Installation Folder.

We found the solution in SAP BO 4.2 SAP notes which are listed below –

https://launchpad.support.sap.com/#/notes/2694951
https://launchpad.support.sap.com/#/notes/2689156

As per SAP Note – 2689156 – BI 4.2 SP05 installation failed with DB2 11.1 on Linux 7.3&7.4

Workaround:

Download the 3 files libxml2.so, libxml2.so.2, libxml2.so.2.9.5 from the attachments.
Place these 3 copied lib files in the dunit folder of the downloaded setup files of SBOP BI PLATFORM SERVER.
ex: BusinessObjectsServer/dunit/platform.services.cms.cpp.dbcheck-4.0-core-64. (So that we have both the compatible versions of libxml2.so and its dependents libz.so files in DU directory.)
Run the install setup.sh, It should smoothly proceed with the installation after replacing.

The above solution works like CHARM in our case & we have successfully installed BO 4.1 SP7.

I believe this post helps.