Azure Analysis Services - Unable to delete an existing database using SSMS

D U Maheswara Rao 1

Hi All,
I have a database in analysis server which I want to delete completely. I guess that the database is corrupted somehow as I'm not able to connect that model to powerbi or do any operation on that model (simple operations too..for instance generating an xmla script in SSMS).
I looked up the Microsoft Learn and found the xmla query to delete the model which is as below.

When I run the above xmla query, it throws me this error

Executing the query ...  
The Delete element at line 7, column 112 (namespace https://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under Envelope/Body/Execute/Command.  
  
Technical Details:  
RootActivityId: dfc09b8e-8675-4b6r-92cc-ahgd94b119ac  
Date (UTC): 10/29/2022 2:52:02 PM  
  0: PFError::SetLastError()+0x338  
  1: PFSetLastError()+0x477  
  2: PCSAXHandler::PrepareParseDDLNamespace()+0xd7  
  3:

ShaikMaheer-MSFT 38,451 Reputation points Microsoft Employee

2022-11-01T14:45:22.53+00:00

Hi @D U Maheswara Rao , Let me check this with internal team if we can get some Insights on it.

3 answers

ShaikMaheer-MSFT 38,451 Microsoft Employee

Hi @D U Maheswara Rao ,

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">  
       <Delete xmlns="https://schemas.microsoft.com/analysisservices/2003/engine" IgnoreFailures="true">  
              <Object>  
                     <DatabaseID>DBName</DatabaseID>            
              </Object>  
       </Delete>  
</Batch>

Maybe this should work better. Kindly check and let me know how it goes.

-----------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Sanjaykumar Gajwani 0

Hi @ShaikMaheer-MSFT

the solution that you provided is still giving same error

Executing the query ...
The Delete element at line 8, column 98 (namespace https://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under Envelope/Body/Execute/Command/Batch.

Technical Details:
RootActivityId: ee170379-74da-49de-85ae-b837273628fb
Date (UTC): 2/3/2023 11:10:08 AM
  0: PFError::SetLastError()+0x338
  1: PFSetLastError()+0x477
  2: PCSAXHandler::PrepareParseDDLNamespace()+0xd7
  3: <lambda_8c6c6070b557df1085084d9590bcb020>::operator()()+0xba6
  4: ConvertExceptionsToPFResult<<lambda_8c6c6070b557df1085084d9590bcb020> >()+0x12
  5: PCSAXHandler::startElement()+0x7b
  6: 0x00007FFE5C301536 (symbolic name unavailable)
  7: 0x00007FFE5C301856 (symbolic name unavailable)
  8: 0x00007FFE5C301856 (symbolic name unavailable)
  9: 0x00007FFE5C301856 (symbolic name unavailable)
 10: 0x00007FFE5C301856 (symbolic name unavailable)
 11: 0x00007FFE5C301856 (symbolic name unavailable)
 12: 0x00007FFE5C300986 (symbolic name unavailable)
 13: 0x00007FFE5C35545F (symbolic name unavailable)
 14: 0x00007FFE5C355298 (symbolic name unavailable)
 15: PCSAXParser::Parse()+0x1a2
 16: PCSAXParser::Parse()+0xe0
 17: PCSAXParser::Parse()+0x7a
 18: PCClientRequest::Load()+0x15e
 19: PCClientRequestHolder::ParseRequest()+0x6b
 20: PCRequestHolder::ExecuteTask()+0x120
 21: PFThreadPool::ExecuteJob()+0x670
 22: PFThreadPool::WorkerMethod()+0x33b
 23: PFCommandThreadPool::ThreadProc()+0x25
 24: PFThreadPool::ThreadProcWrapperForPFThreadPool()+0x2d
 25: o_exp()+0x5a
 26: BaseThreadInitThunk()+0x14
 27: RtlUserThreadStart()+0x21

Run complete

Sanjaykumar Gajwani 0 Reputation points

2023-02-03T12:02:59.68+00:00
here is something I tried, its executing the command but running forever and I don't know whether the database will be able to delete

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Delete > <Object> <DatabaseID>DBID</DatabaseID> </Object> </Delete> </Batch>
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Sanjaykumar Gajwani 0 Reputation points

2023-02-03T13:43:36.4066667+00:00

after I restart the server and next immediately I tried to delete the corrupted database, it got deleted successfully.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Analysis Services - Unable to delete an existing database using SSMS

3 answers

Your answer