dbTalk Databases Forums  

DuplicateNameException in ADOMD.NET 8.0.991.0

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DuplicateNameException in ADOMD.NET 8.0.991.0 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MEmerson
 
Posts: n/a

Default DuplicateNameException in ADOMD.NET 8.0.991.0 - 09-28-2005 , 10:43 AM






I am getting a DuplicateNameException in the latest version of ADOMD.NET with
the latest patch applied. I thought this was a bug that was fixed in this
release. Does anyone know what causes this? The full message I get is:

A DataTable named 'Order Date' already belongs to this DataSet

the query I'm running is:

with set [Autoship 6+] as '{[Autoship Cycle].[6]:[Autoship Cycle].[49]}'
set [Date Range] as 'Generate( {[Shipped Date].[Fiscal].[2005-09-01
00:00:00]:ClosingPeriod( [Shipped Date].[Fiscal].[Date], [Shipped
Date].[Fiscal])}, {Ancestor( [Shipped Date].[Fiscal].CurrentMember, [Shipped
Date].[Fiscal].[Week])} )'
member [Autoship Cycle].[6+] as 'aggregate( [Autoship 6+] )'
member [Measures].[Shipped] as '( [Measures].[Count], [Order
Status].[Shipped] )'
select
{[Autoship Cycle].[0]:[Autoship Cycle].[5], [Autoship Cycle].[6+]} on columns,
non empty [Date Range]
properties [Shipped Date].[Fiscal].[Week].[Week], [Shipped
Date].[Fiscal].[Week].[Year]
on rows
from Orders
where ( [Measures].[Shipped] )

The query runs fine in the MDX sample application. The full stack trace is:

[DuplicateNameException: A DataTable named 'Order Date' already belongs to
this DataSet.]
System.Data.DataTableCollection.RegisterName(Strin g name) +208
System.Data.DataTableCollection.BaseAdd(DataTable table) +127
System.Data.DataTableCollection.Add(DataTable table) +50

Microsoft.AnalysisServices.AdomdClient.MDDatasetFo rmatter.ReadAxesInfo(XmlReader reader) +299

Microsoft.AnalysisServices.AdomdClient.MDDatasetFo rmatter.ReadMDDataset(XmlReader reader) +116

Microsoft.AnalysisServices.AdomdClient.SoapFormatt er.ReadDataSetResponsePrivate(XmlReader reader) +83

Microsoft.AnalysisServices.AdomdClient.SoapFormatt er.ReadExecuteResponsePrivate(XmlReader reader, Boolean throwOnInlineErrors) +86

Microsoft.AnalysisServices.AdomdClient.SoapFormatt er.ReadResponse(XmlReader
reader, Boolean throwOnInlineErrors) +352

Microsoft.AnalysisServices.AdomdClient.XmlaClientP rovider.Microsoft.AnalysisServices.AdomdClient.IEx ecuteProvider.ExecuteMultidimensional(ICommandCont entProvider
contentProvider, AdomdPropertyCollection commandProperties,
IDataParameterCollection parameters) +515
Microsoft.AnalysisServices.AdomdClient.AdomdComman d.ExecuteCellSet() +60
Intranet.Utility.MyMdCommand.ExecuteReader(Command Behavior behavior) +116
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Intranet.Reports.ReportBase.Exec(String strQuery, String srcTable,
CommandType cmmType) +284
Intranet.Reports.Accounting.ShippedAndProjectedOrd ers..ctor(HttpContext
context, String sDate, String OrderType) +796

Intranet.Selection.Accounting.ShippedAndProjectedO rders.SetReportObject(Object sender, ReportArgs& e) +65
Intranet.UserControls.ViewerSubmit.GetReport(Repor tArgs& e) +21
Intranet.UserControls.ViewerSubmit.btnSubmit_Click (Object sender,
EventArgs e) +744
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.