Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BI Platform & Data Services Patch History Analysis Tool

Toby_Johnston
Advisor
Advisor
‎02-26-2014 3:48 PM

When investigating a problem on a SAP BusinessObjects node, it is often very helpful to understand what software has been installed on the host and in what order was it installed.  Fortunately, the installer that SAP BusinessObjects products uses keeps a detailed record of this information and this type of detail is accessible if you know where to find it.  This Patch History Analysis capability will soon be included as part of the BI Platform Support Tool Landscape Analysis Report however in the meantime, I thought it would be helpful to release a stand-alone version for BI / DS administrators to utilize.

The stand-alone tool is an executable jar file that queries this information from the installation manifest (InstallManifest.sqlite) of a BOE system and generates an Excel report (.csv) containing information including:

  • Which products and patches were installed
  • What order were they installed
  • What date/time it was installed
  • Was it an install, uninstall, repair
  • Which user installed it
  • What was the build number
  • What is the setup language
  • Was the installation committed successfully to the manifest

Currently, the tool is programmed to support the following products and versions

  • SAP BusinessObjects BI Platform 4.0 / 4.1
  • SAP Data Services 4.0 / 4.1 / 4.2
  • Information Steward 4.0 / 4.1 / 4.2

Usage

  1. Download PatchHistory.zip and unzip PatchHistory.jar to the SAP BusinessObjects InstallData folder (for example C:\Program Files (x86)\SAP BusinessObjects\InstallData) or copy the file InstallManifest.sqlite to the same folder as your PatchHistory.jar (note: Java 1.6 is required)
  2. Double click the PatchHistory.jar (alternatively, launch the program using the command java -jar PatchHistory.jar)
  3. A .csv file is generated
  4. Open the .csv in Excel

Here's example output from a BI Platform 4.0 node:

PRODUCTTYPEDATE / TIMEBUILDINSTALL USERSETUP LANGUAGECOMMITTED
SAP BusinessObjects BI Platform 4.0 SP4Install2013-02-06 / 15:58:5114.0.4.738C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools SP4		Install2013-02-07 / 09:43:1214.0.4.738C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  update SP5		Install2013-02-07 / 11:16:2614.0.5.882C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5		Install2013-02-07 / 13:05:2614.0.5.882C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  update SP5 Patch 3		Install2013-02-07 / 14:13:5314.0.5.957C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 3		Install2013-02-07 / 15:48:5014.0.5.957C123456enTRUE
SAP BusinessObjects Explorer 4.0 SP4Install2013-02-14 / 13:37:0214.0.4.738I123123enTRUE
SAP BusinessObjects BI Platform 4.0
  update SP5 Patch 5		Install2013-03-15 / 09:10:4914.0.5.1003C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5		Install2013-03-15 / 11:29:0114.0.5.1003C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5		Uninstall2013-03-15 / 14:59:4114.0.5.1003C123456enTRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5		Install2013-03-15 / 15:36:2014.0.5.1003C123456enTRUE
SAP Design Studio 11.1.0.84Install2013-08-15 / 11:55:3511.1.0.84I123123enTRUE
Crystal Reports for Enterprise 4.0 SP7Install2013-12-11 / 10:38:4714.0.7.1147I123123enTRUE
SAP BusinessObjects BI Platform 4.1
  update SP2		Install2013-12-16 / 22:13:3914.1.2.1121D213123enTRUE
SAP BusinessObjects BI Platform 4.1
  Client Tools update SP2		Install2013-12-17 / 15:08:2714.1.2.1121D213123enTRUE
Crystal Reports for Enterprise 4.0 SP7Uninstall2013-12-17 / 17:10:5414.0.7.1147D213123enTRUE
Crystal Reports for Enterprise 4.0 SP2Install2013-12-17 / 18:31:0614.1.2.1121D213123enTRUE
Crystal Reports for Enterprise 4.0 SP2Uninstall2013-12-18 / 12:18:0414.1.2.1121D213123enTRUE
Crystal Reports for Enterprise 4.0 SP7Install2013-12-18 / 14:01:3814.0.7.1147D213123enTRUE
SAP BusinessObjects BI Platform 4.0 SP2Maintenance2014-01-12 / 12:37:0214.1.2.1121D213123enTRUE
SAP BusinessObjects BI Platform 4.1
  update SP2 Patch 2		Install2014-02-11 / 16:46:5614.1.2.1195I123123enTRUE
SAP BusinessObjects BI Platform 4.1
  update SP2 Patch 3		Install2014-02-20 / 13:23:0714.1.2.1216I123123enTRUE

Here's example output from a BI Platform 4.0 (with Data Services add-on) node:

PRODUCTTYPEDATE / TIMEBUILDINSTALL USERSETUP LANGUAGECOMMITTED
SAP BusinessObjects BI Platform 4.0 SP4Install2012-11-15 / 11:38:1714.0.4.738SAP\TJohnstonenTRUE
Data Services 4.0 SP3Install2012-11-16 / 09:43:1414.0.3.273SAP\TJohnstonenTRUE
SAP BusinessObjects BI Platform 4.0 update SP4 Patch 5Install2012-11-19 / 10:53:1414.0.4.855SAP\TJohnstonenTRUE
Data Services 4.0 SP3 Patch 1Upgrade2012-11-19 / 12:11:4614.0.3.353SAP\TJohnstonenTRUE
SAP BusinessObjects BI Platform 4.0 update SP5Install2013-04-26 / 15:59:2514.0.5.882SAP\TJohnstonenTRUE
SAP BusinessObjects BI Platform 4.0 update SP5 Patch 7Install2013-04-26 / 18:12:5714.0.5.1036SAP\TJohnstonenTRUE
Data Services 4.0 SP3 Patch 3Upgrade2013-04-26 / 19:52:4614.0.3.451SAP\TJohnstonenTRUE
SAP BusinessObjects Explorer 4.0 SP7Install2013-08-24 / 13:00:2914.0.7.1147TCoffmanenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6Install2013-08-25 / 14:32:0314.0.6.1036TCoffmanenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 4Install2013-08-25 / 17:36:3414.0.6.1145TCoffmanenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 11Install2014-01-24 / 19:19:1014.0.6.1312TCoffmanenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 11Uninstall2014-02-06 / 15:29:5714.0.6.1312TCoffmanenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 10Install2014-02-07 / 13:28:0714.0.6.1272SAP\TJohnstonenTRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 10Install2014-02-11 / 15:26:1014.0.6.1272SAP\TJohnstonenTRUE

Download the latest stand-alone version from here

BOE and Data Services Patch History Analysis Tool - Business Intelligence (BusinessObjects) - SCN Wi...

Download the BI Platform Support Tool here:

SAP BI Platform Support Tool - Business Intelligence (BusinessObjects) - SCN

4 Comments
Labels in this area
Popular Blog Posts