Error when Checking In / Out files ( Server Busy ).

[ronhb]

All, I've been trying my best to fix this error for the past 3 days to no avail ... I came across a few scenarios similar to the one i'm in but mentioned fixes didn't help.

Version Info:

Autodesk Inventor 10
Autodesk Vault 4 B:10.0.97.0

So far i've :

- Fixed ActiveX/Com related issues on server and clients
- Applied Data_Management_Server_4.0_SP1

This article relates to the problem i'm having, but steps outlined in the solution doesn't fit my scenario.

In some posts i've read, it was advised to check logs - find them below :

## Event Viewer (eventvwr)

Source 1: MSSQL$AUTODESKVAULT

SuperSocket info: (SpnRegister) : Error 1355.

Source 2: MSSQL$INVENTORCONTENT

The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355.

## vlog-20081013.txt ( most recent entry )

10/13/2008 4:00:08 PM mid: 633595104080937500 code: 1013 , Connectivity.Core.Exceptions.DocServiceErrCodes.GetFileFailed Connectivity.Document.Util.DocumentException: GetFileFailed Server stack trace: at Connectivity.Document.Services.FileService.GetFilesByMasterId(Int64 masterId) 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.FileService.GetFilesByMasterId(Int64 masterId) at Connectivity.Web.Services.DocumentService.GetFilesByMasterId(Int64 fileMasterId)

## MSSQL ErrorLog ( most recent entry )

2008-10-13 12:36:33.93 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2008-10-13 12:36:33.93 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-10-13 12:36:33.93 server All rights reserved.
2008-10-13 12:36:33.93 server Server Process ID is 408.
2008-10-13 12:36:33.93 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\LOG\ERRORLOG'.
2008-10-13 12:36:33.96 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2008-10-13 12:36:34.14 server SQL Server configured for thread mode processing.
2008-10-13 12:36:34.14 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-10-13 12:36:34.17 server Attempting to initialize Distributed Transaction Coordinator.
2008-10-13 12:36:39.04 spid2 Starting up database 'master'.
2008-10-13 12:36:39.68 server Using 'SSNETLIB.DLL' version '8.0.766'.
2008-10-13 12:36:39.68 spid5 Starting up database 'model'.
2008-10-13 12:36:39.68 server SQL server listening on Shared Memory.
2008-10-13 12:36:39.68 server SQL Server is ready for client connections
2008-10-13 12:36:39.70 spid2 Server name is 'machinename\AUTODESKVAULT'.
2008-10-13 12:36:39.71 spid8 Starting up database 'msdb'.
2008-10-13 12:36:39.71 spid9 Starting up database 'KnowledgeVaultMaster'.
2008-10-13 12:36:39.73 spid10 Starting up database 'Vault'.
2008-10-13 12:36:40.96 spid10 Recovery is checkpointing database 'Vault' (6)
2008-10-13 12:36:41.12 spid5 Clearing tempdb database.
2008-10-13 12:36:42.98 spid5 Starting up database 'tempdb'.
2008-10-13 12:36:43.12 spid2 Recovery complete.
2008-10-13 12:36:43.12 spid2 SQL global counter collection task is created.

Any insight to getting this resolved would be greatly appreciated.

Best regards.

[Macro.Liu_Autodesk]

Hi,

The link you provided can't be opened. Would you please describe the scenario with more details? I think it's very helpful for us to some research according to it.

Thanks,
Macro Edited by: liang.liu@autodesk.com on Oct 15, 2008 5:57 PM

[ronhb]

Lian, apologies for not being clear.



When trying to Check In or Out a part into/from the Vault, after a few seconds a dialog box appears "Server Busy" with options to 'Retry' or 'Switch to'.



Clicking Retry brings up the same dialog box and Switch To brings up the Start Menu ... this keeps happening for a few minutes then a Vault dialog box appears, with Yes / No buttons :

"A problem occurred while attempting to check-out file 'some_name_of_file.iam' from the server. Would you like to continue checking out any remaining files?



The server returned the following information: Unknown Server Error."

Clicking Yes, carries me back to the Server Busy dialog box and No returns me to the drawing.



Regards.

[Macro.Liu_Autodesk]

Hi,

Sorry for late reply...

With the additional information you provided, we've done some investigation once again, while the issue you described still can't be reproduced on our side.

Probably there's something wrong with the memory and below are some tips that may help you handle this,

1. Cleaning up the temporary folder
2. Setting 3/GB switch in the boot.ini
3. Removing unnecessary services in the startup

If the issue still bother you, please forward the EVENT LOG files to the Product Support team that's available for you.

Thanks for your patience and hope this helps,

Macro

[ronhb]

Again, thank you for the reply Lian ... that didn't solve the problem, but there's a new error along with the old one being Vlog:


10/20/2008 8:36:07 PM mid: 633601317679687500 code: 0 , Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Server stack trace:
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Connectivity.Core.Database.SqlAccess.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership, Int32 commandTimeout)
at Connectivity.Core.Database.SqlAccess.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Connectivity.Document.DataAccess.Files.CheckoutFile(Int64 folderId, Int64 fileMasterId, DateTime createDate, Int64 createUserId, String machineName, String localSpec, String comment, File& currFile)
at Connectivity.Document.Services.FileService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localpath, String comment, Boolean downloadFile, Stream& fileStream)
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.FileService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localpath, String comment, Boolean downloadFile, Stream& fileStream)
at Connectivity.Web.Services.DocumentService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localPath, String comment, Boolean downloadFile)

[ronhb]

Lian,

I might've found a solution, though i'm not sure whether it would have an adverse effect on Vault/Inventor, your input would be appreciated.

As my subsequent post indicates, the last error I was getting (which is relatively new):

Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The fix:

Since a timeout error was hinted I decided to take a look at 'Web.config' located in 'C:\Program Files\Autodesk\Data Management Server 4\Server\Web\Services'.

The timeout values were extended ...

# Default - Web.config:

<database>
[snip]
<migrateTimeoutSecs value="600" />
<defaultSqlTimeoutSecs value="100" />
<longSqlTimeoutSecs value="120" />
<pooling value="true" />
</database>

# Edited - Web.config

[snip]
<migrateTimeoutSecs value="600" />
<defaultSqlTimeoutSecs value="720" />
<longSqlTimeoutSecs value="720" />
<pooling value="true" />
</database>

I hope this helps anyone that faces similar problems.

(I'll check with clients to confirm this works).

Regards.

[ronhb]

Just confirming, this resolved the issue.