Has anyone had frequent errors with the get/checkout process since upgrading to Vault 2014? We are currently using Vault Basic 2014 Build 18.1.8.0 Update 1. The attached screenshots show two examples. These errors will typically occur in succession - in other words, the first error will occur on the first attempt at opening a file from the Vault browser, & then the second error will occur on the second attempt.
The error occurs when right-clicking a file (ipt, iam, dwg, etc.) in the Vault program & then selecting open. As you can see, the error shows some sort of problem with the project file.
A more descriptive error was likely written to the vault server logs.
You can find the logs in the ADMS-Console under "Management" node in the tree. Take a look for errors around the same time you saw the errors in the client under the "Server Logs" and "File Store Logs".
You can also find these log files in the root of your filestore.
-Dave
Here is a part of the Server Log for today. I believe the times on the logs conicide with the times of the screenshots I posted earlier.
11/7/2013 10:50:21 AM *******************************************************************
Error: Soap Exception ( mesg-id = 635194182217347222 )
Exception: DatabaseDeadlock [231]
Stacktrace:
Server stack trace:
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.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Web.Services.v18.DocumentService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentAssociationType, Boolean parentRecurse, FileAssociationTypeEnum childAssociationType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at SyncInvokeGetFileAssociationsByIds(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Exception(Inner): Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Stacktrace(Inner): at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at Connectivity.Core.DataAccess.Director.DelegateToBuilders(SqlDataReader dr)
at Connectivity.Core.DataAccess.Director.InvokeCommand()
at Connectivity.Document.DataAccess.Files.FindFilesByIds(Int64[] fileIds, Boolean performSecurityCheck)
at Connectivity.Document.DataAccess.Files.ValidateFileIds(Int64[] fileIterationIds)
at Connectivity.Document.BusinessLogic.FileAssociationBL.GetFileAssociationsByIds(Int64[] fileIterationIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Document.Services.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
11/7/2013 10:53:24 AM *******************************************************************
Error: Soap Exception ( mesg-id = 635194184043862670 )
Exception: GetFileFailed [1013]
Stacktrace:
Server stack trace:
at Connectivity.Document.DataAccess.Files.GetFilesByIds(Int64[] fileIds, Boolean performSecurityCheck)
at Connectivity.Document.BusinessLogic.ActualFileAssociationEngine.GetEntities(Int64[] ids)
at Connectivity.Document.BusinessLogic.FileAssociationEngine.GetFileAssociations(Int64[] ids, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden, IFileAssociationEngine engine)
at Connectivity.Document.BusinessLogic.FileAssociationBL.GetFileAssociationsByIds(Int64[] fileIterationIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Document.Services.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
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.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Web.Services.v18.DocumentService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentAssociationType, Boolean parentRecurse, FileAssociationTypeEnum childAssociationType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at SyncInvokeGetFileAssociationsByIds(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
D*mn, it's a deadlock issue, which are notoriously hard to find/fix ...
You mentioned the errors were frequent ... do the server stack-traces look the same for other times the get/checkout resulted in the server busy error? For instance, the one you posted involved "GetFileAssociationsByIds" - it would be very helpful to know if the others look the same, or involve other methods.
-Dave
The stack traces from each of the deadlocks look about the same. Thanks - that should help narrow it down.
When you get the server-busy error, is it only when you download more complex assembly/part structures such as iParts or iAssemblies (maybe assemblies with sub-assemblies that share many different parts), or do you also get it with simple assemblies with only a few parts?
Also, how many total files are in your vault? (You can see this in ADMS-Console when you select your vault).
Hopefully, with that in hand we can reproduce it.
Thanks,
-Dave
Thanks again for your assistance.
It happens with simple assemblies & even with single parts.
We have about 228,000 files in our file store.
iamerm,
Would you be able to assist us in this investigation? If so, please contact me at John(dot)Huber(at)autodesk(dot)com.
Thanks,
Hi,
I'm new to these forums but I had one of our CAD users who has been experiencing something similar. Screen shot below.
No second error like iamerm's user had though.
Below is what I found in the Server logs which looks similar to what iamerm posted.
Error: Soap Exception ( mesg-id = 635357398444371222 )
Exception: DatabaseDeadlock [231]
Stacktrace:
Server stack trace:
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.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Web.Services.v18.DocumentService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentAssociationType, Boolean parentRecurse, FileAssociationTypeEnum childAssociationType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at SyncInvokeGetFileAssociationsByIds(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Exception(Inner): Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Stacktrace(Inner): at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at Connectivity.Core.DataAccess.Director.DelegateToBuilders(SqlDataReader dr)
at Connectivity.Core.DataAccess.Director.InvokeCommand()
at Connectivity.Document.DataAccess.Files.FindFilesByIds(Int64[] fileIds, Boolean performSecurityCheck)
at Connectivity.Document.DataAccess.Files.ValidateFileIds(Int64[] fileIterationIds)
at Connectivity.Document.BusinessLogic.FileAssociationBL.GetFileAssociationsByIds(Int64[] fileIterationIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at Connectivity.Document.Services.FileService.GetFileAssociationsByIds(Int64[] fileIds, FileAssociationTypeEnum parentType, Boolean parentRecurse, FileAssociationTypeEnum childType, Boolean childRecurse, Boolean includeRelatedDocuments, Boolean includeHidden)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
If you need any further info please let me know.
Vincent
Vincent,
Sorry - I wish I could help but I still have yet to receive any resolution. This is still a daily occurrence for me.
Vincent
Yeah. I have the same problem. Over and over. If I just ignore it and try again it normally works in the third attemt, but sometimes it takes more time. (like 4-10 times)
Frustrating minor issue. Did not have the same problem on Vault 2013.
Do you have content indexing enabled? I have seen deadlocks with content indexing enabled in the past using vault 2013 pro
I had this issues with Vault Workgroup.
This helps, you can try to edit the Connectivity.vault.exe.Config file from Vault Basic. Maybe it works.
Hi iamerm,
I am using Vault 2015 basic and I have the same server busy error. Did you ever resolve the issue you had, please? If so could you please post a solution?
Thanks in advance.
Jay
Yes sir, I do. I have actually found something yesterday which I tried on one client's PC. I will see if it works and I will apply it on the rest of the PCs.
Its shown in this link.
I will keep you posted.
Thanks
Jay
Jay,
Unfortunately Autodesk hasn't provided me with a good resolution thus far.
I've done limted experimentation with the workaround you listed (that jukr also recommended earlier in this thread), but I haven't found anything conclusive to post yet.