Claus on Code

A data dudes random musings about code, bugs, products, life etc.

OLE DB error: OLE DB or ODBC error: Invalid column name ‘x’.; 42S22.

After spending time debugging my analysis services cube for the second time having this error, I guess it will be a good idea to blog about it, so I can remember it to another time 🙂

I got the above error after I had modified a dimension, so used it three fields for the key, instead of one. I made the relationship from my facts, based on the 3 keys, and then I deployed and processed the cube. And then I got the above error.

The reason for the error is, that I had the partitions for the fact table, based on some SQL sentences, and I had forgotten to modify these partitions after I had made the new relation.

So the conclusion: When you get the error “Invalid column name ‘x’.; 42S22” in analysis services, it is a problem related to the partitions design.

Posted by:

Claus

3 responses to “OLE DB error: OLE DB or ODBC error: Invalid column name ‘x’.; 42S22.”

  1. grant application format Avatar
    grant application format

    Wohh exactly what I was looking for, thankyou for putting up. “The only way of knowing a person is to love them without hope.” by Walter Benjamin. grant application format http://dzgns.com/blog/2011/08/join-the-stitching-sisters-at-an-upcoming-hooping-clinic/

  2. bruf Avatar
    bruf

    thanks !

  3. Emil Avatar
    Emil

    Thanks, this was exactly what I was looking for 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *