Hi,
I am getting below error while i ran the report intractively but when i open the report in Report studio & ran it, it gives the output. Here i am using Storeprocedure Query.
RQP-DEF-0177
An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.UDA-SQL-0283 Metadata describing "New_Query_Subject" does not match results from the database.RSV-SRV-0042 Trace back:RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(788): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_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/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/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/RSAssembly.cpp(649): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(690): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.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(305): QFException: CCL_RETHROW: RSQFSession::DoRequestQFSSession.cpp(719): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(717): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(662): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(637): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4299): QFException: CCL_THROW: CoordinationPlanner
Please Suggest me what is that error..
Thanks,
Sekhar
It looks like the logic, or at least the fields that are returned from your stored procedure may have changed since you modeled it in Framework Manager. Try refreshing the query subject in Framework Manager and republish the package.