Troubleshooting
Problem
After installing IBM Rational Insight in a Linux environment, when you test the data source connections for products such as IBM Rational ClearCase and IBM Rational ClearQuest through the IBM Rational Insight report server, the connection does not pass through.
Symptom
Testing the data source connection fails and an error message similar to the following message is displayed:
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0569 Unable to load the driver manager library ( libodbc.so ).
UDA-SQL-0571 The operating system returned an error message ( libodbc.so: cannot open shared object file: No such file or directory ).
Cause
The ODBC driver and the system DSN are not properly configured for a Linux environment.
Resolving The Problem
You must configure the ODBC driver and the system DSN.
Search for the following files:
- Rational_Insight_installation_directory\dataconfig\odbc\odbc.ini
- Rational_Insight_installation_directory\dataconfig\odbc\odbcinst.ini
If the files exist, see the following link for instructions to configure your ODBC driver and system DSN.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m0/index.jsp?topic=/com.ibm.rational.raer.help.doc/topics/t_configodbcjdbc.html
If the files do not exist, follow the instructions given below to configure the ODBC driver and the system DSN.
Configure the ODBC driver
- Find the odbcinst.ini file corresponding to the driver manager installed on the target machine. Regardless of the installed driver manager, there is always an odbcinst.ini file. To locate this file for unixODBC, you can use the following command:
odbcinst -j - After locating the file, add the following text to it. The file starts and ends with an empty line.
Description =
Driver = {path of libratlxml.so}
Setup = {path of libratlxmlS.so}
MaxActiveStatements = 100
QueuingTimeout = 100000
DefaultPageSize = 1000
LibPath = {the path of jdbc directory}
Given below is an example:
[IBM Rational Insight XML ODBC Driver]Description =
Driver = /opt/ibm/RationalInsight/dataconfig/odbc/libratlxml.so
Setup = /opt/ibm/RationalInsight/dataconfig/odbc/libratlxmlS.so
MaxActiveStatements = 100
QueuingTimeout = 100000
DefaultPageSize = 1000
LibPath = /opt/ibm/RationalInsight/dataconfig/jdbc
Configure the system DSN
- Find the odbc.ini file for the driver manager installed on the target machine. Regardless of the installed driver manager, there is always an odbc.ini file.
- After locating the file, add the following text to it. The file starts and ends with an empty line.
[Driver = IBM Rational Insight XML ODBC Driver
DataSource = {DSN Name}
Description =
Configuration = {the path of corresponding data modle (.xdc) file}
Given below is an example using the Rational ClearQuest data source.
[ClearQuest]Driver = IBM Rational Insight XML ODBC Driver
DataSource = ClearQuest
Description =
Configuration = /opt/ibm/RationalInsight/dataconfig/configs/live data config/clearquest.xdc
Note: If you uninstall and reinstall Rational Insight, do not duplicate the same content in the odbcinst.ini and odbc.ini files.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21383429