Skip to Content

Purpose:-
The purpose of this document is to up-grade SAP Business Objects Application from 4.2 to SAP Business Objects Application from 4.2 SP3

Overview:-
Environment Details:-
Operating system: Windows Server 2008 64 Bit
Database: Microsoft SQL Server 2012 R2
Web Application: Tomcat 8
SAP Business Objects Tools: SAP Business Objects BI Platform for Enterprise 4.2

Installation & Configuration steps to upgrade BI4.2 to BI4.2 SP03:-
Pre-Installation Check List:-

  • Backup of file-store, tomcat configuration files & Data base:
  • Backup of CMS & Audit metadata
  • Backup of Following Configuration Files available at Tomcat (Web Tier) & BOBJ Layer (Management Tier & Processing Tier):
    • web.xml
    • server.xml
    • BILaunchpad.properties
    • Global.properties (If you have done any changes)

Make a note of recurring instance available in current environment

  • Pause all instance before doing any upgrade activity

Post-Installation Check List:-

  • Installation of SAP Business Objects 4.2 SP3
  • Validate your configuration with respect to below points:
  • Validate your reports available in your environment
  • SSO (SAP, Windows AD, LDAP, & Others like Oracle SIEBEL)
  • Start all paused instances and check the status after schedule.

SAP Business Objects Platform Services 4.x SPxx PAM Documents:-

1338845 – How to find Product Availability Matrix (PAM) / Supported Platforms Document for SAP BusinessObjects Products
https://service.sap.com/sap/support/notes/1338845
1868888 – Where to find Support Packages or Patches for SAP BusinessObjects Business Intelligence Platform 3.x and 4.x? [Video]
https://service.sap.com/sap/support/notes/1868888

SCN Thread related to Pre-requisite:-
Link:-
http://scn.sap.com/community/bi-platform/blog/2014/07/27/sap-businessobjects-xi-31bi-4x-installation-prerequisites-and-best-practices-linuxunix

http://scn.sap.com/community/bi-platform/blog/2014/05/01/sap-businessobjects-installation-pre-requisitesSoftware Path in SAP Market Place:- Please refer above KBA for software detail

Installation & Upgrade:-

Support Patches:-

Up gradation & Configuration Documents:-

When the prerequisite system check completes successfully, click Next

On the “SAP BusinessObjects BI platform services 4.2 SP3 setup” page, click Next.

Accept the License Agreement, and click Next.

Click on “Read agreement” related to New License Key requirement

Type a password for the CMS Administrator account, and click Next

Now we have option to select “Standard Installation”Or “To run a phase-wise installation”

Standard Installation:- Installation will complete in Single Phase
Select “Standard Installation” and click on Next

Select Web Application option if you want to deploy Tomcat Application on same box and click on Next


To start the installation, click Next

Or Second Option is Phase-wise Installation and click on Next

The installation is performed in two phases – Caching and Installation after caching.

  • Caching is the process of copying the software to the installation directory
  • Installation after caching is the actual installation process


To start the installation, click Next.

Installation is in progress

Still Application is up and running, PFB screenshot of session tab

Phase-Wise Installation is completed

Folder date modified change for below sub folders exits in SAP Business Objects Installation directory

  • Auditing
  • Serverpids
  • logging
  • win64_x64

Again we have to start the Installation and Select “Phase-Wise” Installation
Installation is in progress

Update repository in is progress

Post Installation Steps, Click on Next

Installation is Completed, Click on Next

Relevant Systems
These enhancements were successfully implemented in the following systems:

  • SAP Business Objects Platform Services 4.2 SP3

This document is relevant for:

  • SAP Business Objects Administrator

Reference Material:
SAP BusinessObjects Business Intelligence platform 4.2
http://help.sap.com/bobip

Installation, Upgrade, Deployment:
ttps://websmp204.sap-ag.de/~sapidb/012002523100008807082015E/sbo41sp6_sp_update_en.pdf

What’s New BI Platform 4.2 SP3:
http://help.sap.com/businessobject/product_guides/sbo42/en/sbo42_whats_new_en.pdf

SAP BusinessObjects Business Intelligence platform 4.2 SP3 Product Availability Matrix:
https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/SBOP_BI_42.pdf

SAP BusinessObjects BI platform 4.1 Architecture diagram (PDF)
https://archive.sap.com/documents/docs/DOC-43663

To see the Adobe Flash version of the 4.0 architecture, see:
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/904a8965-c767-2f10-829f-aecac7496de3&overridelayout=true

SAP BusinessObjects BI4 Sizing Guide
https://archive.sap.com/documents/docs/DOC-33126

SAP BI 4.2 SP3: What’s New in Web Intelligence
https://archive.sap.com/documents/docs/DOC-74364

SAP BI 4.2 – BI Platform New Features
https://blogs.sap.com/2016/01/11/sap-bi-42-bi-platform-new-features/

How to Upgrade to BI4.0
http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+Upgrade+to+BI4.0

All you need to know before upgrading to BI4.0
http://wiki.scn.sap.com/wiki/display/BOBJ/All+you+need+to+know+before+upgrading+to+BI4.0

SAP BusinessObjects BI 4.1 Upgrade – Overview
http://scn.sap.com/docs/DOC-56525

Official Product Tutorials – SAP BO BI Suite
https://archive.sap.com/documents/docs/DOC-7725

How to Upgrade to BI4.1 SP06 to BI4.2 Steps
https://blogs.sap.com/2016/03/26/how-to-upgrade-to-bi41-sp06-to-bi42-steps/

Video:-

SAP BusinessObjects BI Platform 4.2 SP3 – Unlocking the CMS Database

SAP Business Intelligence 4.2: New Auditing Universe and Reports

What’s New in SAP BusinessObjects BI Platform Information Design Tool 4.2 SP3.

SAP BusinessObjects BI 4.1: Deployment Best Practices

SAP Business Objects BI: What’s New in Release 4.2?

BI on Users and Sessions: SAP BusinessObjects BI Platform 4.2 SP3

Phase-Wise Installation: SAP BusinessObjects BI Platform 4.2 SP3

RESTful Web Services Folder Management: SAP BusinessObjects BI Platform 4.2 SP3

Mapping User Group to Server Group: SAP BusinessObjects BI Platform 4.2 SP3

To report this post you need to login first.

8 Comments

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

  1. Ralf Berhorst

    Hello Daya,

    I am on the way to update the installed Version BO BI [ 4.2 SP02 (14.2.2.1975) ]. Target is the latest BO BI 4.2 SP03 Patch2.

    1. I try the “51051282…” package. The installer told me, a Version 4.2 is installed and in must uninstall first. OK, i saw it was the full installation package.
    2. I check the download page and download the latest “update” package BIPLATSVR4203P_2-80001044 . It should contain the update .

    But the Check Prerequisites faild with the following “Minimum Support package version”

    Does it mean, i can not directly install the 4.2 SP03 Patch 2? Do i must install the update package BIPLATS4203_0-80001044 (4.2 SP03) first, than install the BIPLATSVR4203P_2-80001044 (4.2 SP03 Patch2) and at the end the latest hotfix?

    Best Regards
    Ralf

    (0) 
  2. Daya Jha Post author

    Hi Ralf,

    As per the error message SP package that you downloaded is not synced hence better to download from below path

    Thanks,
    Daya

    (0) 
  3. sokmeng taing

    Dear Daya,

    Thanks for your good Article .

    Anyway, after my upgrade was competed from  BI 4.2 SP02 (14.2.2.1975)  to the latest BI 4.2 SP03 Patch2. I saw the error message ” ??? dummy.action.Sets.display.name?? “ in the CMC Home. Do you know how to solve this probelm ?

    Thanks for your help.

    Best regards,
    Sokmeng

    (0) 
  4. Athick Ahamed Syed

    Hi Daya,

    I am new to SAP BODS. I created a local repository tried to execute a job. But it got failed stating that “The job server you selected is not working”.
    Can you please suggest how to add a local repository to existing repository as in the “SAP Data Services Server Manager”  I am not able to add a new job sever.

    Your help will be highly appreciated and helpful to me.

    Thanks & Regards,
    Athick

    (0) 
  5. Brian Freiheit Lundholm

     

    Hi Daya,

     

    We are planning to updated from 4.1 sp 5 patch 3 to 4.2 sp 3 patch 9. We need to increase the server capacity and would like to know the best path?

    Do we have to install the new servers on 4.1 sp5 patch 3 and then upgrade them or do we install 4.2 on the servers and move the content? In case the path is to move the content which tool do we use?

    Thanks in advanced

    Kind regards

    Brian

    (0) 
  6. Daya Jha Post author

    Hi Brian,

    Better approach is first do the server sizing and then upgrade the environment, regarding server sizing please refer SAP server sizing guide, as well as SAP sample reports mentioned in above link “SAP Business Intelligence 4.2: New Auditing Universe and Reports”, “SAP BusinessObjects BI4 Sizing Guide https://archive.sap.com/documents/docs/DOC-33126

    If you go for new box it will create unnecessary multiple activity, hence better to increase hardware on existing box.

    Regards,

    Daya Jha

     

    (0) 

Leave a Reply