Error while configuring RQM Live Reporting
Hello Team
I am getting error while configuring the RQM Live reporting.
Please check the error in odbc_u.log as below :
[ODBC][21174][1406538704.435421][__handles.c][450]
Exit:[SQL_SUCCESS]
Environment = 0x9e9750
[ODBC][21174][1406538704.435485][SQLAllocHandle.c][364]
Entry:
Handle Type = 2
Input Handle = 0x9e9750
[ODBC][21174][1406538704.435536][SQLAllocHandle.c][482]
Exit:[SQL_SUCCESS]
Output Handle = 0x9ea080
[ODBC][21174][1406538704.435561][SQLConnect.c][3614]
Entry:
Connection = 0x9ea080
Server Name = [RQM][length = 3 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
[ODBC][21174][1406538704.437523][SQLConnect.c][1296]Error: IM004
[ODBC][21174][1406538704.437578][SQLError.c][430]
Entry:
Connection = 0x9ea080
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437622][SQLError.c][467]
Exit:[SQL_SUCCESS]
SQLState = IM004
Native = 0x7fffdc10a078 -> 0
Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][21174][1406538704.437651][SQLError.c][430]
Entry:
Connection = 0x9ea080
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437670][SQLError.c][467]
Exit:[SQL_NO_DATA]
[ODBC][21174][1406538704.437688][SQLError.c][510]
Entry:
Environment = 0x9e9750
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437704][SQLError.c][547]
Exit:[SQL_NO_DATA]
[ODBC][21174][1406538704.437728][SQLFreeHandle.c][279]
Entry:
Handle Type = 2
Input Handle = 0x9ea080
[ODBC][21174][1406538704.437746][SQLFreeHandle.c][330]
Exit:[SQL_SUCCESS]
[ODBC][21174][1406538704.437765][SQLFreeHandle.c][212]
Entry:
Handle Type = 1
Input Handle = 0x9e9750
[root@ tmp]# odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
[root@ tmp]#
[root@ tmp]# cat /etc/odbcinst.ini
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
[DB2]
Description = DB2 new driver
Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so
Driver64 = /opt/ibm/db2/V9.7/lib32/libdb2.so
Setup = /opt/ibm/db2/V9.7/lib32/libdb2.so
Setup64 = /opt/ibm/db2/V9.7/lib32/libdb2.so
UsageCount = 100
CPTimeout = 10000
CPReuse =
[IBM Rational XML ODBC Driver]
Description=
Driver=/opt/IBM/RRDI/etl/odbc/libratlxml.so
Driver64=/usr/lib64/libodbcinst.so
Setup=/opt/IBM/RRDI/etl/odbc/libratlxmlS.so
Setup64=/usr/lib64/libodbcinst.so
LIBPATH=/opt/IBM/RRDI/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
HttpConnectionTimeout=3600000
Threading=0
UsageCount=2
jdbclogpath=/tmp/jdbc.log
Debug=/tmp/odbc.log
[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_u.log
[root@ tmp]# cat /etc/odbc.ini
[RQM]
Driver = IBM Rational XML ODBC Driver
DataSource = RQM
Description =
User Name = xxxxxxxx
Authentication = xxxxxxxx
Configuration = /opt/IBM/RRDI/etl/configs/rqm406.xdc
[RQM Live]
Driver = IBM Rational XML ODBC Driver
DataSource = RQM Live
Description =
User Name = xxxxxxxx
Authentication = xxxxxxxx
Configuration = /opt/IBM/RRDI/etl/configs/rqm403-live.xdc
[root@ tmp]#
[root@ tmp]# isql -v "RQM"
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect
[root@ tmp]#
Can you please help me on this ?
Thanks in advance.
I am getting error while configuring the RQM Live reporting.
Please check the error in odbc_u.log as below :
[ODBC][21174][1406538704.435421][__handles.c][450]
Exit:[SQL_SUCCESS]
Environment = 0x9e9750
[ODBC][21174][1406538704.435485][SQLAllocHandle.c][364]
Entry:
Handle Type = 2
Input Handle = 0x9e9750
[ODBC][21174][1406538704.435536][SQLAllocHandle.c][482]
Exit:[SQL_SUCCESS]
Output Handle = 0x9ea080
[ODBC][21174][1406538704.435561][SQLConnect.c][3614]
Entry:
Connection = 0x9ea080
Server Name = [RQM][length = 3 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
[ODBC][21174][1406538704.437523][SQLConnect.c][1296]Error: IM004
[ODBC][21174][1406538704.437578][SQLError.c][430]
Entry:
Connection = 0x9ea080
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437622][SQLError.c][467]
Exit:[SQL_SUCCESS]
SQLState = IM004
Native = 0x7fffdc10a078 -> 0
Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][21174][1406538704.437651][SQLError.c][430]
Entry:
Connection = 0x9ea080
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437670][SQLError.c][467]
Exit:[SQL_NO_DATA]
[ODBC][21174][1406538704.437688][SQLError.c][510]
Entry:
Environment = 0x9e9750
SQLState = 0x7fffdc10a280
Native = 0x7fffdc10a078
Message Text = 0x7fffdc10a080
Buffer Length = 500
Text Len Ptr = 0x7fffdc10a07e
[ODBC][21174][1406538704.437704][SQLError.c][547]
Exit:[SQL_NO_DATA]
[ODBC][21174][1406538704.437728][SQLFreeHandle.c][279]
Entry:
Handle Type = 2
Input Handle = 0x9ea080
[ODBC][21174][1406538704.437746][SQLFreeHandle.c][330]
Exit:[SQL_SUCCESS]
[ODBC][21174][1406538704.437765][SQLFreeHandle.c][212]
Entry:
Handle Type = 1
Input Handle = 0x9e9750
[root@ tmp]# odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
[root@ tmp]#
[root@ tmp]# cat /etc/odbcinst.ini
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
[DB2]
Description = DB2 new driver
Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so
Driver64 = /opt/ibm/db2/V9.7/lib32/libdb2.so
Setup = /opt/ibm/db2/V9.7/lib32/libdb2.so
Setup64 = /opt/ibm/db2/V9.7/lib32/libdb2.so
UsageCount = 100
CPTimeout = 10000
CPReuse =
[IBM Rational XML ODBC Driver]
Description=
Driver=/opt/IBM/RRDI/etl/odbc/libratlxml.so
Driver64=/usr/lib64/libodbcinst.so
Setup=/opt/IBM/RRDI/etl/odbc/libratlxmlS.so
Setup64=/usr/lib64/libodbcinst.so
LIBPATH=/opt/IBM/RRDI/etl/jdbc
MaxActiveStatements=100
QueuingTimeout=100000
DefaultPageSize=1000
DefaultRetryTimes=10
HttpConnectionTimeout=3600000
Threading=0
UsageCount=2
jdbclogpath=/tmp/jdbc.log
Debug=/tmp/odbc.log
[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_u.log
[root@ tmp]# cat /etc/odbc.ini
[RQM]
Driver = IBM Rational XML ODBC Driver
DataSource = RQM
Description =
User Name = xxxxxxxx
Authentication = xxxxxxxx
Configuration = /opt/IBM/RRDI/etl/configs/rqm406.xdc
[RQM Live]
Driver = IBM Rational XML ODBC Driver
DataSource = RQM Live
Description =
User Name = xxxxxxxx
Authentication = xxxxxxxx
Configuration = /opt/IBM/RRDI/etl/configs/rqm403-live.xdc
[root@ tmp]#
[root@ tmp]# isql -v "RQM"
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect
[root@ tmp]#
Can you please help me on this ?
Thanks in advance.
Accepted answer
Hello Nikhil,
I would check the following points:
1) Make sure unixodbc is 32bit:
2) Check that all the dependencies for /opt/IBM/RRDI/etl/odbc/libratlxml.so are satisfied
[root@report ~]# ldd /opt/IBM/RRDI/etl/odbc/libratlxml.so
linux-gate.so.1 => (0xffffe000)
libicui18n.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicui18n.so.38 (0xf7e0c000)
libicudata.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicudata.so.38 (0xf7335000)
libicuio.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicuio.so.38 (0xf732b000)
libicuuc.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicuuc.so.38 (0xf7206000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf71c7000)
libc.so.6 => /lib/libc.so.6 (0xf706e000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xf6f83000)
libm.so.6 => /lib/libm.so.6 (0xf6f5a000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xf6f4e000)
/lib/ld-linux.so.2 (0x0077c000)
3) If everything is OK on the other point, you can consider replacing unixodbc with a more recent version (2.3.X). Sometime it helps.
Best Regards,
Francesco Chiossi
I would check the following points:
1) Make sure unixodbc is 32bit:
[root@report ~]# file /usr/local/bin/isqlcheck that it says ELF 32-bit LSB executable.
/usr/local/bin/isql: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
2) Check that all the dependencies for /opt/IBM/RRDI/etl/odbc/libratlxml.so are satisfied
[root@report ~]# ldd /opt/IBM/RRDI/etl/odbc/libratlxml.so
linux-gate.so.1 => (0xffffe000)
libicui18n.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicui18n.so.38 (0xf7e0c000)
libicudata.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicudata.so.38 (0xf7335000)
libicuio.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicuio.so.38 (0xf732b000)
libicuuc.so.38 => /opt/IBM/RRDI/etl/odbc/lib/libicuuc.so.38 (0xf7206000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf71c7000)
libc.so.6 => /lib/libc.so.6 (0xf706e000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xf6f83000)
libm.so.6 => /lib/libm.so.6 (0xf6f5a000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xf6f4e000)
/lib/ld-linux.so.2 (0x0077c000)
3) If everything is OK on the other point, you can consider replacing unixodbc with a more recent version (2.3.X). Sometime it helps.
Best Regards,
Francesco Chiossi