Fix for Invalid Column Name Error (42S22)

By - Jul 11, 2014

Sympton

On form refresh, an OLE DB error message is shown.

Error message 2

For example:

Error message

Resolution

To resolve this issue, please apply the latest SQL Server Cumulative Update from Microsoft to both your SQL and SSAS servers.

If the issue persists, please refresh every single partition which uses a view as its source within this model and verify if there is any error.

It may be possible that the source view may be missing a column that is called out in the error message.  If so, please fix the view.


Facebooktwitterlinkedinmail