[AS] RSV-SRV-0040: Fatal Error, SRV-0042 Reports won't run anymore

[bvandenhende]

My reports which functioned a few weeks will not run anymore. Help would be appreciated! I get the following error:
RSV-SRV-0040 - An application error has occurred. Please contact your Administrator.


CCLAssertError:0:Fatal: CCL_ASSERT(!(rec.dimensionMun.empty() || rec.hierarchyMun.empty() || rec.mun.empty())); RSV-SRV-0042 Trace back: RSReportService.cpp(639): CCLAssertError: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysis_Request RSASyncExecutionThread.cpp(562): CCLAssertError: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(205): CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::run(): reportEditAnalysis_Request RSASyncExecutionThread.cpp(612): CCLAssertError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysis_Request PPSAnalysis.cpp(149): CCLAssertError: CCL_RETHROW: PPSAnalysis::executeAnalysis PPSAnalysis.cpp(141): CCLAssertError: CCL_CAUGHT: PPSAnalysis::executeAnalysis core/RequestContext.cpp(531): CCLAssertError: CCL_RETHROW: RequestContext::handleRequest core/RequestContext.cpp(528): CCLAssertError: CCL_CAUGHT: RequestContext::handleRequest scmd/MdsCache.cpp(789): CCLAssertError: CCL_THROW:

[kommireddy]

Hi i found a KB article in support site, hope this helps :)

Description:

Every time you start a new report I receive this error in Report Studio:RSV-SRV-0040. An application error has occurred. Please contact your Administrator.

Error Message:

RSV-SRV-0040
An application error has occurred. Please contact your Administrator.

Details:
CGSErrorAssert:0:Fatal: CGS_ASSERT(bytesRead != -1 && bytesRead == (long) byteCount, "Read failure."); RSV-SRV-0042 Trace back:
RSBIBusPlugin.cpp(690): CGSErrorAssert: CCL_CAUGHT: RSBIBusPlugin::process() RSBIBusMethod.cpp(169): CGSErrorAssert: CCL_RETHROW:
RSBIBusMethod::process(): mapGetMapInfo_Request Common/CMFileStream.cpp(96): CGSErrorAssert: CCL_THROW:


Solution:

In the folder ..\program files\cognos\c8\maps you can only have the files with extension .CMF. Any other file will give you an error in Report Studio.

[getanswers]

Hi,
  I am having the same problem, when I am trying to validate the report in COgnos 8(version 8.2). This is  a new installation and I am using a new  list report .
  The error it throws is
RSV-SRV-0040
An application error has occurred. Please contact your Administrator.
Details:

CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(rResultSetName == rsCurrentResultSetName, "Result set names don't match."); RSV-SRV-0042 Trace back: RSReportService.cpp(639): CCLAssertError: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177): CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process(): validateValidateSpecification_Request RSASyncExecutionThread.cpp(562): CCLAssertError: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(205): CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::run(): validateValidateSpecification_Request RSASyncExecutionThread.cpp(612): CCLAssertError: CCL_RETHROW: RSASyncExecutionThread::processCommand(): validateValidateSpecification_Request ExecutionContextImpl/RSReportValidateExecutionContext.cpp(98): CCLAssertError: CCL_RETHROW: RSReportValidateExecutionContext::run() RSRequest.cpp(1442): CCLAssertError: CCL_RETHROW: RSRequest::validateInteractive() Execution/RSRenderExecution.cpp(584): CCLAssertError: CCL_RETHROW: RSRenderExecution::execute Execution/RSRenderExecution.cpp(856): CCLAssertError: CCL_RETHROW: RSRenderExecution::processActiveDocuments Assembly/RSDocAssemblyDispatch.cpp(235): CCLAssertError: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly RSQueryMgr.cpp(947): CCLAssertError: CCL_RETHROW: RSQueryMgr::getListIterator RSQueryMgr.cpp(1007): CCLAssertError: CCL_RETHROW: RSQueryMgr::getResultSetIterator RSQueryMgr.cpp(1169): CCLAssertError: CCL_RETHROW: RSQueryMgr::createIterator RSQueryMgr.cpp(1215): CCLAssertError: CCL_THROW:

  As far I have observed  if I validate without any groupings/sections created, it runs fine. The moment I group by a colum and Validate, it errors.
Please any information on this should be helpful.
Thanks
getanswers.

[larsonr]

I received the same error today.  We actually went into the queries one by one to find the culprit, offering a better understanding of the error. At that point we were able to better identify the solution.  The problem were some calculations. 

8.2 has some quirks that is actually keeping us from moving to production.

One is that calculations that use items in the query need to be near the top of the query before the call for the pieces that build it out.

Secondly, verify that any database specific functions are still working. -- this was our main culprit.  Cognos 8.2 is now smart enough to realize the datatype we were using is a number (although it was sent back as a string) so calling to_number on it was redundant in 8.2.

You may need to also check for any items that are selected with a roll up aggregation of automatic.  You may need to rethink this and try other aggregate functions or explicitly call the aggregation within the query item.

After going through these steps after we ran each query individually we were able to stop that specific error in a few different reports.

[getanswers]

Hey larsnor,
   I don't know what could be leading to this problem. In the Framework manager I am trying to  to get columns from the Oracle Database(8.0.5). I have say about 4 columns, Customer_name(varchar) ,Customer_number(varchar2),organization_id (number in Oracle),customer_id (number in Oracle).If I just select these columns, and publish the package, I am fine.
  Then in the report Studio, I create a list report and select all the columns, it works fine.(no problem till here at all).
  But then ther are many customers in a single Organization_id. So i select the organiztion_id  and then click the group symbol and try to validate the report I get this error.
  Also note that I have set all types of aggregates to none.
Any help in this regrad wil be apprciated.
Thanks,

[eskimoyuan]

I also meet this issue.
I made a cube for report and when I run the report, select all the prompt values , it went to this error.
Till  now, I don't know how to solve this issue.