| MEmerson 2005-09-28, 11:24 am |
| I am getting a DuplicateNameExcepti
on 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]:ClosingPer
iod( [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:
& #91;DuplicateNameExc
eption: A DataTable named 'Order Date' already belongs to
this DataSet.]
System.Data.DataTableCollection.RegisterName(String name) +208
System.Data.DataTableCollection.BaseAdd(DataTable table) +127
System.Data.DataTableCollection.Add(DataTable table) +50
Microsoft.AnalysisServices.AdomdClient.MDDatasetFormatter. ReadAxesInfo(XmlRead
er reader) +299
Microsoft.AnalysisServices.AdomdClient.MDDatasetFormatter. ReadMDDataset(XmlRea
der reader) +116
Microsoft.AnalysisServices.AdomdClient.SoapFormatter. ReadDataSetResponseP
rivate(XmlReader reader) +83
Microsoft.AnalysisServices.AdomdClient.SoapFormatter. ReadExecuteResponseP
rivate(XmlReader reader, Boolean throwOnInlineErrors)
+86
Microsoft.AnalysisServices.AdomdClient.SoapFormatter. ReadResponse(XmlRead
er
reader, Boolean throwOnInlineErrors)
+352
Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider. ExecuteMultidimensio
nal(ICommandContentP
rovider
contentProvider, AdomdPropertyCollect
ion commandProperties,
IDataParameterCollec
tion parameters) +515
Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet() +60
Intranet.Utility.MyMdCommand. ExecuteReader(Comman
dBehavior behavior) +116
System.Data.Common.DbDataAdapter. FillFromCommand(Obje
ct 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. ShippedAndProjectedO
rders..ctor(HttpContext
context, String sDate, String OrderType) +796
Intranet.Selection.Accounting. ShippedAndProjectedO
rders. SetReportObject(Obje
ct sender, ReportArgs& e) +65
Intranet.UserControls.ViewerSubmit. GetReport(ReportArgs
& e) +21
Intranet.UserControls.ViewerSubmit. btnSubmit_Click(Obje
ct sender,
EventArgs e) +744
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI. IPostBackEventHandle
r. RaisePostBackEvent(S
tring eventArgument) +58
System.Web.UI.Page. RaisePostBackEvent(I
PostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page. RaisePostBackEvent(N
ameValueCollection postData) +33
System.Web.UI.Page. ProcessRequestMain()
+1292
|