If you are using SP3 or 4, this may be a known bug. Ask your VAR and reference: S-051125 in the KB.
Please not the below is almost exactly what Todd recommended just worded differently.
Look in your Administration Tool>Log File .
If you see entries like:
Description: Caught error 1
Error code: E_EDM_DATABASE_ACCESS
Description: Error running query in SpDbOdbc
Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_VariableValue'. Cannot insert duplicate key in object 'dbo.VariableValue'.
Then you have run into a known bug. The hot fix did not help in my case. I imagine your only option is to upgrade your Vault install.
If you need help reparing any files that have been corrupted by this post back here. The Solution that your VAR will recommend may not help this particular issue.
I have a part inserted into another part. The inserted part was at a released state. Once I removed this inserted part, everything checked in fine. (BTW, I was setting the state to our prototype state when I was getting the error.
in most cases, it is due to Login failure.
Here is the link that may be useful :
there is another thing that may be the cause of problem which is administrative permissions. sometimes granting the access of Domain Administration may solve this problem (instead of using Local Administration)