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 

Cause

The Cogadm user ID did not exist on the new Application server, only the Cognos User ID was created on the Application server. The Cogadm ID was the credential used by Cognos to access the Content Store and Audit databases.

Resolving The Problem

Recreate the Cogadm ID on the Application server

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"}],"Version":"11.0.9","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22014305

Page Feedback