Get thiis error when colums are grouped.

[getanswers]

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

[rockytopmark]

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.

[getanswers]

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..

[Maple]

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"

[mylesdcollins]

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.