We are seeing the following errors more frequently in the Flexmonster accelerator logs. Cubes will not load in our Angular app until the accelerator service has been stopped/restarted several times.
Users are able to connect to the same reports through Excel spreadsheets with no issues during this time.
Have you seen this before and can you please give any guidance to remediate?
The accelerator is on the same box as SSAS running Window Server 2008
Freepoint Commodities LLC
2021-12-01 13:47:53.9882 | ERROR | Data Source connection – FAILED
2021-12-01 13:47:54.0038 | ERROR | Exception of type ‘System.OutOfMemoryException’ was thrown.
at System.IO.BufferedStream.WriteToBuffer(Byte array, Int32& offset, Int32& count)
at System.IO.BufferedStream.Write(Byte array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.WriteHeader(Boolean endOfRecord, Boolean endOfMessage, Int64 contentLength)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.WriteChunkedPayload(Boolean endOfRecord, Boolean endOfMessage, Byte bytes, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.Close(Boolean endOfMessage)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.WriteEndOfMessage(Boolean callBaseDirect)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime, SecurityContextMode securityContextMode)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo, SecurityContextMode securityContextMode)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.TestConnection() in C:\Work\git\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 1125
2021-12-01 13:48:11.7099 | TRACE | Flexmonster Data Speed Accelerator for Miscrosoft SSAS
2021-12-01 13:48:11.7255 | TRACE | Version 2.9.9
Thank you for raising your support ticket.
It looks like your server machine does not provide enough resources for the Accelerator – we’d recommend increasing the RAM allocated to the server.
You’ve also mentioned that everything seems to be working as expected after the Accelerator is restarted. Chances are,
OutOfMemoryException is caused by Accelerator’s cache overload – when the Accelerator service is restarted, its cache is cleared and there are enough resources for the Accelerator to function properly again.
With that in mind, limiting the cache size in your Accelerator instance might also be helpful.
Please let us know if this helps.
Thank you for the quick response. Our configuration includes the following two lines
With CACHE_ENABLED set to false we assume CACHE_MEMORY_LIMIT is ignored. Is this true?
Thank you for your fast response.
That’s correct, the
CACHE_MEMORY_LIMIT value does not matter when caching is disabled through
Since cache is already disabled on your side, the best thing we can suggest is to, again, increase the amount of RAM available to the server so that the Accelerator has enough resources to process all the necessary data.
Please let us know if there is anything else we can help you with.
Thank you again for the fast response. Our network team supplied the following info from the SSAS server.
The OS memory is 32 Gb and we have 19 Gb available now.
Flexmonster service is only using 238 K.
Is more memory still needed? If so, what would be the recommended amount of memory to configure?
Thank you, Mike
Given that your machine still has 19 GB of RAM available, it is indeed strange that the Accelerator throws the
That said, we need to know more details to understand what might be causing the issue in question. It would help us a lot if you could provide us with the following information:
Thank you in advance and looking forward to your response.
Hope you’re doing well!
Just checking in to ask if you’ve had a chance to read my previous response. Will you be able to provide us with additional details on your use case so that we can investigate the issue further?
Thank you in advance for your response.