I am new to XMLA, so it may be that I am missing something very
obvious, but I get an error when I run the ClearCache command in the
XMLA query window in SQL Server Management Studio.

The query

<Command>
<ClearCache>
<Object>
<DatabaseID>DataWarehouseAnalysis</DatabaseID>
</Object>
</ClearCache>
</Command>

returns the error

Executing the query ...
The Command element at line 7, column 24 (namespace
urn:schemas-microsoft-com:xml-analysis) cannot appear under
Envelope/Body/Execute/Command.
Execution complete

I can't understand what I am doing wrong. Can anyone help? Thanks

Firstly, you don't need the Command element (it is already being generated
by SSMS). Secondly, the ClearCache needs to be in the correct namespace
(http://schemas.microsoft.com/analysi...es/2003/engine)

<ClearCache
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>DataWarehouseAnalysis</DatabaseID>
</Object>
</ClearCache>

HTH,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

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.

"Graham Binner" <graham.binner (AT) aleagroup (DOT) com> wrote

That works. Thanks very much for your help.

Graham

Akshai Mirchandani [MS] wrote: