IBM Support

Missing database connection choices when using Controller Web

Technote (troubleshooting)


Problem(Abstract)

User launches Controller Web (http://<servername>:9080/fcm.web/login). User modifies 'Datasource'.

User tries to choose/select one of their databases, but it does not appear.

Symptom

Example:

In one situation, there was only one database connection to choose from:

This was despite the fact that there were two separate database connections defined inside Controller Configuration, and two separate choices of databases when launching the main Controller client:


Cause

Controller Web had not been synchronised after creating new database connection(s).


Resolving the problem

Synchronize Controller Web with the current/existing ‘database connection’ UDL files by using the command SyncDBConf.bat


Steps:
1. Right-click on the ‘Start’ menu, and choose ‘Command Prompt (Admin)’

2. Type a command similar to: cd C:\Program Files\IBM\cognos\ccr_64\fcmweb

  • If you have installed Controller to a non-default location, then modify this accordingly.

3. Type the following command:
    SyncDBConf.bat ..\Data wlp\usr\shared\config\datasources

You should get a success message similar to:


4. Test:

Document information

More support for: Cognos Controller
Controller

Software version: 10.3

Operating system(s): Windows

Reference #: 1997329

Modified date: 17 January 2017