Validation Error

[Cognos8]

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 

[cschnu]

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?

[dlafrance]

Look also that your ODBC connection, if any. You can desactivate timeout estimation