Re: SOAP fault error: XMLAnalysisError.80020009

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

Date: Mon, 2 Aug 2004 11:49:36 -0700

Do you have the complete XML request/response?

Also, have you tried to uninstall and then re-install the XMLA SDK? Have you
disabled Anonymous authentication and enabled Integrated authentication on
the virtual directory?

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.
"Carlos Alvarez" <calvarez@btgsa.com> wrote in message
news:%23sbZ7GXdEHA.216@TK2MSFTNGP11.phx.gbl...
> Ckecked! PTS is installed (sorry for my ignorance).
>
> I can connect the server from my box using the MDX Sample, any other idea
> about the source of the problem?
>
> "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> escribió en el
> mensaje news:4108a7bd$1@news.microsoft.com...
> > The OLE DB for OLAP driver is also known as Pivot Table Service (PTS).
If
> > you can connect to the server using a client-side OLAP tool (e.g. MDX
> > Sample) on that machine then PTS is installed. Otherwise, that is the
> first
> > thing to check on...
> >
> > You can install PTS using the PTSLite.exe or PTSFull.exe on the SQL 2000
> CD.
> > Also, please make sure you have matching versions of service packs.
> >
> > 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.
> >
> > "Carlos Alvarez" <calvarez@btgsa.com> wrote in message
> > news:%23wrWAgIdEHA.596@TK2MSFTNGP11.phx.gbl...
> > > Sorry Akshai,
> > >  what does PTS mean?
> > >
> > > "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> escribió en
el
> > > mensaje news:uqeAJTCdEHA.3588@TK2MSFTNGP11.phx.gbl...
> > > > I suggest that you uninstall both versions of the XMLA SDK and
> > re-install
> > > > just XMLA 1.1 and then see what happens.
> > > >
> > > > Also, please make sure that you have installed MSXML 4.0 and PTS on
> the
> > > > machine... I would also recommend verifying that you can connect to
> the
> > > > Analysis Server using MDX Sample on that machine.
> > > >
> > > > The KB article you refer to does not apply here. It only occurs when
> an
> > > > error occurs during serialization of column/cell values which is not
> the
> > > > case here.
> > > >
> > > > 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.
> > > >
> > > > "Carlos Alvarez" <calvarez@btgsa.com> wrote in message
> > > > news:%23f6olA7cEHA.2408@tk2msftngp13.phx.gbl...
> > > > > All request fails.
> > > > > First I've installed 1.0 and now I'm using 1.1, but both fail.
> > > > >
> > > > > As server has MS Windows 2003 Server, SQL Server 2000 and Analysis
> > > > Services
> > > > > (with sp3 already installed) in Spanish language, I installed XML
> for
> > > > > Analysis Software Development Kit1.0 spanish version. It fails,
then
> I
> > > > > installed the 1.1 but it doesn't work (and 1.1 is not available in
> > > > spanish,
> > > > > right?).
> > > > >
> > > > > I've found a KD article by Microsoft describing this issue
> (KB816652)
> > > and
> > > > a
> > > > > supported fix is available from Microsoft, but I cannot find the
> fix.
> > > > >
> > > > > These are my first steps with XMLA...
> > > > >
> > > > > Thanks Akshai,
> > > > >
> > > > > Regards,
> > > > > Carlos
> > > > >
> > > > > "Akshai Mirchandani [MS]" <akshaim@online.microsoft.com> escribió
en
> > el
> > > > > mensaje news:Ozv5WH0cEHA.2504@TK2MSFTNGP12.phx.gbl...
> > > > > > Which request fails? Do any requests succeed or does even
> > > > > > DISCOVER_DATASOURCES fail? Which version are you using -- 1.0 or
> > 1.1?
> > > > > >
> > > > > > 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.
> > > > > >
> > > > > > "Carlos Alvarez" <calvarez@btgsa.com> wrote in message
> > > > > > news:OjJ67YycEHA.4048@TK2MSFTNGP12.phx.gbl...
> > > > > > > Hi all,
> > > > > > >
> > > > > > > I'd like to access an OLAP cube using XML for Analysis (XMLA).
> > > > > > > Unfortunately, when defining the XMLA details to establish the
> > > > > connection,
> > > > > > > after test the connection XMLA generates a SOAP fault and the
> > > > following
> > > > > > > error message appears:
> > > > > > > 'SOAP fault: XMLAnalysisError.80020009'
> > > > > > > 'An error ocurred while processing the request.'
> > > > > > >
> > > > > > > There is a KD article by Microsoft describing this issue
> > (KB816652)
> > > > and
> > > > > a
> > > > > > > supported fix is available from Microsoft, but I cannot find
it.
> > > > > > >
> > > > > > > Any help, any comment (and of course, the fix would be
> > appreciated,
> > > > > > >
> > > > > > > Thanks in advanced,
> > > > > > > Carlos
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>