Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • I'm getting this error when i try to connect to an OLAP cube, in window 7. I'm publishing my application in a Windows server 2008.
                                    I'm connecting to my cube using an http connection and It works Ok in Excel, and even on my Windows 7 machine, but it doesn't work in Windows Server 2008

                                    What should i do?

                                    Couldn't connect to the Analysis Services. at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.ConnectCore()
                                    at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.set_FullConnectionString(String value)
                                    at DevExpress.XtraPivotGrid.Data.PivotGridData.set_OLAPConnectionString(String value)
                                    at DevExpress.Web.ASPxPivotGrid.Data.PivotGridWebData.set_OLAPConnectionString(String value)
                                    at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.PerformDataBinding(String dataHelperName, IEnumerable dataSource)
                                    at DevExpress.Web.ASPxClasses.Internal.DataHelper.OnDataSourceViewSelectCallback(IEnumerable data)
                                    at DevExpress.Web.ASPxClasses.Internal.DataHelper.PerformSelect()
                                    at DevExpress.Web.ASPxPivotGrid.ASPxPivotGridDataHelper.PerformSelect()
                                    at DevExpress.Web.ASPxClasses.Internal.DataContainer.PerformSelect()
                                    at DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.DataBind()
                                    at Pivote.CambiarConexionOLAP(String Servidor, String BaseDatos, String Cubo)
                                    at Pivote.Page_Load(Object sender, EventArgs e)

                                0

                                Hello Juan,

                                Please review our answer to a similar question in the Support Center:
                                Couldn't connect to the Analysis Services

                                Does it help in your case?

                                Thanks,
                                Nick
                                --------------------
                                Check if Search Engine is able to answer questions faster than I do!

                                0

                                Yes, It solved my problems. Thanks

                                0

                                Sorry, but I'm getting this error now. I'm loading a Layout saved into my database. My Cube and database are in my Windows 7 machine 32bit, my page is on a Server 2008 64bits. Can this be a problem?

                                File system error: The following error occurred while reading from the file 'Compressed stream'.
                                Either a connection cannot be made to the oaguilar server, or Analysis Services is not running on the computer specified. at System.Data.OleDb.OleDbConnectionInternal.ProcessResults(OleDbHResult hr)
                                at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
                                at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
                                at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.GetHierarchies()
                                at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.PopulateColumns()
                                at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.DoRefreshCore(PivotGridFieldReadOnlyCollection sortedFields)
                                at DevExpress.XtraPivotGrid.Data.PivotGridOLAPDataSource.DevExpress.XtraPivotGrid.Data.IPivotGridDataSource.DoRefresh(PivotGridFieldReadOnlyCollection sortedFields)
                                at DevExpress.XtraPivotGrid.Data.PivotGridData.DoRefreshCore()
                                at DevExpress.Web.ASPxPivotGrid.Data.PivotGridWebData.DoRefreshCore()
                                at DevExpress.XtraPivotGrid.Data.PivotGridData.DoRefresh()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshDataCore()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshData()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.CreateControlHierarchy()
                                at DevExpress.Web.ASPxClasses.ASPxWebControlBase.CreateChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxWebControl.CreateChildControls()
                                at System.Web.UI.Control.EnsureChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxWebControlBase.EnsureChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.DataBind()
                                at Pivote.CambiarConexionOLAP(String Servidor, String BaseDatos, String Cubo)
                                at Pivote.Page_Load(Object sender, EventArgs e)

                                0

                                Hi Juan,

                                From your stack trace I see that error occurs in a system assembly (System.Data.OleDb.OleDbConnectionInternal.ProcessResults) and the message is:
                                "Either a connection cannot be made to the oaguilar server, or Analysis Services is not running on the computer specified."

                                Oaguilar is your server. Please check if you can connect to it from your Windows Server 2008 system. In addition, make sure that the Analysis Services service is running on Oaguilar.

                                The following articles may help you find a solution:
                                http://www.google.com/search?q=Either+a+connection+cannot+be+made+to+the+server%2C+or+Analysis+Services+is+not+running+on+the+computer+specified

                                Thanks,
                                Nick
                                --------------------
                                Check if Search Engine is able to answer questions faster than I do!

                                0

                                I reviewed some of that links, but, i am confused. Why i can get successfully a connection using Excel in my server, and using oledb connections in my web application? I 'm only having troubles with my XtraPivotGrid.

                                0

                                this is the connection I'm using. It works perfectly on Excel, and other pages using this conection
                                Provider=MSOLAP.3;Data Source=http://oaguilar/olap/msmdpump.dll;Initial catalog=ALIMER;Cube Name=Facturacion

                                I'm getting this error first..

                                *******
                                Failed to compare two elements in the array.
                                at System.Collections.Generic.ArraySortHelper`1.Sort(T[] keys, Int32 index, Int32 length, IComparer`1 comparer)
                                at System.Array.Sort[T](T[] array, Int32 index, Int32 length, IComparer`1 comparer)
                                at System.Collections.Generic.List`1.Sort(Int32 index, Int32 count, IComparer`1 comparer)
                                at DevExpress.XtraPivotGrid.PivotGridGroup.OnInsertComplete(Int32 index, Object obj)
                                at DevExpress.XtraPivotGrid.PivotGridGroup.Add(PivotGridFieldBase field)
                                at DevExpress.XtraPivotGrid.PivotGridFieldCollectionBase.GroupFieldsByHierarchies()
                                at DevExpress.Web.ASPxPivotGrid.Data.PivotGridWebData.DoRefreshCore()
                                at DevExpress.XtraPivotGrid.Data.PivotGridData.DoRefresh()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshDataCore()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshData()
                                at DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.CreateControlHierarchy()
                                at DevExpress.Web.ASPxClasses.ASPxWebControlBase.CreateChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxWebControl.CreateChildControls()
                                at System.Web.UI.Control.EnsureChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxWebControlBase.EnsureChildControls()
                                at DevExpress.Web.ASPxClasses.ASPxDataWebControlBase.DataBind()
                                at Pivote.Page_Load(Object sender, EventArgs e)

                                0

                                Hello Juan,

                                >Why i can get successfully a connection using Excel in my server, and using oledb connections
                                >in my web application? I 'm only having troubles with my XtraPivotGrid.
                                The ASPxPivotGrid in OLAP mode connects to a different server than OleDB. In addition, ASP.NET also runs under a different user account than the one you use to log in:
                                http://www.google.com/search?q=asp.net+user+account

                                Both peculiarities must be taken into account for successful connecting from ASP.NET to an OLAP server.

                                >Failed to compare two elements in the array.
                                It looks like you have successfully connected to your OLAP server, haven't you? Please send your test project and cube. We will find a solution after reproducing the problem on our system.

                                Thanks,
                                Nick
                                --------------------
                                Check if Search Engine is able to answer questions faster than I do!

                                To start a chat you should create a support ticket


                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners