Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Loss of connectivity between accelerator and cube via Microsoft Analysis Services

Answered
evgeniy lobayev asked on August 11, 2020
  • Flexmonster Data Speed Accelerator for Miscrosoft SSAS Version 2.7.11

When starting flexmonster, we lose access to the olap cube after 2 hours and the following reason is displayed in the log:

 Unsupported data format : 
   at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()
   at Microsoft.AnalysisServices.AdomdClient.CompressedStream.GetResponseDataType()
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Discover(String requestType, String requestNamespace, ListDictionary properties, IDictionary restrictions, Boolean sendNamespacesCompatibility, IDictionary requestProperties)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperty(String propName)
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.GetSessionId(String catalog, String credentials, String cubeUniqueName, String customData, String localeIdentifier, String effectiveUserName, String roles) in c:\FMprojects\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 1133
   at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.DiscoverDimensions(DiscoverArgs args) in c:\FMprojects\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 99

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster August 13, 2020

Hello,
 
Thank you for reaching out to us.
 
Our team wants to explain that we did not manage to reproduce the problem.
 
It would be useful for our research if you could provide us with the dump of your database and the corresponding cube so that we could try reproducing the issue on our side.
 
Also, we want to ask you for additional details on this matter:
Do any specific actions lead to the described problem? For example, is there any particular report configured on the client-side that entails the exception? If so, please send us the corresponding JSON file containing such a report.
 
Finally, we want to take an interest in what actions do you use to resolve the problem after it appears. Is it enough to restart the Accelerator, or SSAS needs to be restarted as well?
 
Our team is looking forward to hearing from you.
Please let us know in case additional questions arise.
 
Regards,
Illia

Please login or Register to Submit Answer