Hi all,
We have Cognos BI 10.2.1 FP8 and are getting an intermittent "RQP-DEF-0177" error in Production only. The Dev, Test and Staging environments work perfectly. The data source is SQL Server, where there are also Dev, Test, Staging and Production SQL Servers. Every few times a report is run, we get this error.
The code that is underneath the error says:
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Login timeout expired (SQLSTATE=HYT00, SQLERRORCODE=0)RSV-SRV-0042 Trace back:RSReportService.cpp(726): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(854): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestRSRequest.cpp(1663): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(554): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(621): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(713): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(278): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(175): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(166): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1084): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4484): QFException: CCL_THROW: CoordinationPlanner
Can anyone please give any advice how to fix this error?
Thanks
John
Quote from: jv_oz on 26 Oct 2015 12:19:27 AM
Hi all,
We have Cognos BI 10.2.1 FP8 and are getting an intermittent "RQP-DEF-0177" error in Production only. The Dev, Test and Staging environments work perfectly. The data source is SQL Server, where there are also Dev, Test, Staging and Production SQL Servers. Every few times a report is run, we get this error.
The code that is underneath the error says:
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Login timeout expired (SQLSTATE=HYT00, SQLERRORCODE=0)RSV-SRV-0042 Trace back:RSReportService.cpp(726): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(854): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestRSRequest.cpp(1663): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(554): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(621): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(713): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(278): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(175): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(166): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1084): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4484): QFException: CCL_THROW: CoordinationPlanner
Can anyone please give any advice how to fix this error?
Thanks
John
Hi,
These kinds of errors can result from resource limitations on the server hosting your database - often not enough memory.
Take a look at the technote below:
http://www-01.ibm.com/support/docview.wss?uid=swg21626422
Cheers!
MF.