Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Error on connecting with windows authentication to Accelerator with Firefox

Answered
Richard asked on June 29, 2020

Hi,
I’m trying to set up the accelerator to fetch my OLAP data with “Windows Authentication”.
I’m able to fetch data using Chrome, but when trying with Firefox I get an error instantly after giving my credentials.
The response of the request:

{"sessionId":0.0,"data":null,"error":{"message":"The connection either timed out or was lost."}}

The error from flemonster-proxy-ssas.exe:

ERROR The connection either timed out or was lost.
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.OpenConnection(AdomdConnection connection, BaseArgs args)
at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.GetSessionId(BaseArgs args)
at Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.DiscoverDimensions(DiscoverArgs args)

When connecting through Chrome I don’t have to give my credentials manually, but I do when using Firefox.
// Richard

10 answers

Public
Richard July 2, 2020

This also happens on Microsoft Edge 44.17763.1.0 (Microsoft EdgeHTML 18.17763)

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster July 2, 2020

Hi Richard,
 
Thank you for posting your question.
 
We’ve done some tests on our side and didn’t manage to reproduce the described behavior so far.
 
More specifically, we’ve used our guide to set up Windows Authentication for Flexmonster Accelerator and tested it on the latest Chrome 83, Edge 83 & Firefox 78.0.1. We would suggest following the steps described in the mentioned guide when setting up authentication on your side to ensure everything is configured correctly.
 
In case this does not help, we would appreciate it if you could provide more details on your situation with exact steps on how to reproduce the issue.
 
Also, addressing your last point regarding the sign-in popup not appearing it Chrome, this happens when you’re loading the page from a non-incognito window while already being signed in to your Windows account. 
 
We would be happy to hear your feedback!
 
Looking forward to hearing from you.
 
Kind regards,
Mykhailo

Public
Richard July 2, 2020

Hi, I just played around with the settings and the problem seems to stem from the connection string.
I’m connecting directly to the server with the SSAS Cube, ie “Data Source=serverName”. This worked fine with Chrome and IE11 when using the es5.js version.
But when i changed it to my msmdpump version, ie “Data Source=http:localhost/OLAP/msmdpump.dll” it works on Firefox and Edge. We would prefer not to use the msmdpump work-around and connect directly to the server.
Are you able to reproduce the bug in that way?
If not, I will try to gather all relevant information and provide it. (btw, I followed your guide on windows auth, so it should be the same)
 
Regards,
Richard

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster July 3, 2020

Hi Richard,
 
Thank you for your fast response.
 
So far, it is not entirely clear to us why this approach results in different outcomes depending on the browser – perhaps the mentioned browsers process the authorization/authentication differently.
 
Do you think it would be possible for you to provide us with a link to your Accelerator with some kind of test user credentials so that we can do some debugging on our side?
 
Looking forward to your reply.
 
Regards,
Mykhailo

Public
Richard 6 days ago

Hi Mykhailo,
 
I sadly cannot provide you with a link as we are running on an internal net with no internet connection, but I will see if I can host something on my internet machine and replicate the bug. You are not able to replicate it on your end? All I’ve done is hosting the cube on a different server, then connecting to it using the server name as Data Source.
 
Regards,
Richard

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 5 days ago

Hi Richard,
 
We’ve didn’t encounter the mentioned issues when hosting the cube on a different server as well.
 
Would that be possible for you to send us the logs of your browser’s console so that we can see what kind of errors it returns?
 
Thank you in advance!
 
Kind regards,
Mykhailo

Public
Richard 5 days ago

The only log i get is the one i showed in the first post. It gives me a 200 OK but that the connection timed out.
These are the differences when looking at the logs in dev tools + accelerator: https://imgur.com/a/j1QOUfJ

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 3 days ago

Hi Richard,
 
Thank you for sending over the requested screenshots.
 
We are currently investigating this further and it would also be helpful if you could provide us with the following info as well:
 

  1. The version of your Firefox browser.
  2. The screenshot of the Firefox Network Headers tab (similar to that of Chrome you’ve sent us yesterday) 
  3. Your Flexmonster report configurations.

 
Please let us know if that would be possible.
 
Looking forward to your reply!
 
Kind regards,
Mykhailo

Public
Richard 3 days ago

Hi again Mykhailo,
 
sure, here are the following info:

View post on imgur.com


 
Regards,
Richad

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 1 day ago

Hi Richard,
 
Thank you for sending over the requested information once again.
 
After additional testing, we still aren’t able to reproduce exactly what you’ve reported.
 
As a potential workaround, have you considered keeping the cube and the Accelerator on the same server? One of our suspicions is that in your case the authorization is probably compromised somewhere during the transfer from the Accelerator to the server, which can be fixed by simply hosting them on the same machine. This way is also somewhat easier to configure and returns the data faster.
 
Please let us know what you think.
 
Regards,
Mykhailo

Please login or Register to Submit Answer