patternMinor
The column 'Date Offset' in table 'Date' has invalid bindings specified
Viewed 0 times
thebindingscolumnoffsetdatehasinvalidtablespecified
Problem
I'm trying to deploy a tabular model to a server using the "Analysis Services Deployment Wizard".
When attempting to deploy,I get the below error.
The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The column 'Date Offset' in table 'Date' has invalid bindings specified.
The column in question uses the below calculation, which was found here
What should I look for in order to resolve this error?
When attempting to deploy,I get the below error.
The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The column 'Date Offset' in table 'Date' has invalid bindings specified.
The column in question uses the below calculation, which was found here
INT([Date] - TODAY())What should I look for in order to resolve this error?
Solution
The problem in this case was that I was trying to replace an existing column also named 'Date Offset' - this was not a calculated column, but taken from the source table.
Resolution was to do the deployment in 2 phases, first remove the old column, then deploy again to add the new calculated column.
Resolution was to do the deployment in 2 phases, first remove the old column, then deploy again to add the new calculated column.
Context
StackExchange Database Administrators Q#183521, answer score: 4
Revisions (0)
No revisions yet.