I've migrated project from 13.2.8.
The project uses ASPxPivotGrid that access OLAP MSSQL 2000 (SP4) using OLEDB MSOLAP.2 provider.
OlapConnectionString used is "Provider=MSOLAP.2; Data Source=olapSrv; Initial Catalog=FDB; Locale Identifier=1045;Cube Name=xxx"
Accessing OLAP gives OleDBException with "Invalid cell property specified LANGUAGE".
It seems that MDX generated by 15.1.8 contains "CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE"
Cell property LANGUAGE is not supported in that olap version.
Please provide the possibility to remove that property from generated MDX in some way (DevExpress.XtraPivotGrid.PivotGridOptionsOLA?, OLEDB.MSOLAP2 in DevExpress.XtraPivotGrid.OLAPDataProvider enum, autodetect from OlapConnectionString) otherwise the PivotGrid controls will not be compatibile with MS OLAP 2000 SP4 as documentation reads in
https://documentation.devexpress.com/#AspNet/CustomDocument11780
Full stack trace:
[OleDbException (0x80004005): Invalid cell property specified LANGUAGE.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1165720 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult) +140 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +158 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +162 System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +110 System.Data.OleDb.OleDbCommand.ExecuteReader() +6 DevExpress.PivotGrid.OLAP.OleCellSetParser.ExecuteReader(IOLAPCommand command) +57 [OleDbErrorResponseException: Invalid cell property specified LANGUAGE.] DevExpress.PivotGrid.OLAP.OleCellSetParser.ExecuteReader(IOLAPCommand command) +107 DevExpress.PivotGrid.OLAP.OleCellSetParser.QueryData(IOLAPCommand command, IQueryContext`1 context) +30 DevExpress.PivotGrid.OLAP.OLAPDataSourceQueryExecutor.QueryData(IQueryContext`1 context) +514 [OLAPException: Failed to execute an MDX Query] DevExpress.PivotGrid.QueryMode.QueryExecutorBase`2.TryHandleException(QueryHandleableException raisedException, IDataSourceHelpersOwner`1 desiredOwner, Boolean force) +168 DevExpress.PivotGrid.OLAP.OLAPDataSourceQueryExecutor.QueryData(IQueryContext`1 context) +597 DevExpress.PivotGrid.QueryMode.QueryExecutorBase`2.DevExpress.PivotGrid.QueryMode.IQueryExecutor<TColumn>.QueryData(IDataSourceHelpersOwner`1 owner, IQueryContext`1 context) +102 DevExpress.PivotGrid.QueryMode.QueryMetadata`1.QueryData(IDataSourceHelpersOwner`1 owner, IQueryContext`1 context) +55 DevExpress.PivotGrid.QueryMode.QueryDataSource`1.QueryData(GroupInfo[] columns, GroupInfo[] rows, Boolean columnExpand, Boolean rowExpand) +90 DevExpress.PivotGrid.QueryMode.QueryDataSource`1.DoRefreshCore() +755 DevExpress.PivotGrid.QueryMode.QueryDataSource`1.DevExpress.XtraPivotGrid.Data.IPivotGridDataSource.DoRefresh() +5 DevExpress.XtraPivotGrid.Data.PivotGridData.DoRefreshCore() +48 DevExpress.Web.ASPxPivotGrid.Data.PivotGridWebData.DoRefreshCore() +169 DevExpress.XtraPivotGrid.Data.PivotGridData.DoRefresh() +43 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshDataCore() +348 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.PerformDataRefresh() +165 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.RefreshData(Boolean force) +74 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.CreateControlHierarchy() +76 DevExpress.Web.ASPxWebControlBase.CreateChildControls() +113 DevExpress.Web.ASPxWebControl.CreateChildControls() +138 System.Web.UI.Control.EnsureChildControls() +83 DevExpress.Web.ASPxWebControlBase.EnsureChildControls() +4 DevExpress.Web.ASPxDataWebControlBase.DataBindInternal() +119 DevExpress.Web.ASPxWebControl.DataBind() +37 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.get_ChartDataSourceView() +65 DevExpress.Web.ASPxPivotGrid.ASPxPivotGrid.System.Web.UI.IDataSource.GetView(String viewName) +42 DevExpress.Web.Internal.DataHelperCore.GetView() +227 DevExpress.Web.Internal.DataHelper.ConnectToData() +9 DevExpress.Web.Internal.DataHelperBase.Load() +15 DevExpress.Web.Internal.DataContainer.Load() +137 DevExpress.Web.ASPxDataWebControlBase.OnLoad(EventArgs e) +22 System.Web.UI.Control.LoadRecursive() +54 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
Just wanted to drop you a note to let you know that we need a bit more time to finish working on our answer to your inquiry. Thanks so much for your patience.
It will require some time to research it in greater detail. I have passed this issue to our developers for further research. We will update the thread once we have any results.