XMLA 1.1 'Execute'-requests - SOAP/XML namespace problems - Bug? - Where to submit?

From: Marek Pikulski (marek_at_pikulski.net)
Date: 08/05/04

  • Next message: Akshai Mirchandani [MS]: "Re: XMLA 1.1 'Execute'-requests - SOAP/XML namespace problems - Bug? - Where to submit?"
    Date: Thu, 5 Aug 2004 12:12:04 +0200
    
    

    Hi,

    I'm encountering the following (strange) problem when using the XMLA 1.1
    provider (released 5/14/2004) to access an Analysis Server. The error does
    not occur with the beta version of the XMLA SDK (released 8/6/2003).

    The attached SOAP request 'Execute.request.bad.xml' results in a SOAP-Fault
    ('Execute.Reply.bad.xml'). The error message is german and corresponds to
    '[Microsoft][ODBC Driver Manager] Data source name not found and no default
    driver specified' (XA:XMLAnalysisError.80004005).

    According to some newsgroup posts this error usually indicates a database
    connection problem. The strange thing about it is that if I modify the
    Execute-request to look like 'Execute.request.ok.xml' it simply works!

    The only difference between the two requests is the use of namespaces:

    the following request results in the error mentioned above:

    <SOAP-ENV:Envelope [...] xmlns:ns1="urn:schemas-microsoft-com:xml-analysis">
        <SOAP-ENV:Body>
            <ns1:Execute>
                [...]
            </ns1:Execute>
        </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    while the one below works fine:

    <SOAP-ENV:Envelope [...]>
        <SOAP-ENV:Body>
            <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
                [...]
            </Execute>
        </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    In my opinion the differences between the requests are only syntactic.
    That's why I suppose this behaviour to be a bug, not an error in my setup.
    Also interesting: The 'Discover'-request supports both types of namespace
    use. So this probably isn't a problem with the SOAP/XML functions, but a
    misbehaviour of the XMLA provider.

    Any ideas? Where else could I submit this (as a bug report?) ?

    Thank you for any comments and/or answers

    Marek Pikulski
    marek@pikulski.net

    begin 666 Discover.request.xml
    M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX-"@T*/%-/
    M05 M14Y6.D5N=F5L;W!E("!X;6QN<SI33T%0+45.5CTB:'1T<#HO+W-C:&5M
    M87,N>&UL<V]A<"YO<F<O<V]A<"]E;G9E;&]P92\B#0H@>&UL;G,Z>'-D/2)H
    M='1P.B\O=W=W+G<S+F]R9R\R,# Q+UA-3%-C:&5M82(-"B!X;6QN<SIX<VD]
    M(FAT=' Z+R]W=W<N=S,N;W)G+S(P,#$O6$U,4V-H96UA+6EN<W1A;F-E(@T*
    M('AM;&YS.E-/05 M14Y#/2)H='1P.B\O<V-H96UA<RYX;6QS;V%P+F]R9R]S
    M;V%P+V5N8V]D:6YG+R(-"B!X;6QN<SIN<S0](G5R;CIS8VAE;6%S+6UI8W)O
    M<V]F="UC;VTZ>&UL+6%N86QY<VES(@T*(%-/05 M14Y6.F5N8V]D:6YG4W1Y
    M;&4](FAT=' Z+R]S8VAE;6%S+GAM;'-O87 N;W)G+W-O87 O96YC;V1I;F<O
    M(CX-"CQ33T%0+45.5CI";V1Y/@T*#0H\;G,T.D1I<V-O=F5R/@T*/%)E<75E
    M<W14>7!E('AS:3IT>7!E/2)X<V0Z<W1R:6YG(CY$25-#3U9%4E]$051!4T]5
    M4D-%4SPO4F5Q=65S=%1Y<&4^#0H\4')O<&5R=&EE<SX-"CQ0<F]P97)T>4QI
    M<W0O/CPO4')O<&5R=&EE<SX-"CQ297-T<FEC=&EO;G,^#0H\4F5S=')I8W1I
    M;VY,:7-T+SX\+U)E<W1R:6-T:6]N<SX\+VYS-#I$:7-C;W9E<CX-"CPO4T]!
    C4"U%3E8Z0F]D>3X-"CPO4T]!4"U%3E8Z16YV96QO<&4^#0H`
    `
    end

    begin 666 Execute.Reply.bad.xml
    M/#]X;6P@=F5R<VEO;CTB,2XP(C\^#0H\4T]!4"U%3E8Z16YV96QO<&4@>&UL
    M;G,Z4T]!4"U%3E8](FAT=' Z+R]S8VAE;6%S+GAM;'-O87 N;W)G+W-O87 O
    M96YV96QO<&4O(B!33T%0+45.5CIE;F-O9&EN9U-T>6QE/2)H='1P.B\O<V-H
    M96UA<RYX;6QS;V%P+F]R9R]S;V%P+V5N8V]D:6YG+R(^#0H\4T]!4"U%3E8Z
    M0F]D>3X-"CQ33T%0+45.5CI&875L="!X;6QN<SI803TB=7)N.G-C:&5M87,M
    M;6EC<F]S;V9T+6-O;3IX;6PM86YA;'ES:7,B/@T*/&9A=6QT8V]D93Y803I8
    M34Q!;F%L>7-I<T5R<F]R+C@P,# T,# U/"]F875L=&-O9&4^#0H\9F%U;'1S
    M=')I;F<^6TUI8W)O<V]F=%U;3T1"0R!$<FEV97(@36%N86=E<ET@1&5R($1A
    M=&5N<75E;&QE;FYA;64@=W5R9&4@;FEC:'0@9V5F=6YD96XL('5N9"!E<R!W
    M=7)D92!K96EN(%-T86YD87)D=')E:6)E<B!A;F=E9V5B96X\+V9A=6QT<W1R
    M:6YG/@T*/&9A=6QT86-T;W(^=7)N.G-C:&5M87,M;6EC<F]S;V9T+6-O;3IX
    M;6PM86YA;'ES:7,\+V9A=6QT86-T;W(^#0H\9&5T86EL/@T*/$5R<F]R($5R
    M<F]R0V]D93TB,C$T-S4P,# S-R(@1&5S8W)I<'1I;VX](EM-:6-R;W-O9G1=
    M6T]$0D,@1')I=F5R($UA;F%G97)=($1E<B!$871E;G%U96QL96YN86UE('=U
    M<F1E(&YI8VAT(&=E9G5N9&5N+"!U;F0@97,@=W5R9&4@:V5I;B!3=&%N9&%R
    M9'1R96EB97(@86YG96=E8F5N(B!3;W5R8V4](G5R;CIS8VAE;6%S+6UI8W)O
    M<V]F="UC;VTZ>&UL+6%N86QY<VES(B\^/"]D971A:6P^/"]33T%0+45.5CI&
    I875L=#X\+U-/05 M14Y6.D)O9'D^/"]33T%0+45.5CI%;G9E;&]P93X`
    `
    end

    begin 666 Execute.request.bad.xml
    M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX-"@T*/%-/
    M05 M14Y6.D5N=F5L;W!E("!X;6QN<SI33T%0+45.5CTB:'1T<#HO+W-C:&5M
    M87,N>&UL<V]A<"YO<F<O<V]A<"]E;G9E;&]P92\B#0H@>&UL;G,Z>'-D/2)H
    M='1P.B\O=W=W+G<S+F]R9R\R,# Q+UA-3%-C:&5M82(-"B!X;6QN<SIX<VD]
    M(FAT=' Z+R]W=W<N=S,N;W)G+S(P,#$O6$U,4V-H96UA+6EN<W1A;F-E(@T*
    M('AM;&YS.E-/05 M14Y#/2)H='1P.B\O<V-H96UA<RYX;6QS;V%P+F]R9R]S
    M;V%P+V5N8V]D:6YG+R(-"B!X;6QN<SIN<S0](G5R;CIS8VAE;6%S+6UI8W)O
    M<V]F="UC;VTZ>&UL+6%N86QY<VES(@T*(%-/05 M14Y6.F5N8V]D:6YG4W1Y
    M;&4](FAT=' Z+R]S8VAE;6%S+GAM;'-O87 N;W)G+W-O87 O96YC;V1I;F<O
    M(CX-"CQ33T%0+45.5CI";V1Y/@T*#0H\;G,T.D5X96-U=&4^#0H\0V]M;6%N
    M9#X-"CQ3=&%T96UE;G0@>'-I.G1Y<&4](GAS9#IS=')I;F<B/G-E;&5C= H)
    M"0E[(%M-96%S=7)E<UTN6U5N:71S(%-H:7!P961=+"!;365A<W5R97-=+EM5
    M;FET<R!/<F1E<F5D72!](&]N(&-O;'5M;G,L"@D)"4Y/3B!%35!462!;4W1O
    M<F5=+EM3=&]R92!.86UE72YM96UB97)S(&]N(')O=W,*"0EF<F]M(%=A<F5H
    M;W5S93PO4W1A=&5M96YT/CPO0V]M;6%N9#X-"CQ0<F]P97)T:65S/@T*/%!R
    M;W!E<G1Y3&ES=#X-"CQ$871A4V]U<F-E26YF;R!X<VDZ='EP93TB>'-D.G-T
    M<FEN9R(^3&]C86P@06YA;'ES:7,@4V5R=F5R/"]$871A4V]U<F-E26YF;SX-
    M"CQ#871A;&]G('AS:3IT>7!E/2)X<V0Z<W1R:6YG(CY&;V]D;6%R=" R,# P
    M/"]#871A;&]G/@T*/$-O;G1E;G0@>'-I.G1Y<&4](GAS9#IS=')I;F<B/D1A
    M=&$\+T-O;G1E;G0^#0H\1F]R;6%T('AS:3IT>7!E/2)X<V0Z<W1R:6YG(CY-
    M=6QT:61I;65N<VEO;F%L/"]&;W)M870^/"]0<F]P97)T>4QI<W0^/"]0<F]P
    M97)T:65S/CPO;G,T.D5X96-U=&4^#0H\+U-/05 M14Y6.D)O9'D^#0H\+U-/
    205 M14Y6.D5N=F5L;W!E/@T*
    `
    end

    begin 666 Execute.request.ok.xml
    M/#]X;6P@=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB551&+3@B/SX-"@T*/%-/
    M05 M14Y6.D5N=F5L;W!E("!X;6QN<SI33T%0+45.5CTB:'1T<#HO+W-C:&5M
    M87,N>&UL<V]A<"YO<F<O<V]A<"]E;G9E;&]P92\B#0H@>&UL;G,Z>'-D/2)H
    M='1P.B\O=W=W+G<S+F]R9R\R,# Q+UA-3%-C:&5M82(-"B!X;6QN<SIX<VD]
    M(FAT=' Z+R]W=W<N=S,N;W)G+S(P,#$O6$U,4V-H96UA+6EN<W1A;F-E(@T*
    M('AM;&YS.E-/05 M14Y#/2)H='1P.B\O<V-H96UA<RYX;6QS;V%P+F]R9R]S
    M;V%P+V5N8V]D:6YG+R(-"B!33T%0+45.5CIE;F-O9&EN9U-T>6QE/2)H='1P
    M.B\O<V-H96UA<RYX;6QS;V%P+F]R9R]S;V%P+V5N8V]D:6YG+R(^#0H\4T]!
    M4"U%3E8Z0F]D>3X-"@T*/$5X96-U=&4@>&UL;G,](G5R;CIS8VAE;6%S+6UI
    M8W)O<V]F="UC;VTZ>&UL+6%N86QY<VES(CX-"CQ#;VUM86YD/@T*/%-T871E
    M;65N="!X<VDZ='EP93TB>'-D.G-T<FEN9R(^<V5L96-T"@D)"7L@6TUE87-U
    M<F5S72Y;56YI=',@4VAI<'!E9%TL(%M-96%S=7)E<UTN6U5N:71S($]R9&5R
    M961=('T@;VX@8V]L=6UN<RP*"0D)3D].($5-4%19(%M3=&]R95TN6U-T;W)E
    M($YA;65=+FUE;6)E<G,@;VX@<F]W<PH)"69R;VT@5V%R96AO=7-E/"]3=&%T
    M96UE;G0^/"]#;VUM86YD/@T*/%!R;W!E<G1I97,^#0H\4')O<&5R='E,:7-T
    M/@T*/$1A=&%3;W5R8V5);F9O('AS:3IT>7!E/2)X<V0Z<W1R:6YG(CY,;V-A
    M;"!!;F%L>7-I<R!397)V97(\+T1A=&%3;W5R8V5);F9O/@T*/$-A=&%L;V<@
    M>'-I.G1Y<&4](GAS9#IS=')I;F<B/D9O;V1M87)T(#(P,# \+T-A=&%L;V<^
    M#0H\0V]N=&5N="!X<VDZ='EP93TB>'-D.G-T<FEN9R(^1&%T83PO0V]N=&5N
    M=#X-"CQ&;W)M870@>'-I.G1Y<&4](GAS9#IS=')I;F<B/DUU;'1I9&EM96YS
    M:6]N86P\+T9O<FUA=#X\+U!R;W!E<G1Y3&ES=#X\+U!R;W!E<G1I97,^/"]%
    M>&5C=71E/@T*/"]33T%0+45.5CI";V1Y/@T*/"]33T%0+45.5CI%;G9E;&]P
    $93X-"@``
    `
    end


  • Next message: Akshai Mirchandani [MS]: "Re: XMLA 1.1 'Execute'-requests - SOAP/XML namespace problems - Bug? - Where to submit?"

    Relevant Pages

    • Data source name not found with XMLA 1.1
      ... querying an Analysis Services cube with XMLA 1.1. ... except for my client's production server (an ... but I think this is very strange since we are using the ...
      (microsoft.public.data.xmlanalysis)
    • Restricting results from OLAP Server
      ... While requesting a MDX to MS OLAP via XMLA, is there a way to limit the ... I may request rows and cols from 51-100 and like wise, ...
      (microsoft.public.data.xmlanalysis)
    • Restricting results from OLAP Server
      ... While requesting a MDX to MS OLAP via XMLA, is there a way to limit the ... I may request rows and cols from 51-100 and like wise, ...
      (microsoft.public.sqlserver.olap)