积极答复者
wsus迁移之后,数据库错误。

问题
-
本来wsus服务是正常的,wsus目录是在D盘;d:\wsus
但是最近D盘空间不够了,就将wsus数据迁移到E盘去;
迁移步骤参照如下:
1. 以本地管理员身份登录到WSUS服务器.
2. 在目标分区建立文件夹以存放更新文件如e:\wsus。
3. 打开一个CMD命令行窗口,然后进入以下路径:
C:\program files\update services\tools
4. 运行以下命令以转移更新文件:
wsusutil.exe movecontent <new contentpath> <logfile>
如:
wsusutil.exe movecontent e:\WSUS e:\move.log
"e:\WSUS" 是新的目标路径;"e:\move.log" 是转移过程中的日志。
5.从日志中确认转移过程已完成;从日志文件看,迁移过程是成功的。(原来的D盘wsus目录的文件,都没有删除)
这是迁移日志文件内容:
2014-02-06T02:21:52 Successfully stopped WsusService.
2014-02-06T02:21:52 Beginning content file location change to e:\wsus
2014-02-06T09:30:29 Successfully copied content files.
2014-02-06T09:30:29 Successfully copied application files.
2014-02-06T09:30:31 Successfully changed WUS configuration.
2014-02-06T09:30:32 Successfully changed IIS virtual directory path.
2014-02-06T09:30:32 Successfully removed existing local content network shares.
2014-02-06T09:30:32 Successfully created local content network shares.
2014-02-06T09:30:32 Successfully changed registry value for content store directory.
2014-02-06T09:30:32 Successfully changed content file location.
2014-02-06T09:30:34 Successfully started WsusService.
2014-02-06T09:30:34 Content integrity check and repair...
2014-02-06T09:30:34 Initiated content integrity check and repair.
但是再打开wsus控制台,控制台会包错误:数据库错误;
并且softwaredistribution.log文件错误如下:
2014-02-11 01:16:43.202 UTC Error w3wp.24 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.217 UTC Error w3wp.13 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.233 UTC Error w3wp.16 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.358 UTC Error WsusService.7 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.499 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: ExecuteReader()
CommandText: spGetChangeTrackingInformation
SqlException:
System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.499 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.514 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.514 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors. Rethrowing the exception.
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:16:43.530 UTC Error FCSDS.7 SusEventDispatcher.DispatchManagerDatabasePollingThreadProc SusEventDispatcher got exception while polling database. Polling will continue: Excpetion details: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:18:29.013 UTC Info w3wp.69 ThreadEntry ISAPIRuntime.ProcessRequest
2014-02-11 01:18:29.013 UTC Error w3wp.69 ClientImplementation.GetExtendedUpdateInfo System.Threading.ThreadAbortException: Thread was being aborted.
在 System.Threading.Monitor.Enter(Object obj)
在 System.Data.SqlClient.TdsParser.get_Errors()
在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
在 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
在 System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
在 System.Data.SqlClient.TdsParserStateObject.ReadByte()
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader()
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetCoreUpdateXml(Int32[] revisionIds)
在 Microsoft.UpdateServices.Internal.DataAccessCache.GetCoreUpdateXml(Int32[] revisionIds, DataAccess da, Int64 maxXmlPerRequest)
在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
在 Microsoft.UpdateServices.Internal.Client.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIDs, XmlUpdateFragmentType[] infoTypes, String[] locales)
在 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
在 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
在 System.Web.Services.Protocols.WebServiceHandler.Invoke()
在 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
在 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
在 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
在 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
在 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
2014-02-11 01:18:29.029 UTC Warning w3wp.69 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=c0307f16-51d0-418a-8279-6594bfc9d53a, ErrorCode=InternalServerError, Message=, Client=03b5f804-746a-4c66-981b-ba500ffd8b7f
2014-02-11 01:19:23.529 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:19:23.529 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:19:23.544 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors. Rethrowing the exception.
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:19:27.138 UTC Info w3wp.74 ThreadEntry ThreadHelper.ThreadStart
2014-02-11 01:19:27.138 UTC Error w3wp.74 DataAccess.ExecuteSpGetGlobalUpdates Error: ExecuteSpGetGlobalUpdates: - 超时时间已到。在操作完成之前超时时间已过或服务器未响应。.
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetGlobalUpdates(Int64 lastChangeNumber, Int64 newChangeNumber)
在 Microsoft.UpdateServices.Internal.SyncUpdatesHelper.BuildGlobalUpdates(GlobalUpdate[] oldData, Int64 oldChangeNumber, Int64 newChangeNumber)
在 Microsoft.UpdateServices.Internal.SyncUpdatesHelper.InitializeRefreshCache()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:19:32.576 UTC Error w3wp.35 ClientImplementation.GetExtendedUpdateInfo System.Threading.ThreadAbortException: Thread was being aborted.
在 System.Threading.Monitor.Enter(Object obj)
在 System.Data.SqlClient.TdsParser.get_Errors()
在 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
在 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
在 System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
在 System.Data.SqlClient.TdsParserStateObject.ReadByte()
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader()
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSpGetCoreUpdateXml(Int32[] revisionIds)
在 Microsoft.UpdateServices.Internal.DataAccessCache.GetCoreUpdateXml(Int32[] revisionIds, DataAccess da, Int64 maxXmlPerRequest)
在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
在 Microsoft.UpdateServices.Internal.ClientImplementation.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIds, XmlUpdateFragmentType[] fragmentTypes, String[] locales)
在 Microsoft.UpdateServices.Internal.Client.GetExtendedUpdateInfo(Cookie cookie, Int32[] revisionIDs, XmlUpdateFragmentType[] infoTypes, String[] locales)
在 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
在 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
在 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
在 System.Web.Services.Protocols.WebServiceHandler.Invoke()
在 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
在 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
在 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
在 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
在 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
2014-02-11 01:19:32.576 UTC Warning w3wp.35 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=d2a26f2c-89cb-43b1-b497-215f47026275, ErrorCode=InternalServerError, Message=, Client=03b5f804-746a-4c66-981b-ba500ffd8b7f
2014-02-11 01:20:24.606 UTC Error WsusService.8 HealthMonitoringTasks.ExecuteSubtask Health Monitoring Thread caught an exception: System.Data.SqlClient.SqlException: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteGetSingleResult()
在 Microsoft.UpdateServices.Internal.SingleValueSPHandler.ExecuteStoredProcedure(DBConnection connection)
在 Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String spName, DBParameterCollection args, IExecuteSPHandler handler, Int32 queryTimeoutInSeconds)
在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName, DBParameterCollection args, Int32 queryTimeoutInSeconds)
在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName, DBParameterCollection args)
在 Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPSingleValue(String spName)
在 Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetFailedToDownloadUpdatesCount()
在 Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetFailedToDownloadUpdatesCount()
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HmtCore.CheckForContentSyncFailures(EventLoggingType type, HealthEventLogger logger)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.ExecuteSubtask(HealthMonitoringSubtask subtask, EventLoggingType type, HealthEventLogger logger)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.ExecuteSubtask(HealthMonitoringSubtask subtask, EventLoggingType type, HealthEventLogger logger)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HmtCore.Execute(EventLoggingType type)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringTasks.Execute(EventLoggingType type)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringThreadManager.Execute(Boolean waitIfNecessary, EventLoggingType loggingType)
在 Microsoft.UpdateServices.Internal.HealthMonitoring.HealthMonitoringThreadManager.PeriodicTask()
在 Microsoft.UpdateServices.Internal.HealthMonitoring.PeriodicTaskExecuter.ThreadStart()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.runTryCode(Object userData)
在 System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:21:58.543 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:21:58.559 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:21:58.559 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: End of SqlException.Errors. Rethrowing the exception.
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:24:06.027 UTC Warning w3wp.1 SoapUtilities.CreateException ThrowException: actor = http://192.168.1.6/ClientWebService/client.asmx, ID=0ed71a91-1cec-4e3e-8bbc-9aeed4afacd8, ErrorCode=ServerChanged, Message=Server rolled back since last call to GetCookie, Client=a6dab232-d2d7-4480-9827-a6c403c76c84
2014-02-11 01:24:33.558 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Dumping SqlException.Errors:
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()
2014-02-11 01:24:33.558 UTC Error FCSDS.7 DBConnection.LogSqlException DBLAYER: Errors[0]: Source .Net SqlClient Data Provider, Server \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query, Number -2, Class 11, State 0, Procedure , LineNumber 0: 超时时间已到。在操作完成之前超时时间已过或服务器未响应。
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.LogSqlException(String dbLayerFunctionName, SqlException e)
在 Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteReader()
在 Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPGetChangeTrackingInformation(Int64 lastChangeNumber, DateTime lastTimeWeChecked)
在 Microsoft.UpdateServices.Internal.SusEventDispatcher.DispatchManagerDatabasePollingThreadProc()
在 System.Threading.ThreadHelper.ThreadStart_Context(Object state)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
在 System.Threading.ThreadHelper.ThreadStart()先就此谢过!
张杰
答案
-
您好,
请重新索引一下WSUS的数据库,再试一下是否有错误。
Reindex the WSUS Database
http://technet.microsoft.com/en-us/library/dd939795(v=ws.10).aspx
如果问题依旧,请告知WSUS的版本。
谢谢。
Jeremy Wu
TechNet Community Support
- 已标记为答案 Jeremy_WuModerator 2014年2月25日 3:24