Remote host closed the connection

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Remote host closed the connection

Post by jkp*74 » Mon Jan 07, 2008 11:21 pm

Version 4.0.6.15954
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://csd-data-server/VaultService/
Identity = NT AUTHORITY\NETWORK SERVICE

----1/8/2008 10:46:24 AM zhwang--LTP-07-006(192.0.0.120)--SSL Disabled Critical Error downloading file! The remote host closed the connection. The error code is 0x80072746.
at System.Web.Hosting.ISAPIWorkerRequestInProcForIIS6.FlushCore(Byte[] status, Byte[] header, Int32 keepConnected, Int32 totalBodySize, Int32 numBodyFragments, IntPtr[] bodyFragments, Int32[] bodyFragmentLengths, Int32 doneWithSession, Int32 finalStatus, Boolean& async)
at System.Web.Hosting.ISAPIWorkerRequest.FlushCachedResponse(Boolean isFinal)
at System.Web.Hosting.ISAPIWorkerRequest.FlushResponse(Boolean finalFlush)
at System.Web.HttpResponse.Flush(Boolean finalFlush)
at System.Web.HttpWriter.WriteFromStream(Byte[] data, Int32 offset, Int32 size)
at System.Web.HttpResponseStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Write(Byte[] array, Int32 offset, Int32 count)
at VaultServiceSQL.VaultSqlSCC.GetDeltaChainForFullFile(VaultSqlConn conn, Int64 nObjVerID, Int32 nBufSize, String strFileToken, Stream s, ListDictionary ldDataStreams, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultFileCacheManager.GetDeltaChainForFullFile(VaultSqlConn vsConn, Int32 nRepID, Int64 nTargetObjVerID, Int32 nBufSize, String strFileToken, Stream sFullFileStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultDelta.CreateFullFile(VaultSqlConn vsConn, Int32 nRepID, Int64 nObjVerID, String strFileToken, Boolean& deltaIfAvailable, Stream sFullFileStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultDelta.DeltaCreate(VaultSqlConn vsConn, Int32 nRepID, Int64 nBaseObjVerID, Int64 nTargetObjVerID, String strFileToken, Stream sDeltaStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultServiceAPI.GetVaultFile(Int32 nRepID, VaultIntDnldItem& vidi, String strFileToken, Stream s, Boolean bSeekToOrigin, Boolean bFolderExportCalcCRC, UInt32& nCRC)
at VaultService.VaultFileDownload.Page_Load(Object sender, EventArgs e)

Any setting to prevent to this error?
Joel
Micro Modular System
http://www.mmsis.com

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Tue Jan 08, 2008 8:26 am

Is this a one-time error or are you getting it regularly? Is it just after a Vault server restart, or anytime?

What's happening on the client side when this error is written to the log? Are you using the GUI Client, web client, VS integration at the time? Does the client close or crash? Are there any error messages on the client side?
Linda Bauer
SourceGear
Technical Support Manager

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Wed Jan 09, 2008 11:30 pm

It is now more than one time. It happen at anytime - not after server restart. It happen when user is 'Getting Latest Files' from the Server.
Note: This only happen to one particular user. I can download the same files without any problem.
User is using GUI Client. The client did not crash.
Client side error message:
[1/10/2008 9:50:19 AM] An error occurred reading from the download stream ("The operation has timed out."), retrying...
[1/10/2008 9:50:19 AM] Too many errors were encountered downloading files. Some files may not have been updated

Server log:
----1/10/2008 9:52:29 AM zhwang--LTP-07-006(192.0.0.120)--SSL Disabled Critical Error downloading file! The remote host closed the connection. The error code is 0x80072746.
at System.Web.Hosting.ISAPIWorkerRequestInProcForIIS6.FlushCore(Byte[] status, Byte[] header, Int32 keepConnected, Int32 totalBodySize, Int32 numBodyFragments, IntPtr[] bodyFragments, Int32[] bodyFragmentLengths, Int32 doneWithSession, Int32 finalStatus, Boolean& async)
at System.Web.Hosting.ISAPIWorkerRequest.FlushCachedResponse(Boolean isFinal)
at System.Web.Hosting.ISAPIWorkerRequest.FlushResponse(Boolean finalFlush)
at System.Web.HttpResponse.Flush(Boolean finalFlush)
at System.Web.HttpWriter.WriteFromStream(Byte[] data, Int32 offset, Int32 size)
at System.Web.HttpResponseStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Write(Byte[] array, Int32 offset, Int32 count)
at VaultServiceSQL.VaultSqlSCC.GetDeltaChainForFullFile(VaultSqlConn conn, Int64 nObjVerID, Int32 nBufSize, String strFileToken, Stream s, ListDictionary ldDataStreams, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultFileCacheManager.GetDeltaChainForFullFile(VaultSqlConn vsConn, Int32 nRepID, Int64 nTargetObjVerID, Int32 nBufSize, String strFileToken, Stream sFullFileStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultDelta.CreateFullFile(VaultSqlConn vsConn, Int32 nRepID, Int64 nObjVerID, String strFileToken, Boolean& deltaIfAvailable, Stream sFullFileStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultDelta.DeltaCreate(VaultSqlConn vsConn, Int32 nRepID, Int64 nBaseObjVerID, Int64 nTargetObjVerID, String strFileToken, Stream sDeltaStream, RunningCRC32 crc, UInt32& nCRC)
at VaultServiceAPILib.VaultServiceAPI.GetVaultFile(Int32 nRepID, VaultIntDnldItem& vidi, String strFileToken, Stream s, Boolean bSeekToOrigin, Boolean bFolderExportCalcCRC, UInt32& nCRC)
at VaultService.VaultFileDownload.Page_Load(Object sender, EventArgs e)
Last edited by jkp*74 on Thu Jan 10, 2008 5:19 am, edited 2 times in total.
Joel
Micro Modular System
http://www.mmsis.com

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Wed Jan 09, 2008 11:57 pm

A little while later, this errors were captured:

----1/10/2008 1:51:00 PM --()-- System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.SqlInternalConnectionTds.ExecuteTransactionPreYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction)
at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction)
at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at VaultServiceSQL.VaultSqlConn.BeginTransaction(IsolationLevel isolationlevel) 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.SqlInternalConnectionTds.ExecuteTransactionPreYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction)
at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction)
at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso)
at VaultServiceSQL.VaultSqlConn.BeginTransaction(IsolationLevel isolationlevel)
----1/10/2008 1:51:00 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 1.
----1/10/2008 1:51:01 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:01 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 2.
----1/10/2008 1:51:01 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:01 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 3.
----1/10/2008 1:51:02 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:02 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 4.
----1/10/2008 1:51:02 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:02 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 5.
----1/10/2008 1:51:03 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:03 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 6.
----1/10/2008 1:51:03 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:03 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 7.
----1/10/2008 1:51:04 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:04 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 8.
----1/10/2008 1:51:04 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:04 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 9.
----1/10/2008 1:51:05 PM --()-- An error occurred during the deletion of r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from the database.\tObject reference not set to an instance of an object.
----1/10/2008 1:51:05 PM --()-- An error occurred deleting the session, r1v3rqespxuqwbi1jq1c3r45. Trying again - attempt 10.
----1/10/2008 1:51:05 PM --()-- An error occurred during the deletion of session, r1v3rqespxuqwbi1jq1c3r45. Please check that the session was removed from sgvault.dbo.tblsession in the database. Error: FailDBDelete

Other users will also have error:
----1/10/2008 1:56:06 PM chin.hee.ang--LTP-06-005(192.0.0.153)--SSL Disabled System.NullReferenceException: Object reference not set to an instance of an object.
at VaultServiceSQL.VaultSqlSCC.GetUserRepositoryLastChange(VaultSqlConn conn, Int32 nRepID, VaultDateTime& dtLastChg) at VaultServiceSQL.VaultSqlSCC.GetUserRepositoryLastChange(VaultSqlConn conn, Int32 nRepID, VaultDateTime& dtLastChg)
----1/10/2008 1:56:06 PM chin.hee.ang--LTP-06-005(192.0.0.153)--SSL Disabled GetRepositoryStructure returned: FailPermissionDenied
----1/10/2008 1:56:07 PM chin.hee.ang--LTP-06-005(192.0.0.153)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----1/10/2008 1:56:07 PM chin.hee.ang--LTP-06-005(192.0.0.153)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss)
----1/10/2008 1:56:12 PM splim--SDE-2(192.0.0.69)--SSL Disabled System.NullReferenceException: Object reference not set to an instance of an object.
at VaultServiceSQL.VaultSqlSCC.GetUserRepositoryLastChange(VaultSqlConn conn, Int32 nRepID, VaultDateTime& dtLastChg) at VaultServiceSQL.VaultSqlSCC.GetUserRepositoryLastChange(VaultSqlConn conn, Int32 nRepID, VaultDateTime& dtLastChg)
----1/10/2008 1:56:12 PM splim--SDE-2(192.0.0.69)--SSL Disabled GetRepositoryStructure returned: FailPermissionDenied
----1/10/2008 1:56:12 PM splim--SDE-2(192.0.0.69)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
----1/10/2008 1:56:12 PM splim--SDE-2(192.0.0.69)--SSL Disabled System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss) at System.Data.SqlClient.SqlBuffer.get_Int32()
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at VaultServiceSQL.VaultSqlSCC.GetLatestRepositoryInfo(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID)
at VaultServiceAPILib.VaultTreeManager.GetCurrentTree(VaultSqlConn vsConn, Int32 nRepID, VaultRepository& repOut)
at VaultServiceAPILib.VaultServiceAPI.GetRepositoryTreeDelta(VaultTreeManager tm, Boolean bAdminMode, Int32 nUserID, Int32 nRepID, Int64 nBaseTxID, VaultDateTime dtLastChange, Boolean bUseDBDeltaOnCacheMiss, VaultDateTime& dtLatestChange, Int64& nTargetTxID, VaultRepositoryDelta& rd, VaultIntDnld& dlOut)
at VaultService.VaultService.GetRepositoryStructure(Int32 nRepID, Int64 nBaseRevision, Int64 nTargetRevision, VaultDateTime dtLastClientSecurityCheck, VaultDateTime& dtLatestServerSecurityCheck, Int64& nReturnTargetRevision, VaultRepositoryDelta& rd, Boolean bUseDBDeltaOnCacheMiss)
Joel
Micro Modular System
http://www.mmsis.com

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Thu Jan 10, 2008 12:18 am

Recycle the VaultAppPool - user can login now.
Joel
Micro Modular System
http://www.mmsis.com

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Thu Jan 10, 2008 5:16 am

Now i can't open one of the repository from Web Admin.

----1/10/2008 7:12:37 PM admin--SDD-JOEL(192.0.0.88)--SSL Disabled System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryInfoAll(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo) 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.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.GetRepositoryInfoAll(VaultSqlConn conn, Int32 nRepID, VaultRepositoryInfo& vrInfo)
----1/10/2008 7:12:37 PM admin--SDD-JOEL(192.0.0.88)--SSL Disabled VaultLib.VaultDbException: Error in the application.
at VaultServiceAPILib.VaultAdminServiceAPI.GetRepositoryInfoAll(Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultService.Repository.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at VaultServiceAPILib.VaultAdminServiceAPI.GetRepositoryInfoAll(Int32 nRepID, VaultRepositoryInfo& vrInfo)
at VaultService.Repository.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Joel
Micro Modular System
http://www.mmsis.com

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Thu Jan 10, 2008 9:19 am

Looks like there's a problem communicating with SQL Server, as timeouts are being reported.

Did you shrink your Vault database log file per this other forum post:

http://support.sourcegear.com/viewtopic ... 8124#38124
Linda Bauer
SourceGear
Technical Support Manager

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Thu Jan 10, 2008 6:10 pm

Since there are so many errors occur, i would like to target them one by one. First in the list is to resolve the Get Latest File issue faced by one of the user.
Client side error message:
[1/10/2008 9:50:19 AM] An error occurred reading from the download stream ("The operation has timed out."), retrying...
[1/10/2008 9:50:19 AM] Too many errors were encountered downloading files. Some files may not have been updated

Server log:
----1/10/2008 9:52:29 AM zhwang--LTP-07-006(192.0.0.120)--SSL Disabled Critical Error downloading file! The remote host closed the connection. The error code is 0x80072746.
I can perform the same operation without any error (even without shrinking the log file.)

The total files size is about 5MB

I will only perform the shrinking during weekend. Not to cause any interrupt if anything would to go wrong.
Joel
Micro Modular System
http://www.mmsis.com

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Fri Jan 11, 2008 2:51 am

There is now a fix pattern. When the above error occured, other users cannot access into Vault and a lot of error messages will appear in the server log file.
Event viewer also captured the exception. I will mail the content to you.
What puzzle me is why only this particular user having problem with "Get Latest Version" and other users have no problem. I am now quite certain that some setting in that user's PC is causing this problem. I hope i can get some pointers. :?
Joel
Micro Modular System
http://www.mmsis.com

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Fri Jan 11, 2008 8:18 am

First, let's make sure this is isolated to the user's machine, and not the users account. Can this user do the same operation from a different machine?

Or you can login as this user on your machine and see if this is reproducible.

The error, "remote host closed the connection", means the client or
something between the client and server closed the network socket during transmission.


Is there a firewall or other network appliance in between the client
and server which may be closing due to data transmission, timeout or any
other type of problem?

The first thing I would suggest is to try chunked encoding for uploads. This can reduce memory consumption.

This setting is in the Vault GUI Client under tools->Options->Network Settings.

If the user already has that checked, you could try unchecking it.
Linda Bauer
SourceGear
Technical Support Manager

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Fri Jan 11, 2008 8:02 pm

I have performed the log shrinking - now it is only 500 kB.
I have also performed the maintenance steps described in http://support.sourcegear.com/viewtopic.php?t=2924
Just a note: it took 30 min to perform the defrag.
The database is still OK.
Now i can access one of the repository (which i failed to do that previously) & in a much shorter time. GOOD. :D
Now i can't open one of the repository from Web Admin.
I hope the Remote Connection Close issue can also be resolved. Will know that once the user come back to work next week.
Joel
Micro Modular System
http://www.mmsis.com

jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:

Post by jkp*74 » Sun Jan 13, 2008 7:39 pm

Is there a firewall or other network appliance in between the client
and server which may be closing due to data transmission, timeout or any
other type of problem?
Yes. Uesr has installed Zone Alarm. Once uninstall Zone Alarm, the problem disappeared !!! :D
According to the user, he has turned off the Zone Alarm - but somehow it still causes the problem. Only when Zone Alarm is fully uninstalled, then only the problem disappeared.
I believe this will solve the rest of the errors appeared in the server log file. Thanks for the advices. :lol:
Joel
Micro Modular System
http://www.mmsis.com

Locked