XMLA Provider Connection Problems

6 posts, 0 answers
  1. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 16 Jan 2013 Link to this post

    Hi all, 
    I've problems to connect to Adomd OLAP server since version 1307 (also 1314 of yesterday). 
    Have you perhaps changed something in connection parameters and methods?

    I configure the provider by this way:

    Session.OlapProvider = new AdomdDataProvider
    {
        ConnectionSettings = new AdomdConnectionSettings()
        {
            ConnectionString = Settings.Default.OlapConnString,
            Database = Settings.Default.OlapDatabase,
            Cube = Settings.Default.OlapCube
        }
    };

    ...then the problem is on following line of my code:

    this.pivot.DataProvider = Session.OlapProvider;

    the error is System.NullReferenceException but I can't know where is in PivotGrid sourcecode.

    Before 1307 internal release all works fine...
    Please, can you help me?

    EDIT: Sorry, I have specified the wrong title that is ADOMD provider connection problems: if you can, change it, thanks!

    Many thanks!
    Davide
  2. Milan
    Admin
    Milan avatar
    1989 posts

    Posted 16 Jan 2013 Link to this post

    Hi,

    We are currently investigating the issue and we will contact you as soon as we have more information.

    All the best,
    Milan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. UI for WPF is Visual Studio 2017 Ready
  4. Milan
    Admin
    Milan avatar
    1989 posts

    Posted 16 Jan 2013 Link to this post

    Hi,

    Unfortunately we could not reproduce the problem with our latest binaries. Is it possible to send us the state of the stack trace when that exception is thrown? Another option would be to send us an application where the problem can be reproduced.  

    Kind regards,
    Milan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  5. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 30 Jan 2013 Link to this post

    Hi, 
    I still have problems with current build (1328). 
    I use following method to connect: 

    Connection String:

    Provider=MSOLAP;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DATABASE_NAME;Data Source=SERVER_NAME

    Code:
                Session.OlapProvider = new AdomdDataProvider
                {
                    ConnectionSettings = new AdomdConnectionSettings()
                    {
                        ConnectionString = "The connection string above",
                        Database = "The database name",
                        Cube = "The cube name"
                    }
                };

    I have created and tested the connection string by creating an UDL file and the "Test Connection" works correctly.
    The error is raised on the following row:

    this.pivot.DataProvider = Session.OlapProvider;
    

    and the exception is: 

    System.NullReferenceException

    Please note that the following row 

    this.fieldList.DataProvider = Session.OlapProvider;
    

    don't raise errors and Session.OlapProvider is  not null after initialization, so the problem seems to be in in PivotGrid and not in PivotFieldList.

    Please help me to understand what is changed after version 1307.

    Many thanks!
    Davide

  6. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 30 Jan 2013 Link to this post

    Hi Davide,

    We are still not able to reproduce your problem. We haven't changed anything in our connection settings for a long time. Could you use the attached project and test it with your connection settings. If exception occurs, you will see a MessageBox with information about the exception - please send this information to us. Also please send us the Stack Trace when the NullReferenceException occurs, so we could investigate it from our side.

    We'll be waiting for your answer.

    Greetings,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  7. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 30 Jan 2013 Link to this post

    Hi! Now it works!
    I've added the begin and end init methods and now it's perfect!

    Many thanks for very quick support!!

    Regards
    Davide
Back to Top
UI for WPF is Visual Studio 2017 Ready