Database Reference
In-Depth Information
More than likely you have a problem in the data extraction, transformation, and load-
ing layer.
Undefined column name
You might encounter this error while processing SSAS objects after altering a data
source view to add a column to a named query, or after adding a column to an exist-
ing table or view. General troubleshooting steps include checking the data source to
ensure that the column name is spelled correctly and that the login account reading
data from the relational source has the necessary permissions. However, this error
could simply be due to memory corruption. If so, restarting Analysis Services will re-
solve the issue.
DSV does not contain definition for an xyz
column
Though it seems obvious, this error isn't always caused by a misspelled column
name. Keep in mind that XMLA is case sensitive. If you have a dimension definition
that has the column name in uppercase, whereas the data source view has the same
column in lowercase, you will get an error. The resolution is to fix either the data
source view or the dimension definition so that the columns' case match.
Operation is cancelled
This error could have two root causes:
• The user became impatient with the processing or querying job and cancels
it. Clearly such errors are benign. As a cube developer or DBA, you need to
identify the operation details and take corrective actions to assure improved
query performance.
• Analysis Services ran out of memory. You can check the Windows error
log or the msmdsrv.log file for additional error messages indicating out of
memory condition. If you consistently experience out of memory condition,
you should migrate the application to 64-bit Analysis Services and/or add
memory to the host.
Search WWH ::




Custom Search