Error with ADOMD Data provider

6 posts, 0 answers
  1. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 12 Aug 2014 Link to this post

    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
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 13 Aug 2014 Link to this post

    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
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  3. UI for WPF is Visual Studio 2017 Ready
  4. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 13 Aug 2014 in reply to Rosen Vladimirov Link to this post

    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
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 14 Aug 2014 Link to this post

    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
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  6. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 14 Aug 2014 in reply to Rosen Vladimirov Link to this post

    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
  7. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 14 Aug 2014 Link to this post

    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
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
Back to Top
UI for WPF is Visual Studio 2017 Ready