Edit

Handling errors in the TOM API (AMO-TOM)

  • Article

Applies to: SQL Server 2016 and later Analysis Services Azure Analysis Services Fabric/Power BI Premium

A common practice for managed libraries like Analysis Services Management Objects (AMO) Tabular Object Model (TOM) is to use exceptions as a mechanism for reporting error conditions to the user.

When an error is detected in AMO-TOM, besides throwing few standard .NET exceptions like ArgumentException and InvalidOperationException, TOM also can throw several TOM-specific exceptions.

TOM exceptions are derived from AmoException Class, covering both AMO and TOM-specific exceptions.

To illustrate exception handling in TOM, let's review one of the more common exceptions, which is OperationException Class.

OperationException is thrown when a user initiates an operation on the Analysis Services server and the server fails to perform an operation, either because the action was illegal, or because of another internal or external error.

When thrown, OperationException object will contain a list of XMLA errors returned by the server.

Note that the server will not accept changes that are invalid. If this occurs, revert the Model tree back into the last known good state using the UndoLocalChanges Method, correct the model, then resubmit.

Code Example: handle exceptions

 try 
 { 
  // Change the Model, for example create a table. 
  // … 
   model.saveChanges(); 
 } 
  catch(operationException ex) 
 { 
  foreach(XmlaError err in ex.Results.OfType<XmlaError>().cast<XmlaError>()) 
  { 
   Console.WriteLine("Error returned from the server:" + err.Messsage ); 
  } 
 }

Next steps

Other relevant exceptions include the following: