Vault Professional 2011 build 15.2.66.0
Trying to delete the members of an I-Assembly en getting error 1052, "An error occured while attempting to delete a file"
Logged in as administrator, files are not used anywhere else
Vlog gives following error:
17/09/2012 16:07:32 *******************************************************************
Error: Soap Exception ( mesg-id = 634834948526892272 )
Exception: DeleteFileFailed [1052]
Stacktrace:
Server stack trace:
at Connectivity.Document.DataAccess.Folders.DeleteFileFromFolder(Int64 fileId, Int64 folderId, Boolean checkRestrictions)
at Connectivity.Document.Services.FolderService.DeleteFileFromFolder(Int64 fileId, Int64 folderId)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Connectivity.Document.Services.FolderService.DeleteFileFromFolder(Int64 fileId, Int64 folderId)
at Connectivity.Web.Services.DocumentService.DeleteFileFromFolder(Int64 fileMasterId, Int64 folderId)
Exception(Inner): The DELETE statement conflicted with the REFERENCE constraint "FK_ComponentIteration_xref". The conflict occurred in database "I-I.511A", table "dbo.ComponentIteration", column 'xrefID'.
Stacktrace(Inner): at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.NextResult()
at Connectivity.Core.DataAccess.Director.a(SqlDataReader A_0)
at Connectivity.Core.DataAccess.Director.a()
at Connectivity.Core.DataAccess.Director.Execute(Options options)
at Connectivity.Core.DataAccess.Director.Execute()
at Connectivity.Document.DataAccess.Folders.DeleteFileFromFolder(Int64 fileId, Int64 folderId, Boolean checkRestrictions)
Can somebody throw some light on this
Regards
Patrick