Bug Report T320212
Visible to All Users

'Cell property LANGUAGE is not supported in that olap version' exception is raised on requesting data from MSAS 2000 SP4 server

created 9 years ago

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

Comments (2)
DevExpress Support Team 9 years ago

    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.

    DevExpress Support Team 9 years ago

      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.

      Answers approved by DevExpress Support

      created 9 years ago (modified 9 years ago)

      We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

      Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.