OLAP Connection not showing any data from cube

[Jim]

Hello,
   I am connecting to my SSAS server but I am no showing any data when the page loads, no fields in the Configuration Panel as well.  I know my connection string is correct because we currently use it with an OWC control we hope to replace with the PivotGrid, and I can also connect through Excel.  I have tried connection both through the HTML markup as well as the code behind:

<OlapSettings ProviderType="Adomd">
              <AdomdConnectionSettings
                  Cube="Leads"
                  DataBase="DBName"
                  ConnectionString="Provider=MSOLAP.5;Data Source=ServerName;User ID=webuser;Initial Catalog=DBName;" >

              </AdomdConnectionSettings>
          </OlapSettings>

I have not defined any columns as the examples I have seen on  your site have not shown that they need to be predefined, which would defeat the purpose of the control.
I have also tried in the code behind:

rpg.OlapSettings.ProviderType = Telerik.Web.UI.PivotGridOlapProviderType.Adomd
     rpg.OlapSettings.AdomdConnectionSettings.Cube = "Leads"
     rpg.OlapSettings.AdomdConnectionSettings.DataBase = "DBName"
     rpg.OlapSettings.AdomdConnectionSettings.ConnectionString = "Provider=MSOLAP.5;Data Source=ServerName;User ID=XXX;Initial Catalog=DBName;"

Is there is something I am missing or I am doing wrong?  I have been through the threads here and checked numerous examples, but just can't seem to get it.
Any help would be great.  I am getting frustrated

Thanks,
Jim

[Radoslav]

Hello Jim,

Could you please confirm that you have added the Microsoft.AnalysisServices library into the Bin folder or into GAC as is described into the following help article:
http://www.telerik.com/help/aspnet-ajax/pivotgrid-olap-support.html (Binding Through Adomd section)
Looking forward for your reply.

Regards,
Radoslav
Telerik

 

 

[Jim]

Yes, I have added that dll to the bin folder of my project.
Also, I forgot to add that I am trying to connect to SSAS 2000.  Not sure if the version matters.
Thanks

[Jim]

After digging through the control, I found an event DataProviderError where I can check for an error.  Not sure why it is just not displayed but this is the exception:

Adomd communication error
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port) at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) --- End of inner exception stack trace --- at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.ConnectAndGetMetadata() at Telerik.Web.UI.PivotGrid.DataProviders.Adomd.AdomdMetadataLoader.LoadData

I have no idea what this means or how to fix it.  If anyone has any ideas, please post.
Thanks,
Jim

[Radoslav]

Hi Jim,

The described issue is very strange and we have not encounter it so far and we are not sure what could be the reason for it. Could you please confirm that you have the right permissions? I am sending you a simple example which can be used for testing the adomd connection. The example uses the code provided from MS for connecting to the cube. Please check it out and let me know if it works in your case.
Also you can check out the following posts which elaborate on the same matter:
http://support.dundas.com/Dashboard5.SSAS_Connectivity.ashx
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ab329ec9-6bb7-45d5-8098-5e82b0d322fc/adomdconnectionexception-a-connection-cannot-be-made-ensure-that-the-server-is-running?forum=sqlintegrationservices

Looking forward for your reply.

Regards,
Radoslav
Telerik

 

 

[Jim]

Permissions are not the issue.  I can connect to the cubes from another application using the same credentials, but in that app we are using an OWC control.  This is the error I get when I use the code you provided (the error happens on line 19 (.open()).

The requested name is valid, but no data of the requested type was found
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: The requested name is valid, but no data of the requested type was found

Source Error:


Line 17:         'In the connection string you can specify Integrated Security=SSPI. UserName and password are not required for this level of security.
Line 18:         'In the connection string you can specify Integrated Security=Basic. UserName and Password are mandatory for this level of security.
Line 19:         cubeConnection.Open()
Line 20:         Dim cube = cubeConnection.Cubes("Leads")
Line 21:         If cube IsNot Nothing Then

[Radoslav]

Hello Jim,

It seems that the problem is not related with the control, because the project which I sent you uses the Microsoft approach for connecting to the olap cube via the ADOMD.
Could you please try using the IP of the server instead of the server name and let me know if the problem still exists.  Also could you please verify that the
Additionally more information about connectivity issues you can find here:
http://technet.microsoft.com/en-us/library/cc917670.aspx
http://forums.asp.net/t/1895307.aspx?The+requested+name+is+valid+but+no+data+of+the+requested+type+was+found

Looking forward for your reply.

Regards,
Radoslav
Telerik

 

 

[Jim]

I have tried using the IP of the server using 3 different ports the network admin gave me that are open.  
I have also already seen the 2 links you have sent.  Nothing in them was of any help to me.
I am not sure if you saw that I said that the analysis server is 2000.  Could this be an issue?

Thanks
Jim

[Radoslav]

Hello Jim,

The analysis server 2000 and the AdomdClient version 10 can be a problem. Which version of the Microsoft.AnalysisServices library do you use? If you use version 10 it is shipped with Microsoft SQL Server 2008 R2 Feature Pack. However for the older version like 2000 there is ADOMD.NET 8.0 and ADOMD.NET 9.0. Could you please try using 9.0 version of the client and let me now if this helps. Also more information you can find here:
http://technet.microsoft.com/en-us/library/ms345077%28v=sql.105%29.aspx
Additionally at meantime could you please try connecting to the olap cube via Excel with the same connection and credentials and let me now the result. On the following link you can find example how to achieve this:
http://office.microsoft.com/en-001/excel-help/connect-to-import-an-olap-database-HP010167299.aspx
Also could you please try removing the “MSOLAP.5” from the connection string and let me know if the issue still persists.

Looking forward for your reply.

Regards,
Radoslav
Telerik

 

 

[Jim]

Thank you for the reply

I have added the v9.0 dll to my bin.
I have also tried MSOLAP and MSOLAP.2.

I am still receiving the same error message.

As mentioned in a previous post, I am able to connect to the cubes via Excel and an old OWC control 

thanks,
Jim

[Radoslav]

Hi Jim,

We did not have any other similar reported issue and we are not sure what could be the reason for experiencing the described problem. However since the problem is not related with our control we cannot do much here. I can suggest you to open a thread here:  https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices and to see if someone else can help you with your case. 

Regards,
Radoslav
Telerik

 

 

[Jim]

Thanks for you time and replies.
At this point we are going to be upgrading our SSAS to 2008 and then move to 2012.  I have a feeling this could be the issue.
I will post back with any info I get.

Again, thanks for the time.

Jim

[Jacob]

Hello Jim,

Can you let me know if you resolved this issue? I have a user that is getting the same error message as you. He is remotely accessing an excel document that has connections to our cube.

[Jim]

Sorry.  I never did get this resolved.  We have a developer that is fluent in SSRS and moved all our reporting there.  I believe the SSAS servers were upgraded to 2012 as well.  I just gave up on the control after having these issues and not getting it to work.

Good luck

[Vasil]

Hello,

Seems that the SocketException can have SocketError message 11004 with 2 different texts depending on the localization:

-The requested name is valid, but no data of the requested type was found.
-The requested name or IP address was not found on the name server.

Which is a bit confusing. Once you can search by the error code, you can find more information and suggestions like:
http://stackoverflow.com/questions/6856534/gethostentry-doesnt-resolve-the-address-anymore

This one look a bit strange, but easy to confirm:
http://stackoverflow.com/questions/13935839/sftp-connectivity-dns-issue-system-net-sockets-socketexception-the-requested
Check if the host does not have slash at the end.

Moreover the TcpClient does not fire the exception itself. From the original callstack it looks that it happens in the constructor, but if you check the code then you could assume that the issue is inside tcpClient.Connect(hostname, port). The exception is not handled, but cached in the constructor and thrown again.

So I would also search for errors with tcpClient.Connect since they may be connected to the problem.

Regards,
Vasil
Telerik by Progress