Fix for Invalid Column Name Error (42S22)

By - Jul 11, 2014

Sympton

You get OLE DB error message in Kepion forms.

Error message 2

Message you get in Kepion Planning:

Error message

Resolution

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

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.  We suspect that the source view may missing the column that is called out in the error message.  If so, please fix the view.


Facebooktwitterlinkedinmail