Tuesday, June 11, 2019

Unable to process the 2017 Tabular Model cube using Analysis services Processing Task.

Unable to process the 2017 Tabular Model cube using Analysis services Processing Task. Analysis Services processing task working fine for 2014 Tabular model but its giving below error for 2017.

Error: 0xC1140279 at XXXXXX Cube Process, Analysis Services Execute DDL Task: This command cannot be executed on database 'ProjectOffice' because it has been defined with StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database.
Task failed: XXXXX Cube Process

I tried using Analysis Serices Execute DDL Task using below jason script but still it fails. The JSON script was generated from the database.


{

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

Still we will get the error. The workaround is to wrap the JSON script in XMLA


<Statement xmlns="urn:schemas-microsoft-com:xml-analysis">
{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "ProjectOffice"
      }
    ]
  }
}
</Statement>




No comments:

Post a Comment