Hi ,
When i run the report in c82 report studio i got the below error. I searched in web , but not getting the right solution. But some time i am getting output.
RQP-DEF-0177
An error occurred while performing operation 'sqlOpenResult' status='-28'.
Details
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "fetch". [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 {SQLFetch} UDA-CUR-0000 Unable to fetch the row. RSV-SRV-0042 Trace back: RSReportService.cpp(619): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(202): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(618): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(202): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(668): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request Execution/RSRenderExecution.cpp(587): QFException: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(861): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments Assembly/RSDocAssemblyDispatch.cpp(235): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSPageAssembly.cpp(247): QFException: CCL_RETHROW: RSPageAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableRowAssembly.cpp(136): QFException: CCL_RETHROW: RSTableRowAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(254): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly Assembly/RSTableCellAssembly.cpp(94): QFException: CCL_RETHROW: RSTableCellAssembly::assemble Assembly/RSDocAssemblyDispatch.cpp(295): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward Assembly/RSAssembly.cpp(477): QFException: CCL_RETHROW: RSAssembly::createListIterator Assembly/RSAssembly.cpp(518): QFException: CCL_RETHROW: RSAssembly::createListIterator RSQueryMgr.cpp(950): QFException: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1010): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1172): QFException: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1466): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgr.cpp(1453): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand RSQueryMgrExecutionHandlerImpl.cpp(172): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQueryMgrExecutionHandlerImpl.cpp(164): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute() RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession::DoRequest QFSSession.cpp(1479): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1477): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(1444): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSConnection.cpp(771): QFException: CCL_RETHROW: QFSConnection::Execute QFSQuery.cpp(115): QFException: CCL_RETHROW: QFSQuery::Execute v2 CoordinationQFSQuery.cpp(3648): QFException: CCL_THROW: CoordinationPlanner
Quote from: Cognos8 on 17 Jul 2009 06:32:45 AM
Hi ,
When i run the report in c82 report studio i got the below error. I searched in web , but not getting the right solution. But some time i am getting output.
RQP-DEF-0177
An error occurred while performing operation 'sqlOpenResult' status='-28'.
Details
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "fetch". [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 {SQLFetch} UDA-CUR-0000 Unable to fetch the row.
It appears that your query is timing out. Did you verify that the SQL being generated is optimal?
Look also that your ODBC connection, if any. You can desactivate timeout estimation