Cannot commit changes - exception during the transaction

OscarTheRabbit · Post by **OscarTheRabbit** » Mon Nov 14, 2005 9:27 am

We have just started to get error messages whne we attempt to commit any changes. The message is;

[14/11/2005 15:09:15] Preparing data to begin transaction
[14/11/2005 15:09:16] Beginning transaction
[14/11/2005 15:09:16] An error occurred while trying to begin a transaction.
[14/11/2005 15:09:16] Transaction failed
[14/11/2005 15:09:16] An exception was encountered during the transaction. Exception: Server was unable to process request. --> Error in the application. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at VaultClientNetLib.ClientService.VaultService.BeginTx(Int32 nRepID, String strComment, VaultRequestItem[]& requests, String& strTxID)
at VaultClientNetLib.VaultConnection.BeginTx(Int32 nRepID, VaultRequestItem[]& requests, String& strTxID, String comment)
at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)

The server log is attached - it all seems to stem from a primary key violation that occurred earlier today. How do we get back up and running again?

ian_sg · Post by **ian_sg** » Mon Nov 14, 2005 9:39 am

First let's try the simple stuff: restart IIS. The server's tree cache may have gotten into a weird state, which this will resolve.

OscarTheRabbit · Post by **OscarTheRabbit** » Mon Nov 14, 2005 9:45 am

OK - just tried that, and unfortunately the problem remains unchanged.

ian_sg · Post by **ian_sg** » Mon Nov 14, 2005 10:06 am

Please contact me via email (using the button below) and we'll get this resolved.