This is a migrated thread and some comments may be shown as answers.

XMLA Provider Connection Problems

5 Answers 76 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
purdav
Top achievements
Rank 1
purdav asked on 16 Jan 2013, 07:28 AM
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

5 Answers, 1 is accepted

Sort by
0
Milan
Telerik team
answered on 16 Jan 2013, 09:17 AM
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.

0
Milan
Telerik team
answered on 16 Jan 2013, 09:37 AM
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.

0
purdav
Top achievements
Rank 1
answered on 30 Jan 2013, 07:53 AM
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

0
Rosen Vladimirov
Telerik team
answered on 30 Jan 2013, 08:28 AM
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.

0
purdav
Top achievements
Rank 1
answered on 30 Jan 2013, 09:25 AM
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
Tags
PivotGrid
Asked by
purdav
Top achievements
Rank 1
Answers by
Milan
Telerik team
purdav
Top achievements
Rank 1
Rosen Vladimirov
Telerik team
Share this question
or