We are running Team System RC.
I had a teammember create a change request which she did correctly. She then tried to add 2 attachments to it... she gets the following error:
"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. "
She is unable to save any attachments at all. However, I am able to save attachments correctly.
Any ideas
Thanks,
~slee
Event Type: Warning
Event Source: TFS WorkItem Tracking
Event Category: None
Event ID: 6004
Date: 2/15/2006
Time: 11:30:32 AM
User: N/A
Computer: EWING
Description:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 2/15/2006 4:30:32 PM
Machine: EWING
Application Domain: /LM/W3SVC/3/Root/WorkItemTracking-3-127844751063038719
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 520
Thread Id: 2452
Account name: QUESTNT\wmott
Detailed Message: TF53014: A crash report for this problem was recently created; a new crash report for this occurrence of the problem is not being created. This problem has occurred 7 times.
Web Request Details
Url: http://ewing:8080/WorkItemTracking/v1.0/ClientService.asmx [method: POST]
User Agent: Team Foundation (devenv.exe, 8.0.50727.127)
Headers: Content-Length=2328&Content-Type=application%2fsoap%2bxml%3b+charset%3dutf-8%3b+action%3d%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fWorkItemTracking%2fClientServices%2f03%2fUpdate%22&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=ewing%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+8.0.50727.127)&X-TFS-Version=1.0.0.0
Path: /WorkItemTracking/v1.0/ClientService.asmx
Local Request: False
Host Address: 172.31.26.46
User: QUESTNT\wmott [authentication type: NTLM]
Exception Message: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. (type SqlTypeException)
Exception Stack Trace: at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
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()
at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayloadImpl(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate, String connectionString)
at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatchInternal(IRequestContext context, Boolean passInConnectionInfo, String server, String database)
at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.UpdateImpl(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, Boolean bulkUpdate, Boolean& bulkUpdateSuccess, String userSid)
at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.Update(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, String userSid)
at Microsoft.TeamFoundation.WorkItemTracking.Server.ClientService.Update(XmlElement package, XmlElement& result, MetadataTableHaveEntry[] metadataHave, String& dbStamp, Payload& metadata)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Problem with Saving Attachment in RC
Brett W
Thanks for the quick reply...the weird thing is that she has been able to save attachments to work items before this occurred.
Thanks,
~slee
kumar_deep
This seems to be a known issue which will be fixed in RTM. As far as a workaround for now, I'll have to check with the Devs if there exists one and get back to you.
Appreciate your patience!