March 29, 2010 at 11:22 pm
I am trying to deploy a cube using the Deployment Wizard. In the Wizard I choose "Retain Partitions". (This is necessary; otherwise the existing partitions will be wiped out.) I also choose "Default processing". I have several years of data in a partitioned measure group and am adding a column called "SubRouteKey" to the Fact table upon which the measure group is based. When I run the .xmla deployment file, I get the messages: "OLE DB error: OLE db or ODBC error: Invalid column name 'SubRouteKey'.; 42S22....An error occurred while processing the 'DEFAULT' partition of the measure group."
What is causing this error? It occurs whether or not I have SubRouteKey defined in the DEFAULT partition definition in the Partitions table of the measure group. And where is the DEFAULT partition definition being taken from, since it obviously is not being taken from the cube designer!
This is using SSAS 2005.
http://www.sqlservercentral.com/Forums/Skins/Classic/Images/RichTextBoxTable/tbl_bottomleft.gif
thank you.
March 30, 2010 at 6:51 am
I've seen similar errors when the DSV hasn't been updated and the partition query is manually updated to include the new column. Is the column showing for the table in the DSV?
Steve.
March 30, 2010 at 8:53 am
yeah, the new column is in the DSV.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
