Hi,
We get this error in the log:
----29-07-2012 00:06:51 Read_Only--robot14.pdc.xx(10.117.68.20)--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)
Can you assist me by explaining which timeout has expired, and where this timeout is set. Is it a value set in the vault server web.config, in the IIS or on the SQL Server.
We'd like to increase this value to see if it helps.
Best regards,
Hans Olav Nymand
Prolog Development Center A/S
SqlException Timeout expired
Moderator: SourceGear
-
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
Re: SqlException Timeout expired
This timeout generally means that the Vault connection to SQL Server timed out. This can be due to many things, such as: a transaction took much too long, network connectivity problems caused a timeout, etc.
What types of problems are users experiencing when using Vault?
Before we modify any settings, we'd like to see a copy of the Vault Server log to see what else is going on with the the Vault Server.
It's called sgvault.log and is in %windir%\temp\sgvault on the server machine. Send the log zipped up to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.
What types of problems are users experiencing when using Vault?
Before we modify any settings, we'd like to see a copy of the Vault Server log to see what else is going on with the the Vault Server.
It's called sgvault.log and is in %windir%\temp\sgvault on the server machine. Send the log zipped up to support at sourcegear.com, Attn: Linda. Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager
-
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
Re: SqlException Timeout expired
OK, I've attached a reduced version of the sgvault.log. Please note that this bulltin board does not allow files with extension .log and no larger than 2MB - a little silly when having to upload a log.
The users experience problems like this:
[30-07-2012 12:04:29,55] "C:\Program Files (x86)\SourceGear\Vault Client\vault.exe" -user "read_only" -password "" -host "vault.pdc.xx" -repository "Visual Prolog" getlabel "$/_Vip6/Prodir" "20120629_1546" -makereadonly -setfiletime checkin -destpath "c:\Vault\Staff Software\src\prog\..\Visual Prolog\_Vip6\Prodir"
<vault>
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSink_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iDispatchEx.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iLockBytes_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/packStandardInterfaces.htm: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSink2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPicture_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRootStorage_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStorage_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRunningObjectTable_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPictureDisp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iBindCtx_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/picture_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClassFactory2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersist_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iGlobalInterfaceTable_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersistStreamInit_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPropertyNotifySink_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iROTData_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFillLockBytes_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeComp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iUnknown.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRecordInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSinkEx_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/standardInterfaces.pack: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMallocSpy_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iConnectionPointContainer_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAuthenticate_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClientSecurity_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/standardInterfaces.ph: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iServerSecurity_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMoniker_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStdMarshalInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iSequentialStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMalloc_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersistStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFontDisp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iDispatch.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeLib2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFont_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iConnectionPoint_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMarshal_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClassFactory_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iProvideClassInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iSupportErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMultiQI_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeLib_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iProvideClassInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iServiceProvider_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeLib_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iParseDisplayName_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeLib2_native.i: The label could not be found.-->
<error>
<exception>VaultClientOperationsLib.GetLatestVersionFailedException: Exception of type 'VaultClientOperationsLib.GetLatestVersionFailedException' was thrown.
at VaultClientIntegrationLib.GetOperations.performLabelGet(String objectPath, String label, String labelSubItem, String labelWorkingFolder, String destPath, GetOptions go)
at VaultClientIntegrationLib.GetOperations.ProcessCommandGetLabelToLocationOutsideWorkingFolder(String objectPath, String label, String labelSubItem, GetOptions getOptions, String destPath)
at VaultCmdLineClient.VaultCmdLineClient.ProcessCommand(Args curArg)
at VaultCmdLineClient.VaultCmdLineClient.Main(String[] args)</exception>
</error>
<result>
<success>False</success>
</result>
</vault>
Best regards,
Hans Olav Nymand
The users experience problems like this:
[30-07-2012 12:04:29,55] "C:\Program Files (x86)\SourceGear\Vault Client\vault.exe" -user "read_only" -password "" -host "vault.pdc.xx" -repository "Visual Prolog" getlabel "$/_Vip6/Prodir" "20120629_1546" -makereadonly -setfiletime checkin -destpath "c:\Vault\Staff Software\src\prog\..\Visual Prolog\_Vip6\Prodir"
<vault>
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSink_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iDispatchEx.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iLockBytes_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/packStandardInterfaces.htm: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSink2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPicture_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRootStorage_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStorage_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRunningObjectTable_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPictureDisp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iBindCtx_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/picture_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClassFactory2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersist_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iGlobalInterfaceTable_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersistStreamInit_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPropertyNotifySink_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iROTData_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFillLockBytes_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeComp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iUnknown.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iRecordInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAdviseSinkEx_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/standardInterfaces.pack: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMallocSpy_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iConnectionPointContainer_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iAuthenticate_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClientSecurity_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/standardInterfaces.ph: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iServerSecurity_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMoniker_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStdMarshalInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iSequentialStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMalloc_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iPersistStream_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFontDisp_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iDispatch.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeLib2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iFont_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iConnectionPoint_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMarshal_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iClassFactory_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iProvideClassInfo2_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iSupportErrorInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iMultiQI_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeLib_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iProvideClassInfo_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iServiceProvider_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iCreateTypeLib_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iParseDisplayName_native.i: The label could not be found.-->
<!--Get latest version failed for _Vip6/ProDir/pfc/windowsApi/com_api/standardInterfaces/iTypeLib2_native.i: The label could not be found.-->
<error>
<exception>VaultClientOperationsLib.GetLatestVersionFailedException: Exception of type 'VaultClientOperationsLib.GetLatestVersionFailedException' was thrown.
at VaultClientIntegrationLib.GetOperations.performLabelGet(String objectPath, String label, String labelSubItem, String labelWorkingFolder, String destPath, GetOptions go)
at VaultClientIntegrationLib.GetOperations.ProcessCommandGetLabelToLocationOutsideWorkingFolder(String objectPath, String label, String labelSubItem, GetOptions getOptions, String destPath)
at VaultCmdLineClient.VaultCmdLineClient.ProcessCommand(Args curArg)
at VaultCmdLineClient.VaultCmdLineClient.Main(String[] args)</exception>
</error>
<result>
<success>False</success>
</result>
</vault>
Best regards,
Hans Olav Nymand
- Attachments
-
- sgvault.txt
- (1.22 MiB) Downloaded 360 times
Re: SqlException Timeout expired
There's a pattern of errors in your server log that we've seen before. A failed download destablizes the Vault Server cache and a number of other errors follow, include SQL timeouts.
When you restart the Vault Server, do things operate better for a while? Restarting the Vault Server refreshes the server cache.
We have a fix for this cache instability, if this is the problem you are experiencing.
When you restart the Vault Server, do things operate better for a while? Restarting the Vault Server refreshes the server cache.
We have a fix for this cache instability, if this is the problem you are experiencing.
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager
-
- Posts: 55
- Joined: Wed Sep 29, 2004 8:09 am
- Location: Denmark, Copenhagen
- Contact:
Re: SqlException Timeout expired
Yes, restarting the server resolves the problem for 2-3 days, then it's back.
Regards,
Hans Olav
Regards,
Hans Olav
Re: SqlException Timeout expired
Ok, then we'll try the special build which fixes this "cascading error" problem.
Email support at sourcegear.com, Attn: Linda. Please include a link to this forum post.
Email support at sourcegear.com, Attn: Linda. Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager