asked on May 18, 2017
I'm working with 2.3 version with SSAS datasource and there is a dimension in specific that when i use it i just get the message "The server sent an unrecognizable response." Please Help!
⋅ May 19, 2017
Hello Manuel,
Thank you for the interest in our component. We suggest you check on the server side first. Our component is displaying the error that came from the server. Please consider running a profiler and checking the cause of the error. Typically the server returns this kind of error message when the returned XML is invalid. The possible reason is some special characters in the XMLA response. To fix this, you can go to the attribute which is causing the problem and change the bindings on the column for InvalidXmlCharacters to Remove or Replace . Does it solve your problem?
Regards,
Tanya
⋅ May 19, 2017
Yes, but my im curious 'cause this error is using a olap cube and just in one dimension is the problem, but this same cube we use in an old controller where it functions correctly. We bougth flexmonster to update our technologies. I will try and keep you updated. Thanks!
⋅ March 19, 2024
Hi team! we are evaluating changing our current solution for SSAS connection on our web app, to yours. So far the performance is MUCH BETTER and we are quite impressed. I will most likely ask you a few questions about licensing..
Right now, however, we are currently getting this same error when we try to use some dimensions that have text inside. I think it could be related to data format but I cannot find the issue.
This is what I'm getting in the log
2024-03-19 16:43:59.8115 | TRACE | SELECT {} on 0, Subset(DISTINCT({[CL-Localidades].[Localidad].allmembers}), 0, 10000) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, LEVEL_UNIQUE_NAME on 1 FROM [Cubo_Comercial_Cia]
2024-03-19 16:43:59.8555 | ERROR | The server sent an unrecognizable response.
at Microsoft.AnalysisServices.AdomdClient.SoapFormatter.ReadResponse(XmlReader reader, InlineErrorHandlingType inlineErrorHandling)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.<DiscoverMembers>d__25.MoveNext() in C:\Git\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster.Accelerator\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:line 658
is "InvalidXmlCharacters" still available to use? I couldn't find where to apply it? Thanks in advance.
⋅ March 21, 2024
Hello Jesica,
Thank you for reaching out to us. We are glad to hear that you enjoy using Flexmonster!
Flexmonster Accelerator logs show that there is an issue on the server. It's important to ensure that the content is encoded correctly to avoid issues with special characters. If a specific attribute is causing the problem, you can modify the handling of invalid XML characters for that attribute.
If you're using Microsoft SQL Server Analysis Services, we recommend adjusting the properties of the data source view or the dimension attribute in the SSAS project.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 22, 2024
It was related to invalid characters as you said, thanks for the support!
⋅ March 22, 2024
Hello Jesica,
Thank you for the feedback!
We are glad to hear that it works for you.
You are welcome to contact us in case other questions arise.
Kind regards,
Nadia
