Skip to Content

/wp-content/uploads/2014/02/list_397893.jpg

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:

PRODUCT TYPE DATE / TIME BUILD INSTALL USER SETUP LANGUAGE COMMITTED
SAP BusinessObjects BI Platform 4.0 SP4 Install 2013-02-06 / 15:58:51 14.0.4.738 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools SP4
Install 2013-02-07 / 09:43:12 14.0.4.738 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  update SP5
Install 2013-02-07 / 11:16:26 14.0.5.882 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5
Install 2013-02-07 / 13:05:26 14.0.5.882 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  update SP5 Patch 3
Install 2013-02-07 / 14:13:53 14.0.5.957 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 3
Install 2013-02-07 / 15:48:50 14.0.5.957 C123456 en TRUE
SAP BusinessObjects Explorer 4.0 SP4 Install 2013-02-14 / 13:37:02 14.0.4.738 I123123 en TRUE
SAP BusinessObjects BI Platform 4.0
  update SP5 Patch 5
Install 2013-03-15 / 09:10:49 14.0.5.1003 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5
Install 2013-03-15 / 11:29:01 14.0.5.1003 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5
Uninstall 2013-03-15 / 14:59:41 14.0.5.1003 C123456 en TRUE
SAP BusinessObjects BI Platform 4.0
  Client Tools update SP5 Patch 5
Install 2013-03-15 / 15:36:20 14.0.5.1003 C123456 en TRUE
SAP Design Studio 11.1.0.84 Install 2013-08-15 / 11:55:35 11.1.0.84 I123123 en TRUE
Crystal Reports for Enterprise 4.0 SP7 Install 2013-12-11 / 10:38:47 14.0.7.1147 I123123 en TRUE
SAP BusinessObjects BI Platform 4.1
  update SP2
Install 2013-12-16 / 22:13:39 14.1.2.1121 D213123 en TRUE
SAP BusinessObjects BI Platform 4.1
  Client Tools update SP2
Install 2013-12-17 / 15:08:27 14.1.2.1121 D213123 en TRUE
Crystal Reports for Enterprise 4.0 SP7 Uninstall 2013-12-17 / 17:10:54 14.0.7.1147 D213123 en TRUE
Crystal Reports for Enterprise 4.0 SP2 Install 2013-12-17 / 18:31:06 14.1.2.1121 D213123 en TRUE
Crystal Reports for Enterprise 4.0 SP2 Uninstall 2013-12-18 / 12:18:04 14.1.2.1121 D213123 en TRUE
Crystal Reports for Enterprise 4.0 SP7 Install 2013-12-18 / 14:01:38 14.0.7.1147 D213123 en TRUE
SAP BusinessObjects BI Platform 4.0 SP2 Maintenance 2014-01-12 / 12:37:02 14.1.2.1121 D213123 en TRUE
SAP BusinessObjects BI Platform 4.1
  update SP2 Patch 2
Install 2014-02-11 / 16:46:56 14.1.2.1195 I123123 en TRUE
SAP BusinessObjects BI Platform 4.1
  update SP2 Patch 3
Install 2014-02-20 / 13:23:07 14.1.2.1216 I123123 en TRUE

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

PRODUCT TYPE DATE / TIME BUILD INSTALL USER SETUP LANGUAGE COMMITTED
SAP BusinessObjects BI Platform 4.0 SP4 Install 2012-11-15 / 11:38:17 14.0.4.738 SAP\TJohnston en TRUE
Data Services 4.0 SP3 Install 2012-11-16 / 09:43:14 14.0.3.273 SAP\TJohnston en TRUE
SAP BusinessObjects BI Platform 4.0 update SP4 Patch 5 Install 2012-11-19 / 10:53:14 14.0.4.855 SAP\TJohnston en TRUE
Data Services 4.0 SP3 Patch 1 Upgrade 2012-11-19 / 12:11:46 14.0.3.353 SAP\TJohnston en TRUE
SAP BusinessObjects BI Platform 4.0 update SP5 Install 2013-04-26 / 15:59:25 14.0.5.882 SAP\TJohnston en TRUE
SAP BusinessObjects BI Platform 4.0 update SP5 Patch 7 Install 2013-04-26 / 18:12:57 14.0.5.1036 SAP\TJohnston en TRUE
Data Services 4.0 SP3 Patch 3 Upgrade 2013-04-26 / 19:52:46 14.0.3.451 SAP\TJohnston en TRUE
SAP BusinessObjects Explorer 4.0 SP7 Install 2013-08-24 / 13:00:29 14.0.7.1147 TCoffman en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Install 2013-08-25 / 14:32:03 14.0.6.1036 TCoffman en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 4 Install 2013-08-25 / 17:36:34 14.0.6.1145 TCoffman en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 11 Install 2014-01-24 / 19:19:10 14.0.6.1312 TCoffman en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 11 Uninstall 2014-02-06 / 15:29:57 14.0.6.1312 TCoffman en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 10 Install 2014-02-07 / 13:28:07 14.0.6.1272 SAP\TJohnston en TRUE
SAP BusinessObjects BI Platform 4.0 update SP6 Patch 10 Install 2014-02-11 / 15:26:10 14.0.6.1272 SAP\TJohnston en TRUE

Download the latest stand-alone version from here

BOE and Data Services Patch History Analysis Tool – Business Intelligence (BusinessObjects) – SCN Wiki

Download the BI Platform Support Tool here:

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

To report this post you need to login first.

4 Comments

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

Leave a Reply