Home
.. About WSUS Wiki

WSUS
.. WSUS FAQ
.. WSUS on SBS
.. WSUS Troubleshooting
.. WSUS News Groups
.. Known WSUS Issues
.. WSUS Links
.. WSUS Wish List

WSUS Documents
.. WSUS Deployment Guide
.. WSUS Installation Guide
.. WSUS Release Notes
.. WSUS Best Practice

SUS
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues

Wiki Community

 .. Wiki Contributors
.. I Love WSUS
.. WSUS Wiki Diary
.. Wiki Statistics
.. To Do Page

Miscellaneous Stuff
.. Other Resources
.. Do You Know?

SqlDateTime overflow

You see this error when you ask for a report for this options:

Updates with computer errors:
Updates needed by computers:
Computers with update errors:
Computers needing updates:

Windows Server Update Services encountered an error.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

System.OverflowException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime..ctor(Int32 dayTicks, Int32timeTicks)
   at System.Data.SqlClient.MetaDateTime.ToDateTime(Int32 sqlDays, Int32
sqlTime, Int32 length)
   at System.Data.SqlClient.TdsParser.ReadDateTime(Int32 length)
   at System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32
length)
   at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
   at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
   at
Microsoft.UpdateServices.Internal.DatabaseAccess.GenericReadableRow.ReadRow(
IDataRecord record)
   at
Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProc
edure(DBConnection connection)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler)
   at
Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String
spName, DBParameterCollection args, Type resultType)
   at
Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGe
tUpdateSummariesForTargetGroup(Guid targetGroupId)
   at
Microsoft.UpdateServices.Internal.BaseApi.ComputerTargetGroup.GetSummaryPerU
pdate()
   at
Administration.Reporting.UpdateStatus.UpdateStatusProxy.GetUpdateStatusRepor
tTableXml(Boolean installed, Boolean needed, Boolean notNeeded, Boolean
unknown, Boolean failed, Guid filterTargetGroupId, String sortBy, String
sortDirection)
   at Administration.Reporting.UpdateStatus.Report.Page_Load(Object sender,
EventArgs e)

   at System.Data.SqlTypes.SqlDateTime..ctor(Int32 dayTicks, Int32
timeTicks)
   at System.Data.SqlClient.MetaDateTime.ToDateTime(Int32 sqlDays, Int32
sqlTime, Int32 length)
   at System.Data.SqlClient.TdsParser.ReadDateTime(Int32 length)
   at System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32
length)
   at System.Data.SqlClient.TdsParser.ProcessRow(_SqlMetaData[] columns,
Object[] buffer, Int32[] map, Boolean useSQLTypes)
   at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i)
   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
   at
Microsoft.UpdateServices.Internal.DatabaseAccess.GenericReadableRow.ReadRow(
IDataRecord record)
   at
Microsoft.UpdateServices.Internal.SingleResultSetSPHandler.ExecuteStoredProc
edure(DBConnection connection)
   at Microsoft.UpdateServices.Internal.GenericDataAccess.ExecuteSP(String
spName, DBParameterCollection args, IExecuteSPHandler handler)
   at
Microsoft.UpdateServices.Internal.DataAccess.ExecuteSPSingleResultSet(String
spName, DBParameterCollection args, Type resultType)
   at
Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGe
tUpdateSummariesForTargetGroup(Guid targetGroupId)
   at
Microsoft.UpdateServices.Internal.BaseApi.ComputerTargetGroup.GetSummaryPerU
pdate()
   at
Administration.Reporting.UpdateStatus.UpdateStatusProxy.GetUpdateStatusRepor
tTableXml(Boolean installed, Boolean needed, Boolean notNeeded, Boolean
unknown, Boolean failed, Guid filterTargetGroupId, String sortBy, String
sortDirection)
   at Administration.Reporting.UpdateStatus.Report.Page_Load(Object sender,
EventArgs e)

Status: Still no workaround is suggested. Microsoft is investigating this issue & if you see this error please see WSUS Beta Newsgroups.

Note: If you (Microsoft) fix this problem, please let us know here.
Track ID is: 664784570.