This document is intended to provide a troubleshooting methodology which incorporates publicly available utilities to diagnose and resolve an issue identified within a specific use case. The use case will be presented as a scenario where an IBM Cognos Support Analyst is working with a client to diagnose and solve a particular issue.
The utilities mentioned in this document can be found at http://www.ibm.com/software/analytics/support/cognos_sdk.html.
Although the troubleshooting approach outlined is not IBM Cognos BI version specific, some of the diagnostic utilities used are. The version of the utility to be downloaded will be specific to the IBM Cognos BI version that is experiencing the issue.
Use Case Description
An administrator has two AIX environments, Development and Production, each running IBM Cognos BI version 8.4.1 and accessing a Teradata database for report data. On the Development environment all is working well but on the Production environment the administrator gets the following error when running a report.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection
Troubleshooting the Use Case
Each environment consists of a single server install with the following details:
- IBM Cognos BI version: 8.4.1
- Operating System: IBM AIX 6.1
- Query Database: Teradata
Both environments are configured to hit the same Teradata data source that is located on another server. The administrator has also confirmed that the same version of the Teradata ODBC driver has been installed on both AIX machines.
Error Message information gathering
In order to find information about this error and other potential messages in the cogserver.log file, the administrator downloads the IBM Cognos From Log Errors to Technotes Utility located at the following URL,
This utility will gather all the errors in the cogserver.log file and will quickly get information about an error by linking you to associated IBM Technotes.
The administrator finds out that the error he has might be caused as a result of the LIBPATH environment variable not pointing to the Teradata ODBC driver.
Comparing the differences between the 2 environments
The administrator decides to compare the differences between the two environments. In order to do this, the administrator uses the System Overview Diagnostic located at http://www.ibm.com/support/docview.wss?uid=swg24020682.
This utility gathers configuration settings, operating system versions and environment variables.
The administrator runs the utility on both environments. Once complete, the administrator then compares the log files from both environments. What the administrator finds out is that the LIBPATH environment variable for the Production environment did not contain the correct path to the Teradata ODBC driver.
The administrator then corrects the LIBPATH environment variable, restarts IBM Cognos 8.4.1 and retests. This time, the reports work without errors in both environments.
Dig deeper into Big data and analytics on developerWorks
Get samples, articles, product docs, and community resources to help build, deploy, and manage your cloud apps.
Tools, technologies, and software for building enterprise analytics solutions.
Software development in the cloud. Register today to create a project.
Evaluate IBM software and solutions, and transform challenges into opportunities.