IBM Support

After migrating, reports fail: Unable to load driver manager library libdb2.a(shr.o)

Troubleshooting


Problem

After a new install and database migration, reports fail to execute with... 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:  Audit  The customer has a 32-bit appserver and LIBPATH which contains a reference to /opt/IBM/db2/V10.5/lib32 

Symptom

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: 
Audit 
.UDA-SQL-0571 The operating system returned an error message ( 0509-022 Cannot load module shr.o. 
0509-026 System error: A file or directory in the path name does not exist. ).RSV-SRV-0042 Trace back:RSReportService.cpp(736): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(253): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(873): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(317): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(918): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestRSRequest.cpp(1657): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(808): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(880): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(988): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(296): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(673): QFException: CCL_THROW: RSQueryMgrBasic::processExceptionRSQueryMgrExecutionHandlerImpl.cpp(168): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSFaultHandler.cpp(97): QFException: CCL_THROW: RSFaultHandler::handleNonCriticalExceptionQFSSession.cpp(1190): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1188): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1121): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(888): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(311): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(2041): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4426): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(344): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3994): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3930): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(833): QFException: CCL_THROW: QE 

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"}],"Version":"11.0.9","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg22014305

Page Feedback