IBM Support

** Troubleshooting ** 'Couldn't connect to source database. Check your settings' when testing source (inside FAP Client)

Technote (troubleshooting)


Problem(Abstract)

User launches the FAP Client ("IBM Cognos FAP"), and logs into a FAP database successfully.

User clicks tab "Sources", highlights an existing source and clicks "Edit".

User clicks "Test Connection". An error message appears.

Symptom

No connection
Couldn't connect to source database. Check your settings.
[OK]


Cause

There are several known causes for this message:

  • Scenario #1 - Limitation of Controller 10.2.x, when run on 64-bit device, if connecting to Oracle
  • Scenario #2 - (Rare) Issue occasionally seen when copying FAP databases between environments, where the password can only be successfully changed/saved directly inside the SQL database.

Resolving the problem

Scenario #1

Use the Microsoft .NET utility 'CorFlags.exe' to modify the file 'fapclient.exe' to change its bitness to be 64-bit.

Scenario #2 (rare)

In one real-life example, it was necessary to change the data source details (for example password) directly inside the SQL database table.

Steps:

1. Launch SQL Management Studio

2. Locate/expand the FAP database

3. Right-click on the table 'NRTR_SOURCE' and choose 'Edit top 200 rows'


4. Modify the relevant details (inside "Password" and "CCRDBUrl" manually"
5. Close the table, to commit the changes.

Related information

7-Zip download page

Document information

More support for: Cognos Controller
Controller

Software version: 10.2.0, 10.2.1, 10.3

Operating system(s): Windows

Reference #: 1403948

Modified date: 21 September 2009


Translate this page: