Fix for Invalid Column Name Error (42S22)

By - Updated September 26, 2018

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