Skip to Content

Purpose:

The purpose of this document is to improve performance of SAP Business Objects Data Services Management console 4.x.

Overview:

Environment Details:

Operating system: Windows Server 2008 64 Bit/Red Hat Linux 2.6.32

Database: Microsoft SQL Server 2008 R2/Oracle 11.2.0.3

Web Application: Tomcat

SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.1 SP2; SAP Data Services 4.2 SP1

Repository version: BODS 4.X

 

I got real problems with performance in SAP Business Objects Data Services Management Console. For instance, my real time services, Jobs & Adapters were opening very long time.

 

All Status in SAP Business Objects Data Services Management Console will take more time to load

 

In LINUX Operating System below are the settings:

 

  • Let’s modify the Tomcat setting, because by default they have low value.
  • JavaHeapSize (-Xmx) from 2G to 4G
  • JavaHeapSize we should modify: 

cd <boe/boips inst folder>/sap_bobj/tomcat/bin

 

modify setenv.sh

# set the JAVA_OPTS for tomcat

 

Code:

JAVA_OPTS=”-d64 -Dbobj.enterprise.home=${BOBJEDIR}enterprise_xi40 -Djava.awt.headless=true -Djava.net.preferIPv4Stack=false –Xmx4g -XX:MaxPermSize=384m -XX:+HeapDumpOnOutOfMemoryError -Xloggc:<bo_inst_folder>/sap_bobj/tomcat/logs/tomcat.gc.log -XX:+PrintGCDetails -XX:+UseParallelOldGC”

 

  • Non- SSL we would modify:

cd <boe/boips_inst_folder>/sap_bobj/tomcat/conf modify
server.xml
Define a non-SSL HTTP/1.1 Connector on port 8080

 

Code:

    –>
<Connector port=”8080″ protocol=”HTTP/1.1″ connectionTimeout=”20000″ redirectPort=”8443″ maxThreads=”150″ URIEncoding=”UTF-8″/>

<!– A “Connector” using the shared thread pool–>

<!–

<Connector executor=”tomcatThreadPool”

port=”8080″ protocol=”HTTP/1.1″

connectionTimeout=”20000″

redirectPort=”8443″ />

–>

  • Cleaning of old installed patches and service packs from BOE/BOIPS. What does it mean?
    Just go to <boe/boips inst folder> and run ./modifyOrRemoveProducts.sh (for Linux):
    It is clear that i have many various installation on my server. But it is important to delete old installation!
  • Cleaning of log directory, in <boe/boips inst folder>/sap_bobj/tomcat/logs
  • Cleaning of logging directory, in <boe/boips inst folder>/sap_bobj/logging
  • Cleaning of Access Server old logs directory, in <boe/boips inst folder>/DataServices/conf/<Access Server Name>error<date>.txt & trace<date>.txt old logs
  • Cleaning of Job Server old logs directory, in <boe/boips inst folder>/DataServices/adapters/logs
  • Cleaning of old Adapter logs directory, in <boe/boips inst folder>/adapters/logs
  • Cleaning of old RFC logs directory, in <boe/boips inst folder>/
  • Deleting Trace-Files
  • Setting in Central management console to delete old logs of Data services older than 5 days

By Default:

By Default - DS Settings.png

After doing changes:

By Default - DS Settings I.png

  • Tuning APS, for start you can use CMC Wizard.
  • APS properties for tracing set to unspecified (-> means bo_trace.ini are used)

 

 

In Windows Operating System below are the settings:

 

  • Let’s modify the Tomcat setting, because by default they have low value.
  • JavaHeapSize (-Xmx) from 2048 to 4096

Code:

set PATH=%PATH%;C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\

set JAVA_HOME=C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\

set JAVA_OPTS=%JAVA_OPTS% -Xmx2048m -XX:MaxPermSize=384m

 

Path: cd <boe/boips inst folder>/SAP BusinessObjects\tomcat\bin\setenv

 

Tomcat Settings.png

Best Architecture for Deployment of SAP Business Objects Data Services: 

 

There are many pros and cons for deployment of SAP Business Objects Data Services with SAP BOE 4.X, as per the Best practices below are the possible scenario

Possible Architecture.PNG

 

 

 

Reference Material:

YouTube Video: Splitting BI 4.0 Adaptive Processing Servers

http://youtu.be/2Uyi0V7RdwA

 

 

Best Practices for SAPBO BI 4.0 Adaptive Processing Servers 

http://scn.sap.com/docs/DOC-31711


SAP BI 4.0 Ecosystem how-to videos

http://scn.sap.com/docs/DOC-34251

 

Performance Optimization Guide – SAP Data Services 4.2:

 

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_perf_opt_en.pdf

 

 

Administrator Guide – SAP Data Services 4.2:

 

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_admin_en.pdf

 

SAP Data Services 4.2:

https://help.sap.com/bods

SNotes:

1640036 Added memory usage when splitting Adaptive Processing Server (APS) services

https://service.sap.com/sap/support/notes/1640036

 

1580280 Adaptive Processing Server and Adaptive Job Server in SAP BI 4.0 are using high amounts of memory and are hard to manage and troubleshoot

https://service.sap.com/sap/support/notes/1580280

 

1694041 – BI 4.0 Consulting:- How to size the Adaptive Processing Server

https://service.sap.com/sap/support/notes/1694041

 

1452165 – How to increase the maximum memory pool for Apache Tomcat used by Management Console – Data Services / Data Integrator

https://service.sap.com/sap/support/notes/1452165

 

1452186 – What is the maximum memory pool limit for Apache Tomcat used by Management Console? – Data Services / Data Integrator

https://service.sap.com/sap/support/notes/1452186

 

1644004 – Enable or disable RFC Server trace logging (traces DQM traffic between SAP & DS)

https://service.sap.com/sap/support/notes/1644004

 

1529071 – Sizing how many RFC Servers you should use

https://service.sap.com/sap/support/notes/1529071

 

1544413 – Troubleshooting RFC Server – composite note

https://service.sap.com/sap/support/notes/1544413

 

1764059 – Troubleshooting RFC Server – can’t find log file

https://service.sap.com/sap/support/notes/1764059

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. jassy pang

    HI,Daya,The management console of data services is very slow. I have to wait about 20 minutes to access it .Each time I restart the server ,the management console become fast untill about 4 days later,it is back to be slow.Could you have some good ideas?

    (0) 
  2. Daya Jha Post author

    Hi Jassy,

    Could you please check confirm are you using Tomcat as a web application sever, If Yes then as per your H/W change the configuration.

    Launch the Tomcat Configuration program from the Windows start menu.

    Increase Initial memory pool, Maximum Memory Pool & Thread Stack Size as per the H/W.

    Reference Link:-
    https://wiki.scn.sap.com/wiki/display/BOBJ/Web+application+server+configuration
    https://archive.sap.com/documents/docs/DOC-33126
    https://www.dunnsolutions.com/content/bi-blog/-/blogs/sap-bi-tomcat-best-practices-configuration
    http://umangsapbiconsultant.blogspot.in/2013/06/configure-tomcat-7-with-bi-4-sp04.html

    Thanks,
    Daya

    (0) 
  3. Naveen vuppala

    Hi ,

    I need help regarding while running Sales force source tables are being use in 8 data flows inside a WF and in a job…..These data flows running in parallel….Some times we are getting error

    Error preparing to read from……Could not start (Adapter: ‘SalesForce_XYZ’)…

    When we restart the adapter and run the job is getting succeeding….

    I read some blogs regarding the options page:

    change the Additional Java Launcher Options from -Xms64m -Xmx256m to -Xms256m -Xmx1024m

    does this work? any other options?

     

    I am assuming when we restart the adapter the trace log file will truncate and start again , So we may increase memory to hold the size of java pages  to capture the trace file….I need what are all the probable options to increse the size of the memory.

     

    Thank you,

    Naveen

     

    Thank you,

    Naveen

     

     

    (0) 

Leave a Reply