IBM Support

Unable to connect to a database to set up auditing: IPFTEST-006

Troubleshooting


Problem

Testing and Audit database connection added to Cognos Configuration fails with error:

[ ERROR ] IPFTEST-006 Logging failed to connect to Database

Symptom

Database login has been confirmed to be correct confirming this is not the issue.

Cause

The Cognos Analytics Server installation does not have the required JDBC driver to connect to the Audit Database.

Resolving The Problem

1. Stop the Cognos Analytics 11 server and close Cognos Configuration.
 
2. Place a copy or the JDBC driver for the type of database the Audit database is located into the <cognos_analytics_install>/drivers directory
 
  • Tip: If Cognos Analytics is using the same Audit database you can copy the JDBC driver from the <cognos_analytics_install>/drivers directory
3. Start Cognos Configuration and confirm the Audit database tests successfully.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.x, 11.1.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2022

UID

ibm10876786

Page Feedback