Hi All,
Environment : BI 4.1 .
Reporting Database : BW 7.4 SP3.
Recently we migrated to BI 4.1 SP3 from BI 4.0 SP6.
From then reports in BI 4.1 launchpad was taking so much time compared to BI 4.0 and BI 4.1 Rich Client.
There was drastic change in performance .A report which is running in 30 sec in BI 4.1 Rich client and BI 4.0 SP6 was taking >10 minutes in BI 4.1 launchpad.
Below tasks helped us to achieve the performance again.
1.Disabling logs:
-Go to CMC,navigate to the servers and then webi processing server.
-Right click and go to properties.
-Set log level as "None"
-Do the same for all webi processing server.
-Same step you have to follow for rest of the servers.
-For only CMS keep log level as "Unspecified".
2.Delete logs:
-Go to Installing Directory of BusinessObjetcs\SAP BusinessObjects\SAPBusinessObjects Enterprise XI 4.0\logging directory.
-Delete all unwanted logs(.glf files).
3.Clear Cache:
-Go to Installing Directory of BusinessObjetcs\SAP BusinessObjects\SAPBusinessObjects Enterprise XI 4.0\Data directory.
-Take back up of all the content inside it and delete everything.
4.Clear Tomcat cache:
-Stop Tomcat.
-Go to Installing Directory of BusinessObjetcs\SAPBusinessObjects\Tomcat\work\Catalina\localhost.
-Take back up of all the content inside it and delete everything.
-Start Tomcat.
After performing all these steps, Restart SIA.
In Addition to above , we can consider below points also for better performance.
A. If source to webi is .UNV
- Change the connection pool mode to 'Disconnect after each transaction'.
- Increase the Array fetch size to 1000.
- In Universe Parameters, click on the Parameters tab and change the setting DISABLE_ARRAY_FETCH_SIZE_OPTIMIZATION from the default of "No", to "Yes" and click the "Replace" button, then Ok to save the
changes.
B.Disable Connection Server Trace
Modify cs.cfg In Windows this is located in the following
directory C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer Set the
following parameter to this value <Traces Active="No">
C.Follow the SAP NOTE:1930558 -
How to utilize the 64-bit SAP BAPI driver with UNV universes in BI 4.x (Windows) .
Thanks to Sabari Vasan.S for his valuable sharing
Please post if you have any other points to consider for better performance. :smile:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |