HI,
I have posted this question before. I have a stange case when I build this new report. As far as columns are just the rows for columns "Customer_name",'Customer_number",'Organzation_id' , the repot works fine. The moment I add Group by to theOrganization_id and Validate the report, I get this error
RSV_SRV_0040
and then
An application error has occurred. Please contact your Administrator.
and when I click teh details, It shows the errors as
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:
What could be theproblem here..
Any help will be gratly appreciated..
Thanks
Does the query contain a Union (in RS)? I have seen this error before, both when I SHOULD have seen it, as well as times when I was confident I shouldn't. In the latter, I opened a case at Cognos, but it was never resolved.
Hi,
Nope, no union..it is just equivalent to a simple select in SQL like
"Select CustomeR_name,customer_number,organization_id from ra_customers
group by warehouse_id,customer_name,customer_number"
Note that , if there is no group by, the report works fine..
Also I just tried to Generate the SQL for this , but even that failed with the same error.What's going on I really don't know. This is a new set up for me.
Any help will be greatly appreciated..
hmmm...definitely it will give you error
Yours Query: ----Column 'organization_id' is invalid in the select list because it is not contained in the GROUP BY clause.
Select CustomeR_name,customer_number,organization_id from ra_customers
group by warehouse_id,customer_name,customer_number"
It should be like this.....
Select CustomeR_name,customer_number,organization_id from ra_customers
group by CustomeR_name,customer_number,organization_id"
I just has this same problem and this thread helped a bit... after some effort. I removed grouping from the report page yet still had the problem. It took me a while to see that one of the properties of the bad query is called "Auto Group & Summarize" and it was set to YES. Once I set it to NO everything worked fine.