IBM Business Analytics Diagnostics: Use Case: Data Retrieval

Product(s): IBM Cognos BI; Area of Interest: Infrastructure

This document describe troubleshooting method of an issue connecting to Teradata.

Share:

Business Analytics Proven Practices Team, Business Analytics Proven Practices Team, IBM

Business Analytics Proven Practices Team



28 March 2012

Also available in Russian

Introduction

Purpose

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.

Applicability

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,
http://www.ibm.com/support/docview.wss?uid=swg24028415.

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.

Conclusion

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.

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Big data and analytics on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=807194
ArticleTitle=IBM Business Analytics Diagnostics: Use Case: Data Retrieval
publish-date=03282012