Skip to Content
Technical Articles

SAP BusinessObjects BI 4.2 SP08 (SAP BI 4.2 SP8) Released!

Source: Webi4Me

SAP BusinessObjects 4.2 SP08 Released

February 24th, 2020

Oh well I had this all planned for a Feb 14th release and ready to wish you all a Happy Valentines’s Day 😊 but that wasn’t meant to be.

Nearly a year after the release of SAP BI 4.2 SP07, I’m happy to announce today the latest Service Pack aka Support Package for SAP BI 4.2 – version

Released few days late according to the Q1 2020 Maintenance Schedule:



Source: Maintenance Schedule

Previous SAP BI 4.2 Support Pack releases:

  • December 2017: SAP BI 4.2 SP05

What was released?

The usual suspects were released for a fresh Installation or Support Package:

  • SBOP BI Platform 4.2 SP08 Server
  • SBOP BI Platform 4.2 SP08 Client Tools
  • SBOP BI Platform 4.2 SP08 Live Office
  • SBOP BI Platform 4.2 SP08 Integration for SharePoint
  • SBOP BI Platform 4.2 SP08 NET SDK Runtime
  • SAP BusinessObjects Dashboards (Xcelsius) 4.2 SP08
  • SAP BusinessObjects Explorer 4.2 SP08
  • SAP Crystal Server 2016 SP08
  • SBOP BI Platform 4.2 SP08 Crystal Reports for Enterprise
  • SAP Crystal Reports 2016 SP08

What’s New?

This is hopefully not coming as a surprise as it has been mentioned several times over the last few months but this Service Pack is not including new features.  We are now in SAP BI 4.3 territory!

This update is about keeping the BI 4.2 lights on a bit longer by fixing bugs and adding few extra things to the PAM.

  • More from SAP:

What’s New

  • LinkedIn Community:


Download Location

These packages are available from Software Downloads

Also see SAP Note 2896442

In my case, that’s a good old 12.5 GB download!


Installing / Upgrading – How did it go?

My test environment is running on an AWS EC2 t2.xlarge.  That’s 4 Cores and 16GB RAM.

I have the following installed in SAP BI 4.2 SP07 with 3x Languages: English, French and Finnish.

  • Installation: Well it took probably more time as always to unzip everything but all in all (without testing) it took about half day to patch everything.  It well smoothly except for this .NET error but everything I have tested so far works.

  • Results:


The usual documents have been made available on the SAP Help Portal:

  • SAP BusinessObjects BI Platform 4.2 SP08 Installation Guide



  • More Documents

BI Platform (SAP Help Portal)

SAP Analytics (SAP Help Portal)

Product Availability Matrix (PAM)

(Supported Platform)

Release to Customer (RTC): 13.11.2015

General Availability (GA): 08.03.2016

End of Mainstream Maintenance: 31.12.2022

End of Priority One Support Phase: 31.12.2024

  • URLs:

SAP BusinessObjects BI 4.2 Supported Platforms (PAM)

Product Availability Matrix | SAP Support Portal

  • Important:

Expiry of SAP BI 4.1 (Priority One Maintenance) on 31/12/2020 (PAM)

Expiry of SAP BI 4.2 SP06 in February 2020: BI 4.2 Support Pack End of Life Dates

Additions to the Relational Data Sources:

Amazon EMR 5.20 Hive (Hive2) 2.3.4
Amazon EMR 5.20 Hive (Hive2) 2.3.4
HP Vertica 9.2
HP Vertica 9.2
Microsoft Excel * 2019
Microsoft Access * 2019
Microsoft SQL Server 2017
Oracle Oracle Database 19c
Oracle Oracle Database 19c
Oracle Oracle Database 19c
Oracle Oracle Exadata Database Machine * 19c
Oracle Oracle Exadata Database Machine * 19c
Pivotal Greenplum* 6.0
Pivotal Greenplum* 6.0
PostgreSQL PostgreSQL 11
PostgreSQL PostgreSQL 11
SAP NW BW * 7.5 SP15
SAP NW BW * 7.5 SP15
Snowflake Snowflake N/A
Snowflake Snowflake N/A

Maintenance Schedule – What’s Next?

  • SAP BI 4.2 SP07:

11.03.2020: SAP BI 4.2 SP07 Patch 9 (

24.04.2020: SAP BI 4.2 SP07 Patch 10 (

06.06.2020: SAP BI 4.2 SP07 Patch 11 (

Week 31 (July): SAP BI 4.2 SP07 Patch 12

Week 39 (September): SAP BI 4.2 SP07 Patch 13 (last one)

  • SAP BI 4.2 SP08:

10.04.2020: SAP BI 4.2 SP08 Patch 1 (

08.05.2020: SAP BI 4.2 SP08 Patch 2 (

Week 26 (June): SAP BI 4.2 SP08 Patch 3

Week 32 (August): SAP BI 4.2 SP08 Patch 4

Week 38 (September): SAP BI 4.2 SP08 Patch 5

Week 44 (October): SAP BI 4.2 SP08 Patch 6

Week 50 (December): SAP BI 4.2 SP08 Patch 7

Source: Maintenance Schedule

What’s Next… Next!?

Since it was announced at #SAPPHIRENOW 2018 and in my blog back in June 2018, a lot has happened with SAP BI 4.3.

“Early” BETA has come and gone back in late 2019.

“Standard” BETA is still ongoing and scheduled to close at the end of February 2020.

This is what we know about the roadmap so far:

SAP BusinessObjects BI 4.3:

Q4 2019: SAP BI 4.3 (RTC) – “Early” and “Standard” BETA

Q2 2020: SAP BI 4.3 (GA)

Q4 2020: SAP BI 4.3 SP01

Source: Webi4Me

Source: SAP


As planned, not a significant release.  Just bug fixes and minor updates to the PAM.

Except… It took me couple of weeks to notice that Snowflake is now supported!  I thought we’d have to wait for SAP BI 4.3.  Great #geeky news!

I have written a blog on how to make it work:

Looking forward to SAP BI 4.3 General Availability (GA) hopefully in Q2 2020!

Keep in Touch!

Hope this blog was useful.   Please do share your thoughts and comments.

Feel free to “like” and post it on social media!

Always happy to connect:

Take care… A+


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

    we installed 4.2 SP 08 and we find out the  following issue:

    If you are using variables in the datafoundationlayer(.dfx)  coming from HANA as input parameters, and prompt to User is not activated, these prompts will not be mentioned in the script which is been used for generating the report in Webi. So the output of the report is not correct then.

    So if you want that all the variables will be taken in your report you have to activate prompt to user.

    In 4.2 SP 6 this was not a problem.

      • Patrick,

        I would like to know if BOE XI 4.2 SP8 can use SQL Server 2019 as a Reporting Data Source. The PAM guide page 24 on Data Access doesn’t include anything on SQL Server 2019. The last updated on those excel files were Feb 2020. Please confirm if BOE XI 4.2 SP8 can connect to SQL Server 2019 for Universe Connection, Crystal Reports, Web Reports etc.




        Julliet L

        • Hello Julliet,

          I can confirm that it works.  I have been using MS SQL Server 2019 since SAP BI 4.2 SP07 actually.  No problems.

          But there is a difference between working and supported of course.

          What is interesting is that if you look at slide 19 of the PAM.  It does state that you can use MS SQL 2019 for the CMS DB and Audit DB.

          But indeed slide 24, no attachments refer to MS SQL Server 2019.

          I wonder if this is an error because BI 42-SL PAM – v1_1.21_SP8.xlsx states that MS SQL Server 2017 was added in BI 4.2 SP06 (correct) but again (ok a different driver) in BI 4.2 SP08.  Maybe it’s meant to say 2019…

          Only SAP can confirm (or not) what the exact support is.  And then they will amend the PAM.

          If there is no mistake, it looks like you’ll have to wait for either SAP BI 4.2 SP09 (as of now no scheduled date) or SAP BI 4.3 I guess.

          • So if we use IDT what is the driver type we should be using for Universe Connection Creation (JDBC 8.2) and what was the configuration that you used in the sqlsrv.sbo file to indicate that’s its SQL 2019. Example



            <DataBase Active=”Yes” Name=”MS SQL Server 2017″>
            <!–   Uncomment and edit the following lines
            to define java classes required by JDBC driver
            &amp;lt;Path&amp;gt;your jar or class files directory&amp;lt;/Path&amp;gt;
            <Parameter Name=”JDBC Class”></Parameter>
            <Parameter Name=”URL Format”>jdbc:sqlserver://$DATASOURCE$;DatabaseName=$DATABASE$</Parameter>
            <Parameter Name=”Extensions”>sqlsrv2017,sqlsrv,jdbc</Parameter>
            <Parameter Name=”Force Execute”>Always</Parameter>
            <Parameter Name=”Driver Capabilities”>Query,Procedures,Cancel</Parameter>



            Or should we be using OLEDB Support

          • Hi,

            I used standard ODBC (32 and 64 bits).

            Then in IDT I selected MS SQL Server 2017 (although I use MS SQL Server 2019).

            Again: Not supported.  But it works.

  • Thanks for the information.  I’m considering an ‘upgrade’ from 4.1 SP3 to 4.2 by building a 4.2 installation and migrating objects from 4.1 into 4.2 using the 4.2 promotion management tool.  What SP level of 4.2 would you recommend please?

  • Hi Patrick, we havent been able to utilize Parallel queries with Snowflake connector. This works as expected when we use Generic ODBC connector to connect to Snowflake. Is there a setting specific for Snowflake connector that we need to update please.

    Note that we have tested with same report, Universe and server. Only changed connection to use ODBC vs Snowflake Connector.


    • Hello Nilim,

      I saw your email from Scott 🙂 I replied already, he will send it over.  But for the benefit of others:

      First I mentioned your concerns about parallel queries to Gregory BOTTICCHIO (Director, Analytics Product Management at SAP) and he confirmed that drivers and the processes running queries should be unrelated.  Ie Snowflake or other technologies shouldn’t make a difference.

      I have personally tested today running a Webi with 5 Queries.  Each reading 100k rows.  See below:

      All 5 Queries started at the same time.  FYI The last one was quick as it was already cashed of course.

      Hope that helps.  If you have further concerns you should raise a support ticket with SAP.

      Take care.

  • Hi.  I’m installing 4.2 SP08 into a 4 host environment (two app hosts which will be a single cluster and two BO web app).  I’ve installed BIP servers on one host and wonder if I can  install the web tier on a web app host or if I need to install the BIP servers onto the second app host first?

    Also (sorry…) the web tier installation documentation states to select a CMS name but I took screenshots of the BIP server installation and the only name I was prompted to enter was the SIA name… Is the ‘CMS name’ simply the name of the host of BIP servers?

    Thanks for reading this far at least 🙂



    • Hi Steve,

      If I get this right, you want a cluster of Web Servers (2) and a cluster of App Servers (2).

      The first server you need to build is an App Server.  Then the order doesn’t matter.

      You can build the second App Server by doing an expand install.

      For the Web Servers, it will indeed ask you to enter the name of the CMS.  That’s the hostname of the server where the CMS reside.  Note your SIA name and Hostname may be different.

      Make sure you read the docs.  There are lots of small things to do when you cluster!

      I did a webinar not long ago that may help:  38 SAP BusinessObjects Tips And Tricks Every Administrator Should Know

      Good luck!


      • Hi Patrick!

        First, thanks for your time responding.  I really appreciate it.  Yes, you’re absolutely spot-on with the requirements.  I think I’ll go ahead and install the second app server using the same cluster key as the first.  I’ve found documentation which then states the cluster name can be updated on both servers by modifying the SIA ‘cluster name’ property.  Presumably I can then use this name in the web tier installations.  If you think otherwise and have a spare moment I’d really appreciate  your comment.

        Thanks again

        Warm regards,


        • Hi Steve,

          You’re welcome.

          When you install the second node using “expand” it will ask for your cluster key.  It’s the only way.

          Feel free to rename the cluster name.  I recommend it!

          But during the install of the webservers, it’s the hostname (server name) of the CMS you have to enter.  Anyway, it won’t allow you to continue of you put the wrong details.  No stress.

          I no longer do consulting (I work at 360Suite – we do software solutions for BOBJ – check us out!) but I can recommend good guys if you need help.  PM me if applicable.

          • Hi Patrick,

            Thanks very much again.  I’m just about to take a look at at the webinar you posted on youtube.  Thanks for sharing your knowledge and experience.

            Warm regards,



  • Hi Patrick,

    The install went well, thanks for your advice!

    Another question if you’ve time please.

    I’m looking to install the client tools on one of the app servers (there are two of these which form a cluster).  The install guide says ‘Ensure …All BI platform servers on the machine are stopped except the CMS and File Repository Servers (FRS)’.

    Do you know if i should do this activity on both app servers or just the one i’m installing the client tools into?

    Many thanks,