in-process XML (IXMLA)   

I am using an IXMLA (CS is DataSource=xxx;Initial Catalog=xxx;ConnectTo=8.0)  
I however receive an error while executing one of the MDX which reads like 
this

Microsoft.AnalysisServices.AdomdClient.AdomdUnknownResponseException: The 
server sent an unrecognizable response. ---> System.Xml.XmlException: An 
error occurred while parsing EntityName. Line 337, position 75.

My C# code is

AdomdCommand cmd = new AdomdCommand(p_commandTxt, conn);
cellset = cmd.ExecuteCellSet();	

MDX I am passing p_commandTxt is 
Select 
{[Roles].&[2],[Roles].&[3],[Roles].&[4],[Roles].&[5],[Roles].&[6],[Roles].&[7],[Roles].&[15]} 
on Axis(0),{[Companies].&[3174],[Companies].&[3116],[Companies].&[29]} on 
Axis(1),{[Type].&[2],[Type].&[3]} on Axis(2),{[Ver].&[2]} on 
Axis(3),{[Year].&[4]} on Axis(4),{[Segments].&[3116]} on 
Axis(5),{[Plan].&[1]} on Axis(6) From CUBE2 WHERE ([Submitor].&[16])

The MDX is fine and I have looked at one of Akshais respone to encode & to 
& but still it seems to fail.

Could anyone please tell me why this occurs?

date: Wed, 1 Jun 2005 04:00:01 -0700   author:   Sid

Re: in-process XML (IXMLA)   

This doesn't look like an issue with your query but more probably a bug in
the response... Would it be possible to install the XMLA SDK 1.1 and run
this query against that? We could then see is wrong with line 337 in the
response.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Sid"  wrote in message
news:D80C9BB7-52A3-4E9C-AF4A-D7FC64244B93@microsoft.com...
> I am using an IXMLA (CS is DataSource=xxx;Initial
Catalog=xxx;ConnectTo=8.0)
> I however receive an error while executing one of the MDX which reads like
> this
>
> Microsoft.AnalysisServices.AdomdClient.AdomdUnknownResponseException: The
> server sent an unrecognizable response. ---> System.Xml.XmlException: An
> error occurred while parsing EntityName. Line 337, position 75.
>
> My C# code is
>
> AdomdCommand cmd = new AdomdCommand(p_commandTxt, conn);
> cellset = cmd.ExecuteCellSet();
>
> MDX I am passing p_commandTxt is
> Select
>
{[Roles].&[2],[Roles].&[3],[Roles].&[4],[Roles].&[5],[Roles].&[6],[Roles].&[
7],[Roles].&[15]}
> on Axis(0),{[Companies].&[3174],[Companies].&[3116],[Companies].&[29]} on
> Axis(1),{[Type].&[2],[Type].&[3]} on Axis(2),{[Ver].&[2]} on
> Axis(3),{[Year].&[4]} on Axis(4),{[Segments].&[3116]} on
> Axis(5),{[Plan].&[1]} on Axis(6) From CUBE2 WHERE ([Submitor].&[16])
>
> The MDX is fine and I have looked at one of Akshais respone to encode & to
> & but still it seems to fail.
>
> Could anyone please tell me why this occurs?

date: Tue, 7 Jun 2005 10:24:39 -0700   author:   Akshai Mirchandani [MS]