I have an issue with Autodesk Vault 2012 database transition. The transition went successfully but the problem is the database could not be migrated. The error I am receiving is “the CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.BOMcomponentproperty' and the index name 'ix_bomcomponenproperty_1'. The duplicate key value is (66924, 4, Catalog Web Link!{32853F0F-3444-11D1-9E93-0060B03C1CA6}!nvarchar). The statement has been terminated.” Any thoughts or ideas on resolving it?
Transitioning Error with Autodesk Vault 2012
Hi
You are saying that you are transitioning your DB from one place to another place through any a software names Autodesk but still the DB is not getting transferred an error occurs while this transition. So you have to do the following thing:
1. As you stated above that while in transitioning you are facing the error which another copy or say virtual copy is present already there and this make the transition not possible. So you should take care that where you are copying the DB is there any file or any sort of thing which has the same name or same ID or any sort of same thing, if yes then make it delete and then transit DB it will transit.
2. If there is no such sort of similar thing present then format that space and then copy the DB it will work.
3. Check you software whether your software is working properly or not or your software making the virtual copy of DB before copying so make your software working fine.
