{[{category.name}]}
- {[{section.name}]}
  - {[{article.title}]}
  - {[{subsection.name}]}
    - {[{article.title}]}
    - {[{childsection.name}]}
      - {[{article.title}]}

Error 42S22: Invalid Column Name

August 22, 2024 10:24
Updated

Symptom

When you refresh a form, an OLE DB error message is shown: "OLE DB error: OLE DB or ODBC error: Invalid column name; 42S22"

Resolution

Apply the latest SQL Server Cumulative Update from Microsoft to your SQL and SSAS servers. This typically resolves the issue.

If the issue persists, refresh every single partition that uses a view as its source within the target model. It's also possible that the source view is missing a column, which would be called out in the error message.

Symptom

Resolution

Related articles