Foroohar Rafiei gave this webcast today.  Based on end user feedback BI platform was a top topic area Announcing ASUG BI 2013 Community Survey Results

This was the agenda:

  • Current BI Maintenance Practices
  • Patching Best Practices
  • Parallelized Patching
  • Outlook on Planned Maintenance Improvements

Foroohar explained that the risks are time consuming.  The risk is your update wipes out a previous fix or overwrites a previous fix

Time could be a factor; people might want to avoid updating if not have to.

You can update system successfully and more successful than before.

With this webcast, Foroohar reviewed the necessary steps to building a patching strategy and also updating your BI 4 system successfully.

And at the end of the webcast Lawell Kiing, SAP explained the outlook on planned Maintenance Improvements


Figure 1: Source: SAP

Naming conventions take a “One SAP” approach

Service pack is now a minor release (e.g. BI4.1)

Fix pack is now SP

LA fix is now Patch


Figure 2: Source: SAP

SAP wants to reduce the number of fixes in patches to ensure better quality

Patches have a short time release; testing time could be short

Support packs have a longer time to test

Patches should be just critical

Figure 2 shows the “One SAP” approach for common naming conventions across products


Figure 3: Source: SAP

Figure 3 shows “lots of notes”.

It is a snapshot of note at the bottom – SAP notes that tells you when open ticket – severity will determine if fix goes in a patch or a SP


Figure 4: Source: SAP

Dates might change; you can plan for calendar week

BI4.1 in middle, patch 1.7 will be March week 10

SP3 will be calendar week 13, end of March


Figure 5: Source: SAP

Figure 5 shows how to access the maintenance schedule.  I don’t have many notes on this part but I forget myself where these things are located.


Figure 6: Source: SAP

Figure 6 shows a change to the maintenance strategy

As an example, at beginning patch 2.21 in BI4 – when fix is found, fix goes in 2.21 and goes in next latest SP

Patch to Patch Forward Fitting means that “all fixes from patches of older SPs are added to the latest patch of the highest already delivered SP”.

From SAP slide:

You can find Release Notes below:

  1.  > Software Downloads > Support Packages and Patches > A-Z Index > B > SBOP BI Platform (former SBOP Enterprise) > SBOP BI Platform (Enterprise) > SBOP BI Platform 4.1 > SBOP BI Platform Servers 4.1 > (Server OS) > Patch or SP > Info

This “requires login credentials to the SAP Service Marketplace”

“Release Notes for Patches and Support Packs contain a cumulative list of all the ADAPT fixed in a given release”.  As an example the Release Notes for Patch 4.9 will contain a list of all the fixes in Patches 4.1-4.9.

Release notes are important “the source of truth” and tells you what has been fixed according to Foroohar


Figure 7: Source: SAP

When you build a strategy make sure you track ADAPT problem reports that track your deployment instead of installing every patch

Foroohar said there is no need to install every patch.  Every 6 months evaluate a maintenance release in a test environment, and make sure you have a test environment

“Make sure all BI Servers and Clients are at the same patch level.”

Best Practice before Patching – Backups:

Windows: Do a full server backup as because “the registry gets altered and the file system is extensively touched”

Unix: There is no registry, the user’s home folder and the product install location are all that are needed.

Common to both unix and Windows : back up FRS, the entire whole data folder, not just input and output; CMS/Audit databases need to be backed up.

More than once Foroohar said to read  “Backing Up and Restoring Your System” in the Business Intelligence Platform Administrator Guide.

Other tips:

When upgrading from SPx to SPx+n, run the UPDATE INSTALLER and not the full installer (seen this issue on SCN).

SPx Full build is for fresh installs, and it should not be used to update an existing installation.

Common question – “You can go from any SP level to any higher SP level without uninstalling or installing the intermediate SPs or patches.” I

Foroohar advises going “over the latest support & feature pack release notes available at SAP Help Portal or SMP”

He said turn off all servers, except the most essential servers such as CMS, File repository servers (FRS) and CMS Database


Figure 8: Source: SAP

You shut down at non-essential processes by running process explorer or task manager

Figure 8 shows command line column section in task manager – look at the command line to make sure which process to “kill”.

If you still see any BI4 platform related process or sub processes besides CMS, Input FRS and Output FRS, terminate them.  This doesn’t include Tomcat and the CMS  database processes with BI Platform.

Downtime can be expensive, and error-prone

Symptoms of failure – when a patch fails, several files are left in the packagestemp folder.  The install log will show “install failure”

What’s New

SAP has listened to customers about distributed system patching.

The deployment order has changed for distributed systems with a concept called Parallel Patching.  This technology is in BI 4.0 SP5 and after and can even be applied to a mix of platforms.


Figure 9: Source: SAP

Figure 9 shows you update the CMS and then update the rest.


Figure 10: Source: SAP

Foroohar said to wait for all machines updating in parallel to finish before proceeding to the next step.

During the process, at least one CMS machine should be running.

He said you should not be running any additional installation, maintenance processes.

Then once all the updates have finished, restart the servers.

Then repeat the process for every product that is installed on the machines in the cluster such as BusinessObjects Explorer and the client tools.

References provided by SAP:

Part 2 will cover planned improvements and question & answer – see BI4 Patching & Best Practices: Improving BI Support Process – Part 2 ASUG Webcast Q&A


Join ASUG June 2nd for ASUG Annual Conference BI4.1 pre-conference session: Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session – Back and Better than Ever

BI 2014 has sessions too covering this topic.

Upcoming ASUG BI Webinars – February 26, 2014

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply