Error with ADOMD Data provider

[hamish]

We are using the RadPivotGrid to connect to a SQL Server 2013 Analysis server and in development it works just fine. As soon as I deploy it however to any of our production servers I get no data and a very cryptic error 'Problem with service call' . I get these errors thrown on both the events AdomdDataProvider.StatusChanged and AdomdDataProvider.FieldDescriptionProvider.GetDescriptionSataAsyncCompleted. It appears that all of the necessary components are installed on these servers and clearly it would appear to be a problem connecting to SQL Server but I have no idea what that could be. Interestingly enough in the same program we connect to the SQL Server Analysis server using Microsoft.AnalysisServices (to get a list of databases and cubes) and that works just fine and this uses the same user credentials that we are using with the ADOMD Data provider.

Does anyone have any idea how to track down what this means and what the problem may be.?

Thank you

[Rosen Vladimirov]

Hi Hamish,

I'm not sure what could cause such error. Can you try the attached project on your production server, by setting the exact same connection string that you are using in your RadPivotGrid. RadPivotGrid is opening the connection in the same way as in the attached project, so if it is working, RadPivotGrid should work fine as well.

I'm looking forward to hearing from you.

Regards,
Rosen Vladimirov
Telerik

 

 

[hamish]

Thank you for your reply. I tried your example program and it works just fine as is with either the integrated security been turned to SSPI or not. However if I use the exact same connection string in the Pivot grid I get nothing returned and no errors generated. ​
I have attached a table which summarizes what works and what doesn't. Any help would be appreciated

Thank you

[Rosen Vladimirov]

Hello Hamish,

Thank you for the clarification. From the table you've sent it looks like RadPivotGrid is working fine when you specify User ID and Password in the code, am I correct? If that's it, I assume there is a problem with the user that is running the application with RadPivotGrid in it. Could you check if the user is admin in the Analysis Service? Also do you specify Windows account (SSAS doesn't support SQL Logins)?

Regards,
Rosen Vladimirov
Telerik

 

 

[hamish]

Thank you for your reply and we had considered that and tried connecting with both SSPI and with a User ID and password and made sure it was exactly the same in both scenarios (i.e. from development and from production). However we did manage to solve it and how we did that is by replacing one of the Microsoft DLL's. We were using Microsoft.AnalysisServices.AdomdClient.dll - version 12.0.2000.8 on both environments. It worked in development but not in production. We found by replacing this DLL with Microsoft.AnalysisServices.AdomdClient.dll - version 10.0.2531.0 then it worked in all environments. What we surmised was that we have installed Microsoft Visual Studio for Analysis Services on our development environment but obviously not in production. Therefore we assumed that it had installed the latter DLL's in our development environment and some other 'unknown' components which made it work in one but not in the other.

For the time being this solution works for us and hopefully the resolution may be of some help to others.

Thank you for your help

[Rosen Vladimirov]

Hi Hamish,

Thank you very much for sharing the information. You are correct - currently RadPivotGrid is working with version 10 of AdomdClient library.

I'm glad you have resolved the issue. Feel free to contact us in case you have any other problems or concerns.

Regards,
Rosen Vladimirov
Telerik