OLAP Connection not showing any data from cube

15 posts, 0 answers
  1. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 13 Oct 2014 Link to this post

    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
  2. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 16 Oct 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 16 Oct 2014 in reply to Radoslav Link to this post

    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
  5. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 16 Oct 2014 in reply to Jim Link to this post

    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
  6. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 21 Oct 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 21 Oct 2014 in reply to Radoslav Link to this post

    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
  8. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 23 Oct 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  9. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 23 Oct 2014 in reply to Radoslav Link to this post

    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
  10. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 27 Oct 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  11. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 27 Oct 2014 in reply to Radoslav Link to this post

    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
  12. Radoslav
    Admin
    Radoslav avatar
    1564 posts

    Posted 29 Oct 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  13. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 29 Oct 2014 in reply to Radoslav Link to this post

    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
  14. Jacob
    Jacob avatar
    1 posts
    Member since:
    Oct 2016

    Posted 19 Oct Link to this post

    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.

  15. Jim
    Jim avatar
    14 posts
    Member since:
    Aug 2013

    Posted 19 Oct in reply to Jacob Link to this post

    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

  16. Vasil
    Admin
    Vasil avatar
    1547 posts

    Posted 20 Oct Link to this post

    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
    Check out the new UI for ASP.NET Core, the most complete UI suite for ASP.NET Core development on the market, with 60+ tried-and-tested widgets, based on Kendo UI.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017