cognos

[llo2k1]

Hello Everyone , can anyone help me with this error am getting when  i try go generate my report from tivoli common report with Network Manager Ip 3.9.


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: PARAMETERS UDA-SQL-0031 Unable to access the "PARAMETERS" database.UDA-SQL-0569 Unable to load the driver manager library ( libodbcinst.so ).UDA-SQL-0571 The operating system returned an error message ( libodbcinst.so: cannot open shared object file: No such file or directory ).RSV-SRV-0042 Trace back:RSReportService.cpp(771): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(787): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_RequestRSASyncExecutionThread.cpp(837): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(110): QFException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSQueryMgr.cpp(1003): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(264): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(659): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(634): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(1897): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4088): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(246): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3605): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3553): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

[Prerna Chaudhary]

Hi,

You might be facing this error due to the wrong pointing of DSNs.
Please try the steps mentioned below:
Drag A SQL component on the query explorer of your report and type "select @@servername as server "within it
Specify the name of the Datasource appearing at the left hand side under the SQL-properties pane
Then view the tabular data of the Query which has the SQl component. You will get the SQL server name that your report is currently based on

You will have to repoint your DSNs in case they are pointing to the wrong server.

Hope this works. :)

Thanks and regards
Prerna
---------------------------------------------------------------------------------------------------
pchaudhary@infocepts.com | www.infocepts.com
---------------------------------------------------------------------------------------------------