How to use existing CMS database while installing BI 4.1 using the Custom on Windows

Install SAP BusinessObjects Business Intelligence 4.1 using existing CMS database using Custom/Exapnd installation option on Windows server SAP BusinessObjects BusinessIntelligence 4.1 installer does not give any option to select existing CMS database while choosing install type Custom/Expand. Follow these steps to get CMS database option:- Run Installer with Administrator Check Custom/Expand Install Type Select Destination Folder On next screen, expand Server list and uncheck Sybase SQL Anywhere Database. Proceed with the installation and you will get screen to select our existing database.

How to do Silent install on Windows Business Objects / BO / BI 4.1

We can use silent install normally as mentioned in installation guide:-
https://websmp102.sap-ag.de/~sapidp/011000358700000171092014E/sbo41sp3_bip_inst_win_en.pdf (Page 39)


Steps:-# Open Command prompt with Administrator
# Go to BI setup from cmd.
# Run command setup.exe -w "c:\Test.ini"
# Installer will give you GUI option to select, please select all options for Oracle database and start it.
# Installer will disappear after start screen.
# Open Test.ini file and make changes in password fields, Cluster keys, Product key.
# Install product again with Test.ini file by running command setup.exe -r "c:\test.ini".

Steps that got on to my ini file

### Choose to Integrate Introscope Enterprise Manager: integrate or nointegrate

chooseintroscopeintegration=nointegrate

### Choose to Integrate Solution Manager Diagnostics (SMD) Agent: integrate or nointegrate

choosesmdintegration=nointegrate

### CMS cluster key

clusterkey=********

### CMS administrator password

cmspassword=********

### CMS connection port

cmsport=6400

### Existing Auditing DB password

existingauditingdbpassword=********

### Existing Auditing DB server

existingauditingdbserver=*******

### Existing Auditing DB user name

existingauditingdbuser=****************

### Existing CMS DB password

existingcmsdbpassword=********

### Existing CMS DB reset flag: 0 or 1

existingcmsdbreset=0

### Existing CMS DB server

existingcmsdbserver=*************

### Existing CMS DB user name

existingcmsdbuser=*****************

### Installation Directory

installdir=E:\Program Files (x86)\SAP BusinessObjects\

### Choose install type: default, custom, webtier

installtype=custom

### Introscope Enterprise Manager Hostname

introscope_ent_host=$IntroscopeAgentEnterpriseManagerHost

### Introscope Enterprise Manager Port Number

introscope_ent_port=$IntroscopeAgentEnterpriseManagerPort

### Choose install mode: new, expand

neworexpandinstall=new

### Product Keycode

productkey=********

### Language Packs Selected to Install

selectedlanguagepacks=en

### Setup UI Language

setupuilanguage=en

### SIA node name

sianame=Whatsapp51

### SIA connector port

siaport=6410

### SMD Agent Hostname

smdagent_host=$SMDAgentHost

### SMD Agent Port Number

smdagent_port=$SMDAgentPort

### Auditing Database Type

usingauditdbtype=oracle

### CMS Database Type

usingcmsdbtype=oracle

### WACS port

wacsport=6405

### Available features

### ------------------

### root

###   WebTier

###     JavaWebApps1

###     MobileServices

### MobileServers

###       MobileAddon

### IntegratedTomcat

###   Servers

### PlatformServers

###       CMS

###       FRS

### PlatformServers.IntegratedDB.SQLAnywhere

### PlatformServers.EventServer

### PlatformServers.WebAppContainerService

### AdaptiveProcessingServer

### AdaptiveJobServer

### Platform.RestWebService

### Platform.Action.Framework.backend

###       Subversion

###     ConnectionServices

### ConnectionProcService

### DataFederatorServices

How to Delete a Service in Windows

If you are a fan of tweaking your system and disabling services, you might find that over time your Windows Services list becomes huge and unwieldy with a large number of services in the list that will never be enabled.

Instead of just disabling a service, you can alternatively completely delete the service. This technique can be especially helpful if you’ve installed some piece of software that doesn’t uninstall correctly, and leaves an item in the service list.

Important Note: Once you delete a service, it’s gone, and it’s going to be a pain to add it back. Use with caution.

Deleting a Service

The first thing you’ll need to do is identify the name of the service, so open up Services through the start menu or control panel, and then find the service in the list that you want to delete.

You’ll want to open up the properties by double-clicking on the service name, and then highlight the “Service name” value and copy it to the clipboard. This is what we’ll need to disable it.

You’ll need to open up a command prompt, and if you are using Windows 7 or Vista you’ll need to right-click the command prompt and choose Run as Administrator. We’ll use the sc command to actually do the work.

The syntax used to delete a service is this:

sc delete ServiceName

If your service name has spaces in it, you’ll need to wrap the service name in quotes, like this:

sc delete “Adobe LM Service”

Note that I’m not recommending deleting this particular service, it’s just an example.

Now if you use the F5 key to refresh your Services list, you’ll see that the service is gone.

I’ve found that using this technique (carefully) can make your Services list a lot more useful, since you don’t have to weed through dozens of items you will never have enabled.

Source: http://www.howtogeek.com/howto/windows-vista/how-to-delete-a-windows-service-in-vista-or-xp/

How to kill hanged services in Windows

Not all the services you will be able to kill from Task Manager. Some services still run even though if you uninstall or disable them

A hanged service looks like the below screenshot example (as you can see below, all Start/Stop/Pause/Resume buttons are disabled):

To kill this service, first note the service name. On the screenshot above, it is ‘Business View Manager’ (ie: the first thing displayed in the “General” tab).

Then, open a command Prompt and run the ‘sc queryex’ command to retrieve the service PID, then use the ‘taskkill’ command to… well, kill it ! (as below)

C:\>sc queryex Business View Manager   SERVICE_NAME: Business View Manager TYPE               : 10  WIN32_OWN_PROCESS STATE              : 2  START_PENDING (NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN))   WIN32_EXIT_CODE    : 0  (0x0) SERVICE_EXIT_CODE  : 0  (0x0) CHECKPOINT         : 0x1 WAIT_HINT          : 0xbb8 PID                : 3756 FLAGS              :   C:\>taskkill /PID 3756 /F SUCCESS: The process with PID 3756 has been terminated. Note: Be careful of what you are killing though.  If you kill a critical windows service you may end up forcing the machine to reboot on it own.