Re: XMLA :Unable to process the request, datasourceinfo property was missing or incorrectly specified

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 15:28:26 -0700

I think the problem is that the properties you are creating are not in the
XMLA namespace. Please take a look at the Sample.NET code to see how it
constructs the properties in the correct namespace.

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.
"Prasanna" <tawargerip@hotmail.com> wrote in message
news:d4b0bad7.0406092218.729a125d@posting.google.com...
> Hi,
> I am passing parameters after constructing as below
>
> prop is the parameter passed to XMLA execute
>
> prop="<PropertyList><DataSourceInfo>Client Cache Size=150;Execution
> Location=3;Default Isolation Mode";
> prop=
prop+"=1;"+dbinfo+"</DataSourceInfo><Format>Multidimensional</Format><Catalo
g>"+catlog+"</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Con
tent></PropertyList>";
>
> result of prop is as below
> ======================================
> prop =<PropertyList><DataSourceInfo>Client Cache Size=150;Execution
> Location=3;Default Isolation Mode=1;Provider=MSOLAP;Data
>
Source=local</DataSourceInfo><Format>Multidimensional</Format><Catalog>IMSAM
E</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content></Prop
ertyList>
> =======================================
>
> XmlDocument xmldoc = new XmlDocument();
> xmldoc.LoadXml("<root/>");
> XmlElement newElem = xmldoc.CreateElement("Statement");
> newElem.InnerText = strMDX+where;
> xmldoc.DocumentElement.AppendChild(newElem);
>
> cmd = xmldoc.FirstChild.InnerXml;
> {
>    strXML= Execute(cmd,prop);
> }
>
>
> datasource.xml file has Datasource info property mentined as below
> <DataSourceInfo>Provider=MSOLAP;Data Source=local</DataSourceInfo>
>
>
> Execute function is as below
>
>
>
============================================================================
==
> private static string Execute( string Command, string Properties)
> {
> try
> {
> // Create the Xml for Analysis proxy class
> MsXmlAnalysis xa = new MsXmlAnalysis();
> // This line is to make sure that
> // we pass the IIS security checks
> // without any problem. Theoretically, this
> // should not be necessary, but sometimes,
> // when you generate a proxy class using
> // wsdl.exe, it creates a problem, so it's
> // better to include the following line
> xa.Credentials =
> System.Net.CredentialCache.DefaultCredentials;
>
> //server url
> String url1;
>
>
url1=System.Configuration.ConfigurationSettings.AppSettings["RB.IMS.WebServi
ces.MSXMLAURL"].ToString();
> xa.Url =
System.Configuration.ConfigurationSettings.AppSettings["RB.IMS.WebServices.M
SXMLAURL"].ToString();
> XmlDocument queryDom = new XmlDocument();
>
>
> XmlDocument  restrictDom = new XmlDocument();
> XmlElement  xelem1;
> XmlElement  xelem2;
> XmlElement  xelem3;
>
> // Load the command and propertylist into a DOM
> // and cast them to an element
> queryDom.LoadXml(Command);
> restrictDom.LoadXml(Properties);
> xelem1 = (XmlElement) queryDom.FirstChild;
> xelem2 = (XmlElement) restrictDom.FirstChild;
>
> // Call the execute method
> xelem3 = xa.Execute(xelem1, xelem2);
>
> // return the resulting XML
> return xelem3.InnerXml;
> }
> catch(Exception err)
> {
> throw err;
> }
> }
> =================================================================
>
>
> the execution leads to error goes into catch saying "Unable to process
> the request because datasourceinfo property was missing or incorrectly
> specified"
>
>
> Can any one help me pointing out what is wrong in my code
>
>
> Rregards
> Prasanna

Relevant Pages

  • Re: XMLA :Unable to process the request, datasourceinfo property was missing or incorrectly specifie
    ... You should specify the DataSourceName in DataSourceInfo when ... > prop is the parameter passed to XMLA execute ... > XmlDocument xmldoc = new XmlDocument; ... > private static string Execute(string Command, ...
    (microsoft.public.data.xmlanalysis)
  • Re: How to get the "raw" XML document returned from a web service
    ... end if it a string or XMlNode, or XmlElement, typically a XmlNode will ... accept a XmlDocument or XmlElement. ... can be the Xml within an Xmldocument. ... So if they want it as a string of Xml you again can use ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • RE: using myXslDoc.Transform
    ... One potential option for dynamically loading an XmlDocument from the ... retrieved as a string. ... Retrieve the XML content from the database ... Dim strXml As String ...
    (microsoft.public.dotnet.xml)
  • Bug found in XmlDocument when using doctype tag (such as for xhtml
    ... Let's see the doctype: ... If you use an XmlDocument to handel this xml file: ... public XmlDocumentType CreateDocumentType(string name, string publicId, ... string systemId, string internalSubset) method. ...
    (microsoft.public.dotnet.framework)
  • RE: using myXslDoc.Transform
    ... Given a string of XSL, you can load the XslTransform with an XmlReader. ... 'get xml file from the database and load xml file ... Dim strXML As String = SqlHelper.ExecuteScalar(cn, ... Dim myXmlDoc As XmlDocument = New XmlDocument ...
    (microsoft.public.dotnet.xml)