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


To report this post you need to login first.

48 Comments

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

    1. Mahak Rathore 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

      (0) 
    1. Mahak Rathore 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

      (0) 
      1. Jawahar Konduru

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

        (0) 
    1. Mahak Rathore Post author

      HI Abdul,

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

      Regards,

      Mahak

      (0) 
        1. 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

          (0) 
  1. 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

    (0) 
    1. Mahak Rathore 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

      (0) 
  2. 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?

    (0) 
    1. Mahak Rathore 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

      (0) 
  3. 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…?)

    (0) 
    1. Mahak Rathore 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

      (0) 
  4. 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

    (0) 
    1. Mahak Rathore 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

      (0) 
  5. RAJAVELU KANDASAMY

     

    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

    (0) 
    1. Mahak Rathore 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

      (0) 
  6. 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

    (0) 
  7. 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

    (0) 
  8. 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.

    (0) 
  9. Praveen Chukka

    Hi Mahak,

    I was trying to download the script and i get the below error message. Can you please grant me access to it? Thanks in advance

    Access to share has expired

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

     

    -Praveen

     

     

    (1) 

Leave a Reply