AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

Raunak — Wed, 22 May 2013 17:13:50 GMT

How can this be achieved using the XMLA?

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

AaronLST — Fri, 16 Sep 2011 17:15:58 GMT

@Russell, I think what Doug meant was how to perform the equivalent operations in BIDS, in terms of how to do the ExpandFull and AlterDependants. I am wondering myself. I am experiencing the same issue except I added an attribute through BIDS, and particularly got the issue after I added it to a hierarchy and update the attribute relationships.

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

Mike — Tue, 07 Dec 2010 00:59:53 GMT

Your solution solved my problem perfectly! Thanks for your post!

I cannot find CreateDataItem method

Mary — Wed, 17 Jun 2009 21:05:32 GMT

In your code

attr.KeyColumns.Add(CreateDataItem(dsv2, "dbo.DimAccount", "CustomMembers"));

I tried the same way to add an attribute, but I did not find such method in the Microsoft.AnalysisServices.dll assembly. My version is 9.0.242.0 Runtime Version: v2.0.50727, is that too old?

thanks!

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

KMeiser — Thu, 16 Aug 2007 23:32:19 GMT

I am trying to perform a similar task using Vb.net. When I try to update an attribute in a dimension, and the dimension is already referenced in a measuregroup, I receive the same error. I am not sure how, in vb.net to mimic the c# command

dim.Update(UpdateOptions.ExpandFull | UpdateOptions.AlterDependents);

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

Russell Christopher — Tue, 10 Jul 2007 16:28:43 GMT

Hey Doug - Generally, the error means that you modified something that will cause a cascading effect to other objects it is related to and you are not also modifying those objects in sympathy. You'll need to post a little more information before anyone can be more helpful, however

re: AMO Error when adding an attribute to an existing dimension: The transaction cannot be committed because one or more objects were invalidated during the transaction

Doug — Thu, 05 Jul 2007 22:05:04 GMT

Okay, can I get an explanation of how to fix this while in BIDS without coding and what is going on?