"System Error 0x80004005 (2147500037): - Unspecified error" message occurs when "Filtering on Selections" in a report with Custom Groups or Consolidations (MicroStrategy Web 9.x)

Description 

When attempting to use the function Filter on Selections in Strategy Web, users may encounter this message on a report when Custom Groups and/or Consolidations are to the left of the target:
 

Error in report results: User request is in Analytical engine. System Error 0x80004005 (2147500037): 
- Unspecified error

<record>
  <package>com.Strategy.webapi</package>
  <level>SEVERE</level>
  <miliseconds>1313007479257</miliseconds>
  <timestamp>08/10/2011 16:17:59:257</timestamp>
  <thread>1</thread>
  <class>CDSSXMLReportServer</class>
  <method>GetExecutionResultsEx</method>
  <message>User request is in Analytical engine.
System Error 0x80004005 (2147500037): --- Unspecified error (com.Strategy.webapi.MSTRWebAPIException)</message>
  <exception>
com.Strategy.webapi.MSTRWebAPIException: User request is in Analytical engine.
System Error 0x80004005 (2147500037): --- Unspecified error
	
at com.Strategy.webapi.CDSSXMLReportServer.GetExecutionResultsCommon(Unknown Source)
	
at com.Strategy.webapi.CDSSXMLReportServer.GetExecutionResultsEx(Unknown Source)
	
at com.Strategy.web.objects.WebReportInstanceImpl.getExecutionResults(Unknown Source)
	
at com.Strategy.web.objects.WebReportInstanceImpl.pollForResults(Unknown Source)
	
at com.Strategy.web.objects.WebReportInstanceImpl.pollForResults(Unknown Source)
	
at com.Strategy.web.objects.WebReportInstanceImpl.getViewMediaSettings(Unknown Source)
	
at com.Strategy.web.beans.ReportInstanceProxy.getViewMediaSettings(Unknown Source)
	
at com.Strategy.web.app.beans.ReportFrameBeanFeaturesImpl.resolveViewMedia(Unknown Source)
	
at com.Strategy.web.app.beans.ReportFrameBeanFeaturesImpl.resolveFeature(Unknown Source)
	
at com.Strategy.web.beans.AbstractWebFeatures.isFeatureAvailable(Unknown Source)
	
at com.Strategy.web.beans.AbstractWebComponent.resolveFeature(Unknown Source)
	
at com.Strategy.web.beans.AbstractWebComponent.isFeatureAvailable(Unknown Source)
	
at com.Strategy.web.beans.AbstractWebComponent.isFeatureAvailable(Unknown Source)
	
at com.Strategy.web.app.transforms.RibbonToolbarTransform.loadResolvedFeatures(Unknown Source)
	
at sun.reflect.GeneratedMethodAccessor396.invoke(Unknown Source)
	
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	
at java.lang.reflect.Method.invoke(Method.java:597)
	
at com.Strategy.web.tags.DynamicTagImpl.invokeMethod(Unknown Source)
	
at com.Strategy.web.tags.WebBlockEditTagImpl.invokeMethod(Unknown Source)
	
at com.Strategy.web.tags.WebBlockEditTagImpl.doStartTag(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.render(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.renderChildTags(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.render(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.renderChildTags(Unknown Source)
	
at com.Strategy.web.app.tags.ScriptTagImpl.render(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.renderChildTags(Unknown Source)
	
at com.Strategy.web.tags.TagImpl.render(Unknown Source)
	
at com.Strategy.web.transform.AbstractLayoutTransform.transformUsingLayout(Unknown Source)
	
at com.Strategy.web.app.transforms.AbstractAppTransform.renderLayout(Unknown Source)
	
at com.Strategy.web.app.transforms.AbstractAppWidgetTransform.transformForRequestSuccessful(Unknown Source)
	
at com.Strategy.web.app.transforms.AbstractAppTransform.checkStatus(Unknown Source)
	
at com.Strategy.web.app.transforms.AbstractAppWidgetTransform.renderShell(Unknown Source)
	
at com.Strategy.web.app.transforms.AbstractAppTransform.transform(Unknown Source)
	
at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source)
	
at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source)
	
at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source)
	
at com.Strategy.web.app.gui.GuiComponentImpl.renderElement(Unknown Source)
	
at com.Strategy.web.app.taglibs.DisplayGuiComponentTagHelper.renderComponent(Unknown Source)
	
at com.Strategy.web.app.taglibs.DisplayGuiComponentTagHelper.getContent(Unknown Source)

   </exception>
</record>

Why is this happening?

This is a known issue with Strategy Web 9.x and 10.x.
Our engineers are working to enhance the overall Strategy experience.
 

Solution

Strategy will continue to investigate and post updates as soon as they are available. Please refer back to this article for more information. In the meantime, feel free to redesign the report to not use Custom Groups or Consolidations to allow for the Filter on Selections operation.