Thursday, August 27, 2009

SSAS processing error could be due to proactive caching settings

Symptom:

"Errors in the high-level relational engine. The data source view does not contain a definition for the [object] table or view. The Source property may not have been set."

But the data source view doesn't contain this table.

Possible Cause:

A table has been specified for tracking in the notifications for proactive caching, but isn't available any more for some reason.

Solution Options:
  • Update the table name and location as required
  • Disable proactive caching for the partition

See http://www.mssqltips.com/tip.asp?tip=1563 for more details.