Rational Insight 1.0.1.1 dataware house problem
Hi,
I have installed the Rational Insight 1.0.1.1 version in Linux box and trying to configure the RIDW database in "IBM Cognos administration" but I am getting the error message as
An exception was encountered when block "parse_connect_string" was executed.
Not sure what was wrong?
First time I got the page loaded and got the connection error as below message
-------------------------------------------
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 ( libdb2.so ).
UDA-SQL-0571 The operating system returned an error message ( libdb2.so: wrong ELF class: ELFCLASS64 ).
-----------------------------------
I copied the libdb2.so of 64 bit DB2 file to /opt/IBM/RationalInsight/cognos/bin directory as per the below technotes
https://www-304.ibm.com/support/docview.wss?uid=swg21340702
After that I am unable to get the dataware house configuration page. Getting as first error message. Does any one seen this error before. :?:
Thanks,
Om.
I have installed the Rational Insight 1.0.1.1 version in Linux box and trying to configure the RIDW database in "IBM Cognos administration" but I am getting the error message as
An exception was encountered when block "parse_connect_string" was executed.
Not sure what was wrong?
First time I got the page loaded and got the connection error as below message
-------------------------------------------
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 ( libdb2.so ).
UDA-SQL-0571 The operating system returned an error message ( libdb2.so: wrong ELF class: ELFCLASS64 ).
-----------------------------------
I copied the libdb2.so of 64 bit DB2 file to /opt/IBM/RationalInsight/cognos/bin directory as per the below technotes
https://www-304.ibm.com/support/docview.wss?uid=swg21340702
After that I am unable to get the dataware house configuration page. Getting as first error message. Does any one seen this error before. :?:
Thanks,
Om.
4 answers
Hi,
I have installed the Rational Insight 1.0.1.1 version in Linux box and trying to configure the RIDW database in "IBM Cognos administration" but I am getting the error message as
An exception was encountered when block "parse_connect_string" was executed.
Not sure what was wrong?
First time I got the page loaded and got the connection error as below message
-------------------------------------------
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 ( libdb2.so ).
UDA-SQL-0571 The operating system returned an error message ( libdb2.so: wrong ELF class: ELFCLASS64 ).
-----------------------------------
I copied the libdb2.so of 64 bit DB2 file to /opt/IBM/RationalInsight/cognos/bin directory as per the below technotes
https://www-304.ibm.com/support/docview.wss?uid=swg21340702
After that I am unable to get the dataware house configuration page. Getting as first error message. Does any one seen this error before. :?:
Thanks,
Om.
The AIX technote that you reference does not apply to Linux. On AIX, the DB2 library is shared for both 32 bit and 64 bit. The same is not true on Linux. There are separate libraries for 32 and 64 bit.
The error that you are seeing is likely due to the fact that a 32 bit executable is trying to load a 64 bit library (DB2).
Did you install the database client on your Linux server? This is needed.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=/com.ibm.rational.raer.install.doc/topics/t_install_enterprisereporting_dw_rhel5.html
I recently installed Insight 1.0.1 (not sure if the same applies since you're on 1.0.1.1) on a 64 bit Linux server with DB2, and found that I needed to point to the 32-bit Linux drivers.
In the step titled "Installing the DB2 client libraries for Cognos" in this link - http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=/com.ibm.rational.raer.deploying.doc/topics/t_postreq_repserver_db2_instauto_cmseparate_rhel5.html - it says to use either the 32-bit library or 64-bit library, but as I mentioned, I found that I needed to use the 32-bit DB2 library even though I'm on a 64-bit system.
In the step titled "Installing the DB2 client libraries for Cognos" in this link - http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m1/index.jsp?topic=/com.ibm.rational.raer.deploying.doc/topics/t_postreq_repserver_db2_instauto_cmseparate_rhel5.html - it says to use either the 32-bit library or 64-bit library, but as I mentioned, I found that I needed to use the 32-bit DB2 library even though I'm on a 64-bit system.
I have installed the DB2 client in my Rational Insight report server.
I have done the below steps to fix the problem
------
cd to /etc/ld.so.conf.d that contained various text files. For example, the mysql-i386.conf file contained /usr/lib/mysql. I added a file named db2.conf and put the path /opt/ibm/db2/V9.5/lib32 in there, then saved the file. I then ran the ldconfig command (doing all this as root). Then I restarted the Cognos server (I don't know if that was necessary), and tested the connection. This time it succeeded!
--------
Now I am getting another error that provided the password is incorrect. It is trying to find the rptuser id and password.
I forgot the rptuser default password. Can any one remember what is the default password of rptuser. Some thing like "rat10nal".
Can any one tell me the exact password.
Thanks,
Om.
I have done the below steps to fix the problem
------
cd to /etc/ld.so.conf.d that contained various text files. For example, the mysql-i386.conf file contained /usr/lib/mysql. I added a file named db2.conf and put the path /opt/ibm/db2/V9.5/lib32 in there, then saved the file. I then ran the ldconfig command (doing all this as root). Then I restarted the Cognos server (I don't know if that was necessary), and tested the connection. This time it succeeded!
--------
Now I am getting another error that provided the password is incorrect. It is trying to find the rptuser id and password.
I forgot the rptuser default password. Can any one remember what is the default password of rptuser. Some thing like "rat10nal".
Can any one tell me the exact password.
Thanks,
Om.
Hi,
I have configured the unixODBC and trying to run the "isql -v RQM_Live" then getting below error
SQL1013N The database alias name or database name "RQM_LIVE" could not be found. SQLSTATE=42705
ERROR: Could not SQLConnect
Here is the odbc.ini file configuration
Driver = IBM Rational XML ODBC Driver
DataSource = RQM Live
Description =
Configuration = /opt/ibm/RationalInsight/etl/configs/live data config/rqmlive.xdc
and Here is the odbcinst.ini file configuration
Description=
Driver=/opt/ibm/RationalInsight/etl/odbc/libratlxml.so
Driver64=/opt/ibm/db2/V9.7/lib64/libdb2.so
Setup=/opt/ibm/RationalInsight/etl/odbc/libratlxmlS.so
Setup64=/opt/ibm/db2/V9.7/lib64/libdb2.so
LibPath=/opt/ibm/RationalInsight/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
Threading=0
UsageCount=2
#jdbclogpath=/tmp/jdbc.log
#Debug=/tmp/odbc.log
Is any thing I am missing?
Thanks,
Om.
I have configured the unixODBC and trying to run the "isql -v RQM_Live" then getting below error
SQL1013N The database alias name or database name "RQM_LIVE" could not be found. SQLSTATE=42705
ERROR: Could not SQLConnect
Here is the odbc.ini file configuration
Driver = IBM Rational XML ODBC Driver
DataSource = RQM Live
Description =
Configuration = /opt/ibm/RationalInsight/etl/configs/live data config/
and Here is the odbcinst.ini file configuration
Description=
Driver=/opt/ibm/RationalInsight/etl/odbc/libratlxml.so
Driver64=/opt/ibm/db2/V9.7/lib64/libdb2.so
Setup=/opt/ibm/RationalInsight/etl/odbc/libratlxmlS.so
Setup64=/opt/ibm/db2/V9.7/lib64/libdb2.so
LibPath=/opt/ibm/RationalInsight/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
Threading=0
UsageCount=2
#jdbclogpath=/tmp/jdbc.log
#Debug=/tmp/odbc.log
Is any thing I am missing?
Thanks,
Om.