I'm trying to execute an mdx query in C# and getting exception on calling ExecuteCellSet() on AdomdCommand object,
This is the code snippet
// initialize a new adomdcommand object for the specified connection
objCommand = connection.CreateCommand();
// supply the command text for the adomdcommand object
objCommand.CommandText = queryString;
// attempt to run the command on the cell cellset
try
{
objCellSet = objCommand.ExecuteCellSet();
// return the retrieved cellset
return objCellSet;
}
catch (Exception ex)
{
Console.Write("Exception: " + ex);
objCellSet = null;
return objCellSet;
}
Exception: System.Data.DuplicateNameException: A DataTable named 'UOM' already b
elongs to this DataSet.
at System.Data.DataTableCollection.RegisterName(String name)
at System.Data.DataTableCollection.BaseAdd(DataTable table)
at System.Data.DataTableCollection.Add(DataTable table)
at Microsoft.AnalysisServices.AdomdClient.MDDatasetFormatter.ReadAxesInfo(Xml
Reader reader)
at Microsoft.AnalysisServices.AdomdClient.MDDatasetFormatter.ReadMDDataset(Xm
lReader reader)
at Microsoft.AnalysisServices.AdomdClient.SoapFormatter.ReadDataSetResponsePr
ivate(XmlReader reader)
at Microsoft.AnalysisServices.AdomdClient.SoapFormatter.ReadExecuteResponsePr
ivate(XmlReader reader, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.SoapFormatter.ReadResponse(XmlReade
r reader, Boolean throwOnInlineErrors)
at Microsoft.AnalysisServices.AdomdClient.XmlaClientProvider.Microsoft.Analys
isServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentP
rovider contentProvider, AdomdPropertyCollection commandProperties, IDataParamet
erCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at ceat.excel_writer.ceat_writer.ceat_writer_runQuery(AdomdConnection& connec
tion, String queryString)
When I run the query in MDX sample application editor, it is returning values.
Thanks for your help
DRK12345,
I am having a similar problem. I am wondering whether you solved your problem. Please let me know..
Thanks,
Golf
|||hello,
which version of AS server are you connecting to? If this code works against AS2000, then i think the issue is that an older version of the msolap80 is used. Installing the latest version of msolap80 available should help i think. [can be downloaded for example from http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en (under Microsoft SQL Server 2000 PivotTable Services) or hotfix http://support.microsoft.com/?kbid=819609 could be used as well i think).
hope this helps,
|||Mary,
Installing latest version of msolap80 fixed the problem. Thanks a lot for the help. I appreciate it.
