Re: All reports stop working with error message RSV-SRV-0040

[Mast]

Hi

I have been facing this error please help


Quote
RSV-SRV-0040   The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.   DetailsCCLThreadResourceError:-1:Fatal: RSV-SRV-0042 Trace back:RSReportService.cpp(774): CCLThreadResourceError: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(254): CCLThreadResourceError: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_RequestRSASyncExecutionThread.cpp(887): CCLThreadResourceError: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(331): CCLThreadResourceError: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRun_RequestRSASyncExecutionThread.cpp(932): CCLThreadResourceError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_RequestExecution/RSRenderExecution.cpp(585): CCLThreadResourceError: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(339): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): CCLThreadResourceError: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(185): CCLThreadResourceError: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(314): CCLThreadResourceError: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(119): CCLThreadResourceError: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(177): CCLThreadResourceError: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(384): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(151): CCLThreadResourceError: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(448): CCLThreadResourceError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSSingletonAssembly.cpp(126): CCLThreadResourceError: CCL_RETHROW: RSSingletonAssembly::assembleAssembly/RSAssembly.cpp(699): CCLThreadResourceError: CCL_RETHROW: RSAssembly::createListIteratorRSResultSetIterator.cpp(1513): CCLThreadResourceError: CCL_RETHROW: RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(80): CCLThreadResourceError: CCL_RETHROW: QFSPartialDataset::GetEdgeIteratorSource/QEDmSqlResultSet.cpp(1942): CCLThreadResourceError: CCL_RETHROW: QESource/QEDMSqlCursorScroll.cpp(449): CCLThreadResourceError: CCL_RETHROW: Source/AQE_UDAFacade.cpp(980): CCLThreadResourceError: CCL_RETHROW: AQE_UDAFacade::sqlOpenResult CCLErrorapicursr.cpp(552): CCLThreadResourceError: CCL_RETHROW: sqlOpenResult CCLErrorapigbl.cpp(3927): CCLThreadResourceError: APICursorOpenThread::joinsgiWrapper.cpp(989): CCLThreadResourceError: CCL_RETHROW: sgiAOpen CCLThrowablesgiCursor.cpp(275): CCLThreadResourceError: CCL_RETHROW: SgiCursor::asyncOpen CCLThrowablecommon/sgiOdbcCursor.cpp(330): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::doOpen CCLThrowablecommon/sgiOdbcCursor.cpp(1050): CCLThreadResourceError: CCL_RETHROW: SgiOdbcCursor::openForNonMetaRqst CCLThrowableThreads/CCLThread.cpp(176): CCLThreadResourceError: CCL_THROW: CogThread interface or unknown error

[dougp]

So that we don't post things you have already tried...
What have you already tried to troubleshoot or resolve this?