Skip to Content
Author's profile photo Former Member

[Version-2] Clean-up Utility for manually remove SAP Business Intelligence (BI) 4.0/4.1/4.2 for Windows [How to remove SAP Business Intelligence (BI) 4.0/4.1/4.2 Manually from Windows Server]

Hi Everyone,

 

 

There have been situations where we may need to remove SAP Business Intelligence (BI) 4.0/4.1/4.2 from the Server machine and you may be not able to remove it from PROGRAMS AND FEATURES or clean the registries etc.

 

Below are the possible reasons when you wanted to remove BI :

  • Installation went wrong or terminated and you wanted to do a fresh install again.
  • Unable to remove the product from Programs and features of Windows Control Panel.
  • Due to binary corruptions of BI Server like Install Data Problems, Corrupted etc.
  • You have installed many service packs updates / patches and you wanted to clean it and install only targeted pack.
    • For Example : BI 4.0 SP6  (Full Build) >updated> BI 4.0 Sp12 >updated> BI 4.1 Sp6 >updated> BI 4.1 Sp6 Patch3 >updated> BI 4.1 SP7 and you wanted to remove BI and install only BI 4.1 Sp7 (Full Build) on the server to save disk space. etc

 

We use KBA : 1691555 – How to manually remove SAP Business Intelligence (BI) 4.0/4.1/4.2 Manually from Windows Server to remove it and performing the KBA very precisely and accurately is one of the important point. So I have create a Script (Batch +vbs) which we will do the job automatically and it will be Cleanup Utility for BI.

 

 

 

WHAT’s New in Version-2 :

  • It will remove the Server Intelligence Agent Service to avoid problem in next install with SIA Name.

 

Products will be removed :

 

  • This script will remove all the product associated with SAP BI with Add-on or Component installed on the server where script is running.
    • SAP BusinessObjects Business Intelligence Platform 4.0
    • SAP BusinessObjects Business Intelligence Platform 4.1
    • SAP BusinessObjects Business Intelligence Platform 4.2
    • Crystal Reports 2011
    • Crystal Reports 2013
    • Crystal Reports 2016
    • SAP BusinessObjects Explorer , Data Services, Live Office or any Add-on which is associated with SAP BusinessObjects
    • SAP BusinessObjects Business Intelligence Platform Clients Tools (If Present on Server)
  • If you are using CUSTOM Database present on another server it will not affect it and do any operation on it. Same is applicable for the FILE-STORE on Network Location.
  • If you are using Distributed or Clustered combination it will not affect other system. It will remove the content on the local server where the script is executed.

 

 

Pre-requisites :

  • Take the backup of the necessary files/customizations present in <InstallDirectory>\SAP BusinessObjects\SAP BUsinessObjects Enterprise XI 4.0\ .
    • Default Filestore : <InstallDirectory>\SAP BusinessObjects\SAP BUsinessObjects Enterprise XI 4.0\Filestore (OPTIONAL and Asked in theScript)

6.JPG

    • Default Database (If using SQL Anywhere) : <InstallDirectory>\SAP BusinessObjects\sqlanywhere\database

5.JPG

    • Default Tomcat : <InstallDirectory>\SAP BusinessObjects\Tomcat
  • Stop all the services if you are cleaning a running SAP BI 4.x

2.JPG

  • Check if any process is running in the task manager and kill if present related to Business Objects.

/wp-content/uploads/2016/04/4_931318.jpg

/wp-content/uploads/2016/04/3_931319.jpg

  • Ensure you have Administrator rights as this will clean registries and files under Windows\Installer folder.

 

 

Finally Remove BI

 

  • Extract the two files #RemoveBI.bat and #CleanupBI.vbs into any folder.

1.JPG

  • Open Command Prompt in Elevated Mode (Administrator)

7.JPG

  • Run RemoveBI.bat and it will ask you to continue.

8.JPG

9.JPG

  • It will ask you to take the backup of Default File Store If you have already taken the backup hit N or if you wanted  to take backup hit Y. Here I have used option YES = Y.
  • Then it will ask you for the DRIVE where you wanted to take the backup. Example : E: , F: , etc. Here I have use C:  Drive to take the backup.

 

11.JPG

 

/wp-content/uploads/2016/04/12_931335.jpg

  • After completion of Backup it will automatically start to DELETE the services for Default Tomcat, SQL Anwhere Service, Subversion ( If present if not then exception of error is acceptable since the service will not there)
  • It will Automatically detect the INSTALLATION FOLDER of SAP BI and start deleting it.

/wp-content/uploads/2016/04/15_931336.jpg

  • Now it will take the backup of the FULL Registry and place it in the USERS Profile. After that it will start to delete the Registry Keys for “SAP BusinessObjects”.

/wp-content/uploads/2016/04/16_931358.jpg

  • Once Completed it will start to Remove the Files associated with BI in <osdrive>\Windows\Installer

17.JPG

  • Next and Final Step to remove all the Registries from the computer associated with BI in Current users and Local Machine. IT MAY TAKE A WHILE

/wp-content/uploads/2016/04/18_931360.jpg

    • Don’t worry about the “ERROR : The system was unable to find the specified…” message it is to cross check in loop if the registry is deleted or not.
  • Once the script is completed Simply reboot the server and you have a fresh machine of windows server where bi was not installed.

19.JPG

============================================================================================================

============================================================================================================

Disclaimer : This script is the property of SAP and should not be used in any form commercially. Free for non commercial use only redistribute is forbidden. This script to help the customer and in case of any issues SAP or I will not be responsible any damage or unusual behaviour of script.

 

 

Cheers,

Mahak Rathore

Sign.jpg

 

Assigned tags

      56 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Toby Johnston
      Toby Johnston

      Looks useful Mahak!  Thanks for creating this.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Toby for Guiding and helping me.

      Regards,

      Mahak

      Author's profile photo Former Member
      Former Member

      Great work Mahak...This will be really useful for everyone.

      Author's profile photo Former Member
      Former Member

      Good work Mahak ....Keep it up

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      @swapnil and @vipin

      Thank you guys for your continues help and support.

      regards,

      Mahak

      Author's profile photo Former Member
      Former Member

      Great job Mahak! 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you so much Vaidehi 🙂

      Author's profile photo Swapnil Yavalkar
      Swapnil Yavalkar

      Sterling Job Mahak Rathore   Keep growing and sharing the knowledge 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks @Swapnil for this remarkable comment..

      Regards

      Mahak

      Author's profile photo Nachiket Sakore
      Nachiket Sakore

      Great Work Mahak!.... 🙂

      I had to do this Manually for PROD Server few Months back and I know how tedious it is!..

      Regards,

      Nachiket

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Nachiket for the appreciation. 🙂

      Cheers,

      Mahak

      Author's profile photo Tom Du
      Tom Du

      Outstanding piece of work! We had used this script and it worked wonderfully. Thanks Mahak.

      Cheers,

      Tom

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Tom,

      Thank you so much Tom .You are the first one to use it on LIVE environment and because of you we got the confidence to release it.

      As suggested I have added the Functions you have pointed :

      • Removing the registries for Programs and Feature in fact it will remove each registries related to SAP BI in Local Machine and Current User.

      Thanks a Ton for helping us.


      Regards,

      Mahak

      Author's profile photo Jawahar Konduru
      Jawahar Konduru

      Mahak,  Great job. Does this script also remove Lumira or Design Studio add-on?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Jawahar,

      Yes, Since the installation of these components in the Installation directory of SAP BusinessObjects and also the registries are also present in Software > SAP BusinessObjects and both of them are deleted when we run this.

      Ideally it will remove all Explorer, Data Service, Lumira , Design Studio, Live office etc

      Thank you for the appreciation. 🙂

      Regards,

      Mahak

      Author's profile photo Jawahar Konduru
      Jawahar Konduru

      Mahak, Suggestion for future reference. if the script can delete only some patches, instead of complete BI install, it will be helpful.

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai

      Just tried this in my Sandbox. Works like a charm! Nice work Mahak  🙂

      Thanks

      Mani

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Manikandan,

      Thank you for testing it and giving the much needed feedback. 🙂


      Best Regards,

      Mahak

      Author's profile photo Amit Mathur
      Amit Mathur

      Thanks Mahak for sharing this. Very useful information. Good one!

      Cheers,

      Amit

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Amit Sir for your valuable appreciation.

      Cheers,

      Mahak

      Author's profile photo Former Member
      Former Member

      Very detailed and informative..

      Thank you Mahak,

      Author's profile photo Former Member
      Former Member

      I wish I found this earlier, I had to do this on 80 systems manually 🙁

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Abdul,

      Next time your time will be saved for sure 😉 . But 80 is a 😯 I can understand the efforts.

      Regards,

      Mahak

      Author's profile photo Kuldeep Ghosh
      Kuldeep Ghosh

      Great work! Helped a lot.

      - Kuldeep

      Author's profile photo Shiva Vishnubatla
      Shiva Vishnubatla

      Great job Mahak. This will be extremely useful for heavily patched windows deployments.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Shiva for all your help and support to make this possible. 😳

      Cheers

      Mahak

      Author's profile photo Ravikumar Periasamy
      Ravikumar Periasamy

      Hi,

      I am not able to download the Scripts " REMOVE_BI_4" Please help me to share the  Scripts.

      Thanks,

      Ravi

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Ravikumar,

      Thank you for the updated. I have updated the link please try and let me know.

      Regards,

      Mahak

      Author's profile photo Ravikumar Periasamy
      Ravikumar Periasamy

      Thanks a lot Mahak, I am able to download now.

      Author's profile photo Ravikumar Periasamy
      Ravikumar Periasamy

      Hi Mahak,

      Do you have any scripts to download the " all reports, users, groups, etc" earlier we have one excel macro for 3.x to download all the information, but 4.x I don't have, if you any scripts like that please share with us.

      Thanks in advance..

      Thanks,

      Ravi

      Author's profile photo CHEIKH OMAR NIANG
      CHEIKH OMAR NIANG

      Hi Mahak,

      Thanks you a lot for the script and detailled instructions. I just applied in a SAP BI 4.1 SP7. It's working fine.

      Now I'm reinstalling SAP BI (same SP) in the server.

      My question is how to restore universe and report ? (I have a backup of filestore folder)

      Thanks,

      Cheikh

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Cheikh,

      For restoring the SAP Content you need CMS Database and Filestore and when restoring it ensure you restore it on the exact same version of BI.

      For step by step and Video check :


      1275068 - Backup and restore BusinessObjects Enterprise XI 3.x / BI 4.x system from one environment to another environment [video]

      Thank you for appreciation.

      Regards,

      Mahak

      Author's profile photo CHEIKH OMAR NIANG
      CHEIKH OMAR NIANG

      Thank you Mahak

      Regards,

      Cheikh

      Author's profile photo Former Member
      Former Member

      Excellent job Mahak! Very helpful stuff

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Shriraj 🙂

      Author's profile photo Brian Kudera
      Brian Kudera

      Hey Mahak, I performed the above steps, as well as running CCLEANER to clean up erroneous registry entries.

      When I reboot the server, the server is still trying to start the SIA. Why is this and now do I fully completely remove BI from the server so I can be sure I'm getting a clean install?

      Also after running the scripts, I still have files under <home>\SAP BusinessObjects Enterprise XI 4.0\win64_x64

      Is this expected or should I manually delete these before trying to reinstall?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Brian,

      Thank you for information.

      After running the script ideally all the folders should be deleted completely. If anything is opened (Example : SQL Anywhere Service, SIA is running etc ) it is unable to delete the folder since the folder is in use.

      One more important point SIA service you need to delete manually because the service is created by user and can be given anything which I will fix for automation.

      So perform below steps :

      • Stop everything related to BI.
      • Run script.
      • Check SAP BusinessObjects folder is delete completely.
      • Delete SIA service
      • Reboot the server.

      Now there would not be any issue.

      One more important thing. If you are doing a new install I have a good reference for installing the product smoothly . Do check : Step-by-Step Guide to install SAP BusinessObjects Business Intelligence (BI) platform 4.x on Windows OS with Best Practices (PART 1)

      Regards,

      Mahak

      Author's profile photo Brian Kudera
      Brian Kudera

      Mahak, upon running RemoveBI.bat in Admin mode, I see the error that it cannot find the file C:\Windows\System32\CleanupBI.vbs.

      Therefore I don't suspect the CleanupBI.vbs script is running.

      I tried to run the RemoveBI.bat file again to replicate the error, but the bat file won't execute any longer because part of the system was removed and so the :checkbi4 is terminating the script.

      Ideas on how to get this to run correctly? Through completion?

      (If I try to run just the VBScript on its own, I get a message that says:

      Deleting file C:\Windows\Installer\182162

      I click OK

      Then a script error occurs, File not found

      However, C:\Windows\Installer\182162 does exist...?)

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Brian,

      Ideally you should not get that error. If so they simply try to execute the section in the batch file for VBS.

      The last error :

      (If I try to run just the VBScript on its own, I get a message that says:

      Deleting file C:\Windows\Installer\182162

      I click OK

      Then a script error occurs, File not found

      However, C:\Windows\Installer\182162 does exist...?)

      It is correct actually the VBS is deleting the file and checking it again that it is deleted or not.

      In case you wanted to complete this section manually do the following :

      1. Go to <operatingsystemdir>\WINDOWS. ( For Example : C:\Windows\)
      2. Search for "Installer" directory and open the directory. If the directory is hidden then Enable Hidden Folder View from the Folder Option in Operating System.
      3. In the folder view, right click on the columns at the top and select "Author" to make that column visible.
      4. Cilck on the Author column to sort the files by Author.
      5. Delete all the files with "SAP Business Objects" as Author.

      Regards,
      Mahak

      Author's profile photo Andreas Hühn
      Andreas Hühn

      Hello,

      I have a cluster with 2 servers. A server must be reinstalled with BI 4.1 SP07. However, the 2nd to continue working. The FileStore is installed on a failover cluster. How do I customize the script to removebi.bat that I get no problems? The FileStore should not be edited. 😉

      Best Regards

      Andreas

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      HI Andreas,

      Yes, You can simply run this script on the problematic server which will remove the BI from that node.

      FileStore :

      You don't need to modify anything in the script. When you will run the script it will ask you take backup which is also for default filestore folder inside SAP BUSINESSOBJECTS folder i.e. installation drive. Simply Select "NO".

      Also, If your filestore is in network drive or on another drive it won't touch that.

      Regards,

      Mahak

      Author's profile photo Former Member
      Former Member

       

      Mahak,

      Thanks for this article.  As Andreas , we are also having same issue.  Binaries corrupted, need to re install on the servers in cluster.  based on above notes and discussion, I understand we don't have to do anything as FRS and CMD DB are on different servers. Please help me to clarify the following

      1. Node 1 is  running fine. we wont touch it. Corrupted node is node 2, we will be running the script on it.

      2. After running script on node 2, we will be installing the target version as in Node 1 ( BI 4.1 Sp6  and then patch 1)

      3. While installing, we will select option to add it to the existing cluster, question is .. what will happen to node 2 SIA information which is already present in CMS DB ?

      4. While running the cleanup script, will it remove node related entries in CMSDB ?

      5. Can we run the script on node 2 while node 1 is in use ? or we need to perform this activity during down time ?

      Thanks in advance  for your response !

      Raj

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Raja,

      Node 1 is  running fine. we wont touch it. Corrupted node is node 2, we will be running the script on it.

      2. After running script on node 2, we will be installing the target version as in Node 1 ( BI 4.1 Sp6  and then patch 1) This is Correct. You just need to install the target pack.

      3. While installing, we will select option to add it to the existing cluster, question is .. what will happen to node 2 SIA information which is already present in CMS DB ? When you are installing the product use default database and then install. If you select the existing one it will mess up the environment and you may loss the data if wrong options are selected.

      4. While running the cleanup script, will it remove node related entries in CMSDB ? Nope that need to done manually or once you will update the the SIA to the current database it will recreate the servers.

      5. Can we run the script on node 2 while node 1 is in use ? or we need to perform this activity during down time ? Yes, just ensure the Node 2 is completely stopped and run it will clean the product .Also, It will not delete IFRS and OFRS / will not delete anything from the database as they are on another server.

      Regards,
      Mahak

      Author's profile photo Michal Grigalis
      Michal Grigalis

      Hi
      Script is useful but in my case script deleted IPS but DataServces has been broken - only install files were removed - installation was kept untouched any impossible to remove...
      Best Regards
      Michal Grigalis

      Author's profile photo Swapnil Hoderkar
      Swapnil Hoderkar

      Hi Mahak,

      This script worked like a charm.

      Only thing i noticed is that it didnt remove SAP Lumira Desktop install.

      Keep up the good work.. Hope to see some more customized tools from you.

      Thanks,

      Swapnil Hoderkar

      Author's profile photo Abdul Ahmad
      Abdul Ahmad

      Can this work on Desktop? I tried to run it, and it gave me an error.

       

      failed to find a BO installation

      The system can not find the batch lable specified – end.

      Author's profile photo Glenn Dalton
      Glenn Dalton

      Hi Mahak

      Same message for me "Access to share has expired". Would appreciate your help to access.

      Thanks, Glenn

       

      Author's profile photo Youssef Najim
      Youssef Najim

       

      Hi Mahak,

      I got this:

      Access to share has expired

      Share is no longer available; contact the owner if you need access

      Author's profile photo John Clark
      John Clark

      I am getting the same message that Youssef is getting.  Can the script be made available again?

       

      Author's profile photo Prasenjit Roy
      Prasenjit Roy

      Hi Mohak,

       

      I have also received same message and can access the script.

       

      Regards,

      Prasenjit Roy

      Author's profile photo Shiva Vishnubatla
      Shiva Vishnubatla

      Hello Prasenjit, All looking for this script,

      The script is also available for download of the KBA : 1691555 – How to manually remove SAP Business Intelligence (BI) 4.0/4.1/4.2 Manually from Windows Server

       

      regards
      Shiva

      Author's profile photo Mahak Rathore
      Mahak Rathore

      Shiva Vishnubatla  Can you please update the script with Version 2 in KBA as the script attached to that KBA is Version.

       

      Regards,

      Mahak

      Author's profile photo Brian Kudera
      Brian Kudera

      Shiva Vishnubatla has Version 2 been made available?

      Author's profile photo Brian Kudera
      Brian Kudera

      Also need to be sure to manually stop WmiPrvSE.exe in Task Manager if you had SQLAnywhere installed before executing the script. The script will get stuck on this because of a dll file this program has locked.

      Author's profile photo Mahak Rathore
      Mahak Rathore

      Hi Brian,

       

      The updated script is not available on the KBA. If you want the updated one please send me the email id  I will forward the script.

      Thank you for the suggestion too. I will check if it is added.

      Regards,

      Mahak

      Author's profile photo Angel Davila
      Angel Davila

      Hey guys. Does someone have something like this for UNIX BOE (Linux / AIX / Solaris, etc)?

       

      Angel