Intermittent RQP-DEF-0177 Running Reports

[jv_oz]

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

[MFGF]

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.