Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

0 votes


Accepted answer

Permanent link
Hello Nikhil,

I would check the following points:

1) Make sure unixodbc is 32bit:
[root@report ~]# file /usr/local/bin/isql
/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
check that it says ELF 32-bit LSB executable.

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
Nikhil Vipradas selected this answer as the correct answer

0 votes

Comments

Thanks a lot Francesco!! :-)
Its working after installing 32 bit unixODBC.
Cheers !!

1 vote

Glad to hear that it's fixed.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 28 '14, 5:19 a.m.

Question was seen: 3,641 times

Last updated: Jul 28 '14, 6:36 a.m.

Confirmation Cancel Confirm