Processing SSAS tabular model fails in sql agent

Question

I have a new SSAS 2016 tabular model (1200 compatibility level). I am trying to set up a SQL Agent job to process the model daily. However, when the job runs, it is throwing the following error:

XmlaException. The { text node at line 7, column 17 cannot appear inside the Command element (namespace urn:schemas-microsoft-com:xmla-analysis) under Envelope/Body/Execute. This element can only have text nodes containing white-space characters.

The command is:

{
  "refresh": {
     "type": "full",
     "objects": [
       {
         "database": "Finance"
       }
      ]
   }
}

This works ok when I execute it in SSMS, but fails when run via a SQL agent job.

Answer 1

I have discovered what the problem was. It turned out that the SQL Server engine was version 2014, while SSAS was 2016. This is what was causing the problem. I was trying to process the 2016 SSAS tabular model using SQL 2014 SQL Agent. Once I realised this, I used the 2016 agent instead and the job is now working.