Skip to Content
Technical Articles
Author's profile photo Daya Jha

How to Upgrade to BI4.1 SP06 Patch 3 to BI4.2 SP07

Purpose:

The purpose of this document is to up-grade SAP Business Objects Application from 4.1 SP06 Patch 3 to SAP Business Objects Application from 4.2 SP07

Overview:

Environment Details:

Operating system: Windows Server 2012 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.1 SP06 to BI4.2

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 BO 4.2 SP07
  • Validate your configuration with respect to below points:
    • SSO (SAP, Windows AD, LDAP, & Others like Oracle SIEBEL)
    • Start all paused instances and check the status after schedule.
  • Validate your reports available in your environments

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

1868888 – Where to find Support Packages or Patches for SAP BusinessObjects Business Intelligence Platform 3.x and 4.x? [Video]

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-requisites

Software Path in SAP Market Place:- Please refer above KBA for software details

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

Select Language, English (By Default) and click Next

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 SP7

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 SP7:
http://help.sap.com/businessobject/product_guides/sbo42/en/sbo42_whats_new_en.pdf

SAP BusinessObjects Business Intelligence platform 4.2 SP7 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 SP7: What’s New in Web Intelligence
https://blogs.sap.com/2019/02/01/sap-bi-4.2-sp7-whats-new-in-web-intelligence-and-semantic-layer/

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/

SAP KBA:- 

2740939 – SAP BusinessObjects BI Platform 4.2 SP7 Upgrade Guide

2740955 – SAP BusinessObjects BI Suite 4.2 SP7 Release Restrictions

2740960 – SAP BusinessObjects BI Suite 4.2 SP7 What’s New

2740900 – SAP BusinessObjects BI Platform 4.2 SP7 Installation Guides for Windows and Unix

2825177 – BI Platform 4.2 SP7 Patch 4 has encountered errors during the installation process

2801734 – Web Intelligence document hangs or displays no data when opened from Google Chrome version 75.0.3770.80

2802773 – Scheduled reports with contexts fail

2271474 – RUBI42 – Too many Lumira temp files causing out of disc space error

2843353 – Opendocument link from Lumira dashboard to Web Intelligence document opens blank window

2446234 – Schedule Lumira report fails with error: Not a valid logon token (FWB 00003)

2636305 – Opening Lumira Designer Application shows “Could not load query error”

2124330 – max no of 404 conversations exceeded 

2451830 – Windows Updates needed for Successful Installation of / Update to SAP BusinessObjects BI Platform 4.2 SP04 & above / 4.1 SP10 & above

Video:-

What’s New in Fiorified BI Launch Pad: SAP BusinessObjects BI 4.2 SP7

How to Send an Email Notification in the Automation Framework: SAP BusinessObjects BI 4.2 SP7

SAML 2.0 Authentication: SAP BusinessObjects BI 4.2 SP7

SAP BusinessObjects BI 4.1: Deployment Best Practices

SAP BusinessObjects BI 4.2 SP7: LMBI Measurement Demo

Phase-Wise Installation: SAP BusinessObjects BI Platform 4.2 SP3

Folder & Category Links: SAP BusinessObjects BI 4.2 SP7

Related Blog Posts:- 

How to Upgrade to BI4.1 SP06 to BI4.2 Steps

How to Upgrade to BI4.1 SP02 to BI4.1SP06 Steps including Lumira Server

How to Upgrade to BI4.2 to BI4.2 SP3 Steps

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Khalid Al-Mansoor
      Khalid Al-Mansoor

      Dear Daya,

       

      is the installation in the same server or in new server?

      can you please make a video in youtube?

       

      Regards,

      Khalid.

      Author's profile photo Aishwarya Ravichandran
      Aishwarya Ravichandran

      Hi Sir, Oracle 12c is migrating to 19c , it's not supporting ebo 4.2 sp6 , what are the changes need to be done from ebo ? Can you please anyone tell this

      Author's profile photo Aishwarya Ravichandran
      Aishwarya Ravichandran

      Hi daya

      While migrating 12c to 19c what changes should be done in ebo 4.2 sp6

      Author's profile photo Daya Jha
      Daya Jha
      Blog Post Author

      Hi Aishwarya,

      From BO 4.2 SP07+. and Oracle Exadata 19c supported from SP08+

      please refer below PAM and SAP KBA article.

      https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/SBOP_BI_42.pdf

      2826490 - Oracle 19c database support in BI 4.x
      https://launchpad.support.sap.com/#/notes/2826490

      1767916 - How to configure 64-bit & 32-bit Oracle clients for use with SAP BI 4.x
      https://launchpad.support.sap.com/#/notes/1767916

      2109044 - Error "The CMS on machine '<servername>' was stopped due to a critical error. (FWM 20031)"
      https://launchpad.support.sap.com/#/notes/2109044

      3086948 - CMS failed to be started after CMS database is upgraded to Oracle 19c
      https://launchpad.support.sap.com/#/notes/3086948

      3154221 - BI 4.3 Universe Oracle DBDriver failed to load
      https://launchpad.support.sap.com/#/notes/3154221

      2975928 - when using Oracle 19c ODBC Driver to access a database table, datatypes get messed up and some information are missing in SAP Crystal Reports for Enterprise
      https://launchpad.support.sap.com/#/notes/2975928

      2808432 - Add Oracle 19c Support on Crystal Reports for Enterprise by using Oracle 18c middleware for both JDBC and OCI
      https://launchpad.support.sap.com/#/notes/2808432

      3015613 - Oracle Database support for BI Platform on AWS
      https://launchpad.support.sap.com/#/notes/3015613

      I hope this will help

      Regards,

      Daya Jha

      Author's profile photo Aishwarya Ravichandran
      Aishwarya Ravichandran

      The link which you send is not opening sir

      Author's profile photo Daya Jha
      Daya Jha
      Blog Post Author

      Please use SUSER ID to open SAP KBA & PAM

      Regards,

      Daya Jha