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. |
Accepted answer
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.