DPR-ERR-2056 The server is not responding when trying to run a Cognos report.

Technote (troubleshooting)


Problem(Abstract)

Unable to run any Cognos reports due to a 'DPR-ERR-2056 The server is not responding' error when MySQL 5.5.x Database used by ITNM as a back-end.

Symptom

DPR-ERR-2056 The server is not responding.

 Handler trace back:[the_dispatcher]   com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[rxBalancedRequest] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler
[do_warp] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler.

Cause

ODBC driver connectivity establishment failed.

Environment

Reporting database hosted on MySQL 5.5.X and Redhat Enterprise Linux

Diagnosing the problem

# odbcinst -j

unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini

In this case, /etc/odbcinst.ini is the drivers database file

# cat /etc/odbcinst.ini
[ODBC Drivers]
MySQL = Installed
[MySQL]
Description = ODBC for MySQL
Driver = /opt/IBM/tivoli/netcool/platform/linux2x86/mysql-connector-odbc-5.1.6/lib/libmyodbc5.so
FileUsage = 1
UsageCount = 2

This means, /opt/IBM/tivoli/netcool/platform/linux2x86/mysql-connector-odbc-5.1.6/lib/libmyodbc5.so is the ODBC connection driver lib being used.

isql is the command that can be used to test the ODBC configuration
# isql -v MySQL ncim ncim
[01000][unixODBC][Driver Manager]Can't open lib
'/opt/IBM/tivoli/netcool/platform/linux2x86/mysql-connector-odbc-5.1.6/lib/libmyodbc5-5.1.6.so' : libltdl.so.3:cannot open shared object file: No such file or directory [ISQL]ERROR: Could not SQLConnect
[Where ncim is the Username and another ncim is the Password]

The above command said, isql could not connect to the DB as one of the shared library file libltdl.so.3 was not found

# find / -name libltdl.so.3 -print
Find command revealed that the file was really not available.

# ldd /opt/IBM/tivoli/netcool/platform/linux2x86/mysql-connector-odbc-5.1.6/lib/libmyodbc5-5.1.6.so
linux-gate.so.1 => (0x00a07000)
libltdl.so.3 => not found
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00f70000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00920000)
libm.so.6 => /lib/libm.so.6 (0x005f4000)
libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0x0026f000)
libdl.so.2 => /lib/libdl.so.2 (0x004b4000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00545000)
libc.so.6 => /lib/libc.so.6 (0x00bf9000)
/lib/ld-linux.so.2 (0x00bd8000)

ldd command also revealed about the dependancy of the ODBC driver where it is clear that libltdl.so.3 alone is not found.


Resolving the problem

libltdl.so.3 is component of libtool-ltdl RPM


# yum install libtool*
libtool-ltdl
libtool-ltdl-devel

After the required RPM was installed, it solved the prerequisites and hence ldd command output was found to be alright.

# ldd /opt/IBM/tivoli/netcool/platform/linux2x86/mysql-connector-odbc-5.1.6/lib/libmyodbc5-5.1.6.so
linux-gate.so.1 => (0x00587000)
libltdl.so.3 => /usr/lib/libltdl.so.3 (0x00c55000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x008f7000)
libnsl.so.1 => /lib/libnsl.so.1 (0x0052d000)
libm.so.6 => /lib/libm.so.6 (0x00acd000)
libodbcinst.so.1 => /usr/lib/libodbcinst.so.1 (0x00110000)
libdl.so.2 => /lib/libdl.so.2 (0x00557000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00b98000)
libc.so.6 => /lib/libc.so.6 (0x00360000)
/lib/ld-linux.so.2 (0x00bd8000)

# isql -v MySQL ncim ncim
+-----------------------+
| Connected!            |
|                       |
| sql-statement         |
| help [tablename]      |
| quit                  |
|                       |
+-----------------------+
SQL> quit      

This confirmed that the ODBC connectivity was established successfully. All the Cognos reports are working without any issues.


Historical Number

86293
000
744

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Network Manager IP Edition

Software version:

3.9

Operating system(s):

Linux

Reference #:

1650120

Modified date:

2013-09-23

Translate my page

Machine Translation

Content navigation