Technical Articles
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 – https://launchpad.support.sap.com/#/softwarecenter
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
@RolandKramer
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?
Hello
You can find the latest SQLAnwhere Client for X86_64 here
- Download SQL Anywhere Client 17.0 SP0 PL20 Build 3399
Best Regards Roland
Hi,
there is a new KBase describing a more simple solution here:
2509148 - How to recreate SQL Anywhere service for BI 4.2 Enterprise
https://launchpad.support.sap.com/#/notes/0002509148
Regards,
Harald
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
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 12.0.1.4134 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
Federico
Hi,
no worries, just update the BOE server as everything needed comes with it ...
Best Regards Roland
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>:
Hello Walter
I would assume "repairing" is different from "creating" ...
Best Regards Roland