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