Troubleshooting Dedicated Consolidated Database Installation

These instructions are for situations where the procedure for installing a dedicated CDB was not followed in the initial installation resulting in the installation of Sybase Unwired Platform servers with unwanted CDBs attached.

The information about the primary CDB you do not want attached to the SUP installation must be removed from the cluster configuration data (clusterdb) so the SUP service entry can be rebuilt without the CDB dependency.

In this procedure you will remove the CDB in the initial SUP installation (machine A) from the clusterdb, then you will install SUP on a different machine (machine B) and add the new CDB to the existing cluster on machine A.

To remove the CDB from the clusterdb configuration on the initial Unwired Server installation (machine A):
1. Verify the SQLAnywhere database is running and that the clusterdb databases are active.
2. Go to the Unwired Server installation directory; for example, C:\Sybase\UnwiredPlatform-1_2\Servers\UnwiredServer and run updateProps.bat -x. The -x flag removes this installation from the cluster configuration data.
3. Run:
```
mlservice.bat remove
uadbservice.bat remove
```
Install Sybase Unwired Platform on the machine where you want to run the dedicated CDB (machine B). See Performing a Custom Installation in the Sybase Unwired Platform Installation Guide.
1. In Additional Installation Options, choose Select to specify cluster configuration options to add the new CDB to the existing cluster from the initial SUP installation on machine A.
2. Choose Select to run Unwired Server as a service to start Unwired Server automatically when Windows starts up.
  Note: Do not start the SUP servers on machine B at this point.
On machine A, shut down the SUP server, including the SQLAnywhere database.
Copy *.log and *.db from %SUP_Installation%\UnwiredServer\SQLAnywhere11 on machine A to the same location on the new installation on machine B, overwriting files that have the same name.
On machine B, open the Windows Service Manager and set these services:
1. Open the Windows Control Panel and click Administrative Tools > Services.
2. Find SybaseUnwiredPlatform<clustername>Server<number> and set it to Disabled:
  1. Open Services.
  2. Right-click the service that you want to enable or disable, and then click Properties.
  3. On the Log On tab, click the profile that you want to configure, and click Disable.
  4. Click OK.
3. Find SybaseUnwiredPlatform<clustername>Database<number> and set it to Autostart.
Start the database service.
On machine A, use a text editor to open the sup.properties file, and set sqlany.mode=none. Delete the property sqlany.serverport entirely. This disables the local CDB.
Run config.bat. This adds the initial installation on Machine A back into the cluster. Since the Machine B CDB is already registered, the CDB on Machine A is not added back and its dependencies are removed.