I am trying to publish a taxonmy, but following getting error : Violation of UNIQUE KEY constraint 'UIX_TAXFACETS'. Cannot insert duplicate key in object 'dbo.TAXFACETS'. The duplicate key value is (137, 268, 7).
I verified that 1 keyword exists in TAXFACETS table of Broker DB but it is not present in CM. I assume that it could be because of some DB refresh (that was done on this environment - don't have any traces of this).
Is there a way to resolve this, either by removing this unnessesary keyword from broker db or (may be) by forcing publishing for this taxonomy.
ver: 2013 SP1