Jstressman

We have one user who cannot save any attachments to a work item. The user can save a work item with out any attachments. We are getting the follwoing error in the event log when the user tries to save an attachment. What sticks out in this error is a SQL Exception about the date being between a certain time. I highlighted it below. Can somehow help me out with this issue

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): 5/17/2007 5:24:38 PM

Machine: LM-ADVWEB-D1

Application Domain: /LM/W3SVC/3/Root/WorkItemTracking-3-128238808825480059

Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 4460

Thread Id: 4696

Account name: LM\N0156453

Detailed Message: TF53013: A crash report is being prepared for Microsoft. The following information is included in that report:

System Values

OS Version Information=Microsoft Windows NT 5.2.3790 Service Pack 1

CLR Version Information=2.0.50727.42

Machine Name=LM-ADVWEB-D1 Processor Count=4

Working Set=128839680

System Directory=C:\WINDOWS\system32

Process Values

ExitCode=0

Interactive=False

Has Shutdown Started=False

Process Environment Variables

Path = C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE = x86

SystemDrive = C:

windir = C:\WINDOWS

TMP = C:\WINDOWS\TEMP

USERPROFILE = C:\Documents and Settings\Default User

ProgramFiles = C:\Program Files

FP_NO_HOST_CHECK = NO

COMPUTERNAME = LM-ADVWEB-D1

APP_POOL_ID = TFS AppPool

NUMBER_OF_PROCESSORS = 4

PROCESSOR_IDENTIFIER = x86 Family 15 Model 1 Stepping 1, GenuineIntel

SMS_UNSUPPORTED_OS = TRUE

ClusterLog = C:\WINDOWS\Cluster\cluster.log

SystemRoot = C:\WINDOWS

ComSpec = C:\WINDOWS\system32\cmd.exe

CommonProgramFiles = C:\Program Files\Common Files

PROCESSOR_LEVEL = 15

PROCESSOR_REVISION = 0101

ALLUSERSPROFILE = C:\Documents and Settings\All Users

TEMP = C:\WINDOWS\TEMP

OS = Windows_NT

Request Details

Url=http://lm-advweb-d1:8080/WorkItemTracking/v1.0/ClientService.asmx [method = POST]

User Agent=Team Foundation (devenv.exe, 8.0.50727.147)

Headers=Content-Length=2497&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=lm-advweb-d1%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+8.0.50727.147)&X-TFS-Version=1.0.0.0

Path=/WorkItemTracking/v1.0/ClientService.asmx

Local Request=False

User Host Address=146.150.193.245

User=XXXXXXXXX [auth = NTLM]

Exception: SqlTypeException

Message: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

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)

Application Domain Information

Assembly Name=mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll

Assembly File Version:

File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll

InternalName: mscorlib.dll

OriginalFilename: mscorlib.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: Microsoft Common Language Runtime Class Library

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll

InternalName: System.Web.dll

OriginalFilename: System.Web.dll

FileVersion: 2.0.50727.210 (QFE.050727-2100)

FileDescription: System.Web.dll

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.210

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll

InternalName: System.dll

OriginalFilename: System.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: .NET Framework

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll

InternalName: System.Xml.dll

OriginalFilename: System.Xml.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: .NET Framework

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll

InternalName: System.Configuration.dll

OriginalFilename: System.Configuration.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: System.Configuration.dll

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll

InternalName: system.data.dll

OriginalFilename: system.data.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: .NET Framework

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll

InternalName: system.transactions.dll

OriginalFilename: system.transactions.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: .NET Framework

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=2.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll

InternalName: System.EnterpriseServices.dll

OriginalFilename: System.EnterpriseServices.dll

FileVersion: 2.0.50727.42 (RTM.050727-4200)

FileDescription: Microsoft .NET Services Support Infrastructure

Product: MicrosoftR .NET Framework

ProductVersion: 2.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: English (United States)

Assembly Name=Microsoft.JScript, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=8.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll

InternalName: Microsoft.JScript.dll

OriginalFilename: Microsoft.JScript.dll

FileVersion: 8.0.50727.42

FileDescription: Microsoft.JScript.dll

Product: Microsoft (R) Visual Studio (R) 2005

ProductVersion: 8.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: Language Neutral

Assembly Name=CppCodeProvider, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=8.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_MSIL\CppCodeProvider\8.0.0.0__b03f5f7f11d50a3a\CppCodeProvider.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_MSIL\CppCodeProvider\8.0.0.0__b03f5f7f11d50a3a\CppCodeProvider.dll

InternalName: CppCodeProvider.dll

OriginalFilename: CppCodeProvider.dll

FileVersion: 8.0.50727.42

FileDescription: CppCodeProvider.dll

Product: Microsoft (R) Visual Studio (R) 2005

ProductVersion: 8.0.50727.42

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: Language Neutral

Assembly Name=App_global.asax.xkemaecq, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null

Assembly CLR Version=v2.0.50727

Assembly Version=0.0.0.0

Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\workitemtracking\0c441f70\62e2bc76\App_global.asax.xkemaecq.dll

Assembly File Version:

File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\workitemtracking\0c441f70\62e2bc76\App_global.asax.xkemaecq.dll

InternalName: App_global.asax.xkemaecq.dll

OriginalFilename: App_global.asax.xkemaecq.dll

FileVersion: 0.0.0.0

FileDescription:

Product:

ProductVersion: 0.0.0.0

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: Language Neutral

Assembly Name=Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=8.0.0.0

Assembly Location=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\workitemtracking\0c441f70\62e2bc76\assembly\dl3\734d663d\003abfc2_2d16c701\Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices.DLL

Assembly File Version:

File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\workitemtracking\0c441f70\62e2bc76\assembly\dl3\734d663d\003abfc2_2d16c701\Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices.DLL

InternalName: Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices.dll

OriginalFilename: Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices.dll

FileVersion: 8.0.50727.762 built by: SP

FileDescription: Work Item Tracking Client Web Service

Product: MicrosoftR Visual StudioR 2005

ProductVersion: 8.0.50727.762

Debug: False

Patched: False

PreRelease: True

PrivateBuild: True

SpecialBuild: False

Language: English (United States)

Assembly Name=Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

Assembly CLR Version=v2.0.50727

Assembly Version=8.0.0.0

Assembly Location=C:\WINDOWS\assembly\GAC_32\Microsoft.TeamFoundation.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.TeamFoundation.Common.dll

Assembly File Version:

File: C:\WINDOWS\assembly\GAC_32\Microsoft.TeamFoundation.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.TeamFoundation.Common.dll

InternalName: Microsoft.TeamFoundation.Common.dll

OriginalFilename: Microsoft.TeamFoundation.Common.dll

FileVersion: 8.0.50727.762

FileDescription: Microsoft.TeamFoundation.Common.dll

Product: Microsoft (R) Visual Studio (R) 2005

ProductVersion: 8.0.50727.762

Debug: False

Patched: False

PreRelease: False

PrivateBuild: False

SpecialBuild: False

Language: Language Neutral

Assembly Name=Microsoft.TeamF

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Re: Team Foundation Server - General User unable to save attachments in any Work Item: Generates Error in the Event Log

Hua Chen - MSFT

Hello:

This seems to be a known issue which will be fixed in RTM.

Could you please check to make sure you have installed the latest patches

Here are some SPs you may try:

1. SP2 for SQL Server 2005

2. SP1 for TFS.

Good luck