Skip to Content
Technical Articles
Author's profile photo Roland Kramer

SAP BI4.x Installation/Update/Patching

SQLANYs_SQLAnywhereForBI Repository is marked for deletion

During the process of De/Installing a Patch for the BOE/BI Platform 4.x SP03 or SP04 the Service and/or the connection to the Sybase Anywhere Repository SQLANYs_SQLAnywhereForBI is marked for deletion in the Windows Service Panel.

This causes a stall of the Deinstallation of the BI Patch, due to the fact that the SQL Anywhere Repository is shutdown and the Start/Service is removed.

You can solve the Problem with the usage of the SQL Anywhere Client, which has the capability to recreate the Service Entry in a Win64 based system again.

There is also a corresponding SAP Note available:
Note 2428625 – BI 4.x – SQLANYs_SQLAnywhereForBI marked for deletion

Download the current SQLAnywhere Client for the Service Market Place

Unpack with the ZIP file and run the setup excutable with the tailored option.

mark only the SQL Anywhere (64-Bit) and un-mark all other option, as they are not needed.

Once the setup is finished, start the SQL Central Client and navigate to the “SQL Anywhere 17” Folder on the left side and on the left side to the Tab Strip “Services”

If the Service SQLANYs_SQLAnywhereForBI is missing create the Service with the wizard with the right mouse click “new Service”

use the exact name which was used in the initial BI Platform Server Installation

choose the option “Network Database Server”

Point the dbsrv16.exe executable to the correct location were the BI Platform Installation is located, e.g. <LW>:\usr\sap\BI4\sqlanywhere\BIN64\dbsrv16.exe

Now this is the interesting part, as you have to specify the correct Parameters for the startup of the existing BI4 SQL Anywhere Database:

-n BI4 
-x tcpip(PORT=2638;DoBroadcast=NO;BroadcastListener=NO) 
-o "<LW>:\usr\sap\BI4\SAP BusinessObjects\sqlanywhere\database\BI4_log.txt"
"<LW>:\usr\sap\BI4\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" 
"<LW>:\usr\sap\BI4\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

Once the wizard is finished, the Service appears again in the Services Panel.

As a final step, you have to check the Dependency in the CMC Service, as the original Service was marked for deletion.

Now you can start the Server Intelligence Agent in the CMC again, as the dependencies are correct.

The BI Plattform Services including the SQL Anywhere Database are starting correct now and the Deinstallation of the Patch continues.

The problem hopefully is solved with the upcoming Patches for the BI 4.x Platform.

Note 2376106 – CMS won’t start after applying BI patch

Roland Kramer, PM EDW (BW/HANA/IQ), SAP SE

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Great plan to fix, unfortunately not possible because the suggested download is simply not available to standard BusinessObjects customer. How do I get this client?


      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author


      You can find the latest SQLAnwhere Client for X86_64 here
      - Download SQL Anywhere Client 17.0 SP0 PL20 Build 3399

      Best Regards Roland

      Author's profile photo Harald Anton Mueller
      Harald Anton Mueller


      there is a new KBase describing a more simple solution here:

      2509148 - How to recreate SQL Anywhere service for BI 4.2 Enterprise




      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hello Harald
      of course a three (command) line is easier, once you know it ... 😉

      dbsvc -t Network -s Automatic -as -sn "SQL Anywhere for SAP Business Intelligence" -sd "Provides the CMS repository and auditing database for SAP Business Intelligence" -y -w "SQLAnywhereforBI" "C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\bin64\dbsrv16.exe" -n BI4 -x tcpip(PORT=2638;DoBroadcast=NO;BroadcastListener=NO) "C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db"

      Best Regards Roland

      Author's profile photo Mauro Fallavollita
      Mauro Fallavollita

      Hi Roland,

      i hope you are still reaading the posts of this topic, i have a question for you that is not really clear to me.

      I have a BOBI 4.1 SP7 and recently we had e problem with the embedded SQL Anywhere and we need to patch it; my question is about the method of patching, do we need to patch the BO to update the SQL or we can apply a specific patch? if we can apply a patch just to SQL where i can find it in the marcketplace?

      Thnaks and regards


      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author


      no worries, just update the BOE server as everything needed comes with it ...

      Best Regards Roland

      Author's profile photo Walter Tran
      Walter Tran

      Just wanted to add that this happened to a client I was upgrading from BI 4.2 SP6 P2 to P4. The upgrade completed with warnings, but I'm going to re-run a repair once the DB is up again just to be safe.

      The SQL Anywhere parameters provided here/from the KBA aren't valid and would stop the DBs from starting. I had to drop the -o, and of course the <LW>:



      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hello Walter

      I would assume "repairing" is different from "creating" ...

      Best Regards Roland