Skip to Content
0
May 16, 2016 at 10:46 PM

Query optimizer generated too many subcubes in the query plan

240 Views

Hi,

I'm helping a consultant who'd having an issue with a report. I've pulled the following error message from tbllogs:

"Query optimizer generated too many subcubes in the query plan"

Has anyone ever seen this error message?

Here's the full details:

==============[System Exception Tracing]==============

[System Name] : SQE

[Message Type] : ErrorMessage

[Job Name] : clsSUAccess::getOlapData

[DateTime] : 05/16/2016 16:30:10

[UserId] : ...

[Exception]

DetailMsg : {Error: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query optimizer generated too many subcubes in the query plan.

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)

at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()

at DataService.OSoft.Services.Webservice.SharedQueryEngine.clsSUAccess.getOlapData(StringBuilder& sbResult, String[]& sMultiHQry, Hashtable& hsDimsIndex, Hashtable[]& hsAxisLists, String& sRetMsg, String& sWhere, Boolean bCheckSecurity)}

==============[System Exception Tracing End ]==============