none
Erro TFS WorkItem RRS feed

  • Pergunta



  • Boa noite senhores! Estou com um grande problema aqui na empresa e gostaria de pedir ajuda dos amigos!
    Tenho um servidor TFS e usuarios acessam o team system webaccess constantemente para abrir novos workitens. Ocorre que na abertura de Workitem esta ocorrendo tudo perfeitamente mas de uns dias para cá toda vez que qualquer usuario tenta fazer um upload de um arquivo (anexar algo ao workitem), ao salvar as alterações recebem a mensagem de erro:
    "Attachment upload failed. Check that you have a network connection and that the Team Foudation Server is availble. If the problem persists, contact your Team Foudation Server Administrator."

    O Seguinte log de evento ocorre no meu servidor tfs imediatamente apos o erro gerado no portal:
    Event Type: Error
    Event Source: TFS WorkItem Tracking
    Event Category: None
    Event ID: 3000
    Date:  12/8/2010
    Time:  4:32:57 PM
    User:  N/A
    Computer: %SERVERNAME%
    Description:
    TF53010: The following error has occurred in a Team Foundation component or extension:
    Date (UTC): 12/8/2010 6:32:57 PM
    Machine: %SERVERNAME%
    Application Domain: /LM/W3SVC/322882837/Root/WorkItemTracking-3-129362259372029125
    Assembly: Microsoft.TeamFoundation.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
    Process Details:
      Process Name: w3wp
      Process Id: 6100
      Thread Id: 4312
      Account name: %Domain\User%

    Detailed Message: TF51334: An unknown Web service error occurred: A severe error occurred on the current command.  The results, if any, should be discarded.. Check the Event Log for more information.
    Web Request Details
        Url: http://teamserver.dominio.local:8080/WorkItemTracking/v1.0/AttachFileHandler.ashx [method: POST]
        User Agent: Team Foundation 9.0.21022.8, (WebAccess 9.0.3000)
        Headers: Content-Length=15280&Content-Type=multipart%2fform-data%3b+boundary%3d--------------------------8cd650cc10fa8fe&Accept-Language=pt-BR&Expect=100-continue&Host=teamserver.perlink.net%3a8080&User-Agent=Team+Foundation+9.0.21022.8%2c+(WebAccess+9.0.3000)&X-TFS-Version=1.0.0.0&X-TFS-Session=a1f46f21-1b5a-4b1a-8b82-b85cd4137581
        Path: /WorkItemTracking/v1.0/AttachFileHandler.ashx
        Local Request: False
        Host Address: %IP Client%
        User: %domain\user% [authentication type: NTLM]

    Exception Message: TF51334: An unknown Web service error occurred: A severe error occurred on the current command.  The results, if any, should be discarded.. Check the Event Log for more information. (type ConfigurationException)

    Exception Stack Trace:

    Inner Exception Details:

    Exception Message: A severe error occurred on the current command.  The results, if any, should be discarded. (type SqlExistingConnectionForciblyClosedException)

    Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.HandleDalError(Exception e)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayloadImpl(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate, String connectionString)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayload(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.AdoDbBase.ExecuteBatchQuery(IRequestContext context, String sqlBatch, List`1 parameterList)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatchInternal(IRequestContext context, Boolean passInConnectionInfo, String server, String database)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatch()
       at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.AddFileAttachment(String attachmentServerName, String attachmentDatabaseName, String clientUserName, Stream fileInput, String fileGuid, String projectUri)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.AttachmentUploadHandler.ProcessRequest(HttpContext context)

    Inner Exception Details:

    Exception Message: A severe error occurred on the current command.  The results, if any, should be discarded. (type SqlException)
    SQL Exception Class: 11
    SQL Exception Number: 0
    SQL Exception Procedure:
    SQL Exception Line Number: 0
    SQL Exception Server: %SQL SERVER%
    SQL Exception State: 0
    SQL Error(s):

    Exception Data Dictionary:
    HelpLink.ProdName = Microsoft SQL Server
    HelpLink.ProdVer = 10.00.1600
    HelpLink.EvtSrc = MSSQLServer
    HelpLink.EvtID = 0
    HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
    HelpLink.LinkId = 20476


    Exception Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       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.ExecuteReaderWithRetry(SqlCommand sqlCommand, SqlConnection sqlConnection, SqlDataReader& dataReader)
       at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayloadImpl(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate, String connectionString)

    _____________________________________________________________________________________________________________

     

    Aparentemente as permissoes do usuario estão ok... até pq o usuario tfsservice (responsavel por rodar os servicos do tfs) é domain admin

    cd C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE

    TFSSecurity /i dominio\tfsservice /server:servername
    TFSSecurity - Team Foundation Server Security Tool
    Copyright (c) Microsoft Corporation.  All rights reserved.

    The target Team Foundation Server is servername.
    Resolving identity "dominio\tfsservice"...

    SID: S-1-5-21-1277785010-339328510-3655945328-1626

    DN: CN=TFSSERVICE,OU=Sistemas,OU=Usuarios,DC=dominio,DC=local

    Identity type: Windows user
       Logon name: DOMINIO\tfsservice
     Display name: TFSSERVICE

    Done.

    _____________________________________________________________________________________________________________

     

    Achei o topico abaixo baseado nos erros: TF51334 + TF53010 mas parece que ninguem conseguiu chegar a solução....

    http://social.msdn.microsoft.com/Forums/en/tfsworkitemtracking/thread/34806569-16b3-4a4b-87b3-1c81de8294eb

    _____________________________________________________________________________________________________________

     

    Continuando o Troubleshooting ainda na esperança de uma alma abençoada aparecer por aqui... Log do meu servidor SQL:

    Date,Source,Severity,Message
    10/05/2010 10:17:05,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
    10/05/2010 10:17:05,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
    10/05/2010 10:17:04,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
    10/05/2010 10:17:04,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
    10/05/2010 10:16:39,,Information,[432] There are 12 subsystems in the subsystems cache
    10/05/2010 10:16:35,,Information,[339] Local computer is %DBSERVER% running Windows NT 5.2 (3790) Service Pack 2
    10/05/2010 10:16:35,,Information,[310] 8 processor(s) and 4096 MB RAM detected
    10/05/2010 10:16:35,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
    10/05/2010 10:16:35,,Information,[102] SQL Server ODBC driver version 10.00.1600
    10/05/2010 10:16:35,,Information,[101] SQL Server %DBSERVER% version 10.00.1600 (0 connection limit)
    10/05/2010 10:16:35,,Information,[100] Microsoft SQLServerAgent version 10.0.1600.22 (x86 unicode retail build) : Process ID 2436
    10/05/2010 10:15:11,,Information,[393] Waiting for SQL Server to recover databases...
    10/05/2010 10:04:08,,Information,[098] SQLServerAgent terminated (normally)
    10/05/2010 10:04:08,,Error,[382] Logon to server '(local)' failed (DisableAgentXPs)
    10/05/2010 10:04:08,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
    10/05/2010 10:04:05,,Error,[382] Logon to server '(local)' failed (SaveAllSchedules)
    10/05/2010 10:04:05,,Error,[165] ODBC Error: 0<c/> Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
    10/05/2010 10:04:02,,Information,[130] SQLSERVERAGENT stopping because of Windows shutdown...

    __________________________________________________________________________________________________

    Run-Time Log 
    20:57:56.061: Item has already been added. Key in dictionary: 'DTMachineName' Key being added: 'DTMachineName' 
     
    20:57:57.040: Starting Collecting Data phase. 
     
    20:57:57.078: Starting scan. 
     
    20:57:57.126: %PreScanRunInfo% 
     
    20:57:57.186: Processing computer and OS information for client . 
     
    20:58:05.913: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:58:06.451: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:58:15.125: Obtaining network information for client 
     
    20:58:15.344: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-PingCommand-Result.ps1 ScriptParam1 (Key5) = 
     
    20:58:16.152: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRemoteBaseKey" with "2" argument(s): "The network path was not found. " Script = Get-NetworkCardInformation.ps1 ScriptParam1 (Key5) = 
     
    20:58:16.902: Obtaining Team System 2005 file version information for client . 
     
    20:58:17.116: Obtaining Team Explorer 2005 Installation Log information for client . 
     
    20:58:17.630: Obtaining Team System 2008 file version information for client . 
     
    20:58:18.132: Obtaining Team Explorer 2008 Installation Log information for client . 
     
    20:58:19.038: Obtaining event log information for client . 
     
    20:58:19.235: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:58:19.584: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-System-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:58:19.601: Processing computer and OS information for AT . 
     
    20:58:20.357: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:58:20.708: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:58:22.056: Obtaining network information for AT 
     
    20:58:22.276: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-PingCommand-Result.ps1 ScriptParam1 (Key5) = 
     
    20:58:22.965: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRemoteBaseKey" with "2" argument(s): "The network path was not found. " Script = Get-NetworkCardInformation.ps1 ScriptParam1 (Key5) = 
     
    20:58:23.639: Processing Team Foundation and Visual Studio environment for AT . 
     
    20:58:23.641: Can't find function 'TE2008' 
     
    20:58:23.644: Can't find function 'Server2008' 
     
    20:58:23.645: Obtaining application pool information for AT . 
     
    20:58:23.758: Obtaining event log information for AT . 
     
    20:58:24.023: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:58:24.244: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-AllErrors.ps1 ScriptParam1 (Key5) = 
     
    20:58:24.596: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-System-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:58:24.821: Handled Exception: System.Management.Automation.RuntimeException Server parameter is required in format http://servername:port Script = Get-RegistrationEntries-vstfs.ps1 ScriptParam1 (Key5) = 
     
    20:58:24.885: Processing IIS metabase information for AT . 
     
    20:58:25.573: Error (Invalid namespace ) on WMI search SELECT * FROM IIsIPSecuritySetting WHERE name='W3Svc/1/ROOT' on scope root\microsoftiisv2 on server , skipping object. 
     
    20:58:25.690: Obtaining connection information for AT . 
     
    20:58:25.746: Obtaining Registration Service information for AT . 
     
    20:58:25.754: Obtaining services information for AT . 
     
    20:58:27.770: Can't find function 'SingleServer' 
     
    20:58:27.772: Can't find function 'SingleServer' 
     
    20:58:27.774: Can't find function 'SingleServer' 
     
    20:58:27.776: Can't find function 'SingleServer' 
     
    20:58:27.779: Can't find function 'SingleServer' 
     
    20:58:27.781: Can't find function 'SingleServer' 
     
    20:58:27.783: Can't find function 'SingleServer' 
     
    20:58:27.785: Can't find function 'SingleServer' 

    ... ...
     
    20:58:28.576: Can't find function 'SingleServer' 
     
    20:58:28.578: Can't find function 'SingleServer' 
     
    20:58:28.587: Obtaining SharePoint Products and Technologies information for WSS . 
     
    20:58:28.825: Handled Exception: System.Management.Automation.RuntimeException WSS hostname is required Script = get-wss-install-info.ps1 ScriptParam1 (Key5) = 
     
    20:58:29.122: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 
     
    20:58:29.385: Obtaining Reporting Services information for AT . 
     
    20:58:29.620: Handled Exception: System.Management.Automation.RuntimeException servername is required Script = get-SQLRS-Install-info.ps1 ScriptParam1 (Key5) = 
     
    20:58:29.881: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsReportDS.ps1 ScriptParam1 (Key5) = 
     
    20:58:30.195: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsOlapReportDS.ps1 ScriptParam1 (Key5) = 
     
    20:58:30.431: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "DownloadString" with "1" argument(s): "Illegal characters in path." Script = Get-ReportServer-Projects-From-AT-URL.ps1 ScriptParam1 (Key5) = /Pages/Folder.aspx?SelectedTabId=ContentsTab 
     
    20:58:48.783: Error connecting to SQL Server 
     
    20:58:48.783: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.087: Error connecting to SQL Server 
     
    20:59:07.087: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.090: Error connecting to SQL Server 
     
    20:59:07.090: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.092: Error connecting to SQL Server 
     
    20:59:07.092: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.095: Error connecting to SQL Server 

     
    20:59:07.095: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.097: Error connecting to SQL Server 
     
    20:59:07.097: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:07.104: Processing computer and OS information for DT . 
     
    20:59:14.736: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:59:15.078: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    20:59:16.702: Obtaining network information for DT 
     
    20:59:16.929: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-PingCommand-Result.ps1 ScriptParam1 (Key5) = 
     
    20:59:17.601: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRemoteBaseKey" with "2" argument(s): "The network path was not found. " Script = Get-NetworkCardInformation.ps1 ScriptParam1 (Key5) = 
     
    20:59:18.105: Processing Team Foundation and Visual Studio environment for DT . 

     
    20:59:18.112: Obtaining services information for DT . 
     
    20:59:18.471: Can't find function 'SingleServer' 
     
    20:59:18.473: Can't find function 'SingleServer' 
     
    20:59:18.477: Can't find function 'SingleServer' 
    ... ....

    20:59:19.277: Can't find function 'SingleServer' 
     
    20:59:19.279: Can't find function 'SingleServer' 
     
    20:59:19.286: Can't find function 'SingleServer' 
     
    20:59:19.288: Can't find function 'SingleServer' 
     
    20:59:19.289: Obtaining event log information for DT . 
     
    20:59:19.518: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:59:19.802: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-AllErrors.ps1 ScriptParam1 (Key5) = 
     
    20:59:20.064: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-System-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    20:59:20.082: Obtaining SharePoint Products and Technologies information for WSS . 
     
    20:59:20.313: Handled Exception: System.Management.Automation.RuntimeException WSS hostname is required Script = get-wss-install-info.ps1 ScriptParam1 (Key5) = 
     
    20:59:20.595: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 
     
    20:59:20.852: Obtaining Reporting Services information for DT . 
     
    20:59:21.068: Handled Exception: System.Management.Automation.RuntimeException servername is required Script = get-SQLRS-Install-info.ps1 ScriptParam1 (Key5) = 
     
    20:59:21.363: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsReportDS.ps1 ScriptParam1 (Key5) = 
     
    20:59:21.587: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsOlapReportDS.ps1 ScriptParam1 (Key5) = 
     
    20:59:21.819: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "DownloadString" with "1" argument(s): "Illegal characters in path." Script = Get-ReportServer-Projects-From-AT-URL.ps1 ScriptParam1 (Key5) = /Pages/Folder.aspx?SelectedTabId=ContentsTab 
     
    20:59:40.133: Error connecting to SQL Server 

     
    20:59:40.133: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.438: Error connecting to SQL Server 
     
    20:59:58.438: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.440: Error connecting to SQL Server 
     
    20:59:58.440: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.442: Error connecting to SQL Server 
     
    20:59:58.442: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.444: Error connecting to SQL Server 
     
    20:59:58.445: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.460: Error connecting to SQL Server 
     
    20:59:58.460: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    20:59:58.461: Obtaining SQL Server information for DT . 
     
    20:59:58.666: Handled Exception: System.Management.Automation.RuntimeException servername is required Script = get-SQL-Install-info.ps1 ScriptParam1 (Key5) = 
     
    21:00:16.983: Error connecting to SQL Server 
     
    21:00:16.983: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.293: Error connecting to SQL Server 
     
    21:00:35.293: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.309: Error connecting to SQL Server 
     
    21:00:35.309: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.312: Error connecting to SQL Server 
     
    21:00:35.312: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.320: Error connecting to SQL Server 

     21:00:35.320: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.322: Error connecting to SQL Server 
     
    21:00:35.322: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.323: Error connecting to SQL Server 
     
    21:00:35.323: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:35.324: Obtaining Analysis Services information for DT . 
     
    21:00:35.551: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-AnalysisServices-MetaData.ps1 ScriptParam1 (Key5) = 
     
    21:00:35.597: Obtaining Team Foundation Server database information for DT . 
     
    21:00:53.966: Error connecting to SQL Server 
     
    21:00:53.966: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:53.973: Error connecting to SQL Server 
     
    21:00:53.973: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:00:53.977: Error connecting to SQL Server 
     
    21:00:53.977: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:01:12.389: Error connecting to SQL Server 
     
    21:01:12.389: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:01:30.703: Error connecting to SQL Server 
     
    21:01:30.703: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:01:49.087: Error connecting to SQL Server 
     
    21:01:49.087: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.385: Error connecting to SQL Server 
     
    21:02:07.385: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.392: Error connecting to SQL Server 

     21:02:07.392: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.395: Error connecting to SQL Server 
     
    21:02:07.395: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.399: Error connecting to SQL Server 
     
    21:02:07.399: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.401: Error connecting to SQL Server 
     
    21:02:07.402: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.404: Error connecting to SQL Server 
     
    21:02:07.404: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.407: Error connecting to SQL Server 
     
    21:02:07.407: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.409: Error connecting to SQL Server 
     
    21:02:07.409: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:02:07.413: Processing computer and OS information for ATDT . 
     
    21:02:15.403: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    21:02:15.768: Handled Exception: System.Management.Automation.ActionPreferenceStopException Command execution stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Cannot find path '\\\c$\windows\temp' because it does not exist. Script = Get-Access-ACL-From-Path.ps1 ScriptParam1 (Key5) = '\\\c:\windows\temp' 
     
    21:02:17.088: Obtaining network information for ATDT 
     
    21:02:17.367: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-PingCommand-Result.ps1 ScriptParam1 (Key5) = 
     
    21:02:18.015: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRemoteBaseKey" with "2" argument(s): "The network path was not found. " Script = Get-NetworkCardInformation.ps1 ScriptParam1 (Key5) = 
     
    21:02:18.521: Processing Team Foundation and Visual Studio environment for ATDT . 
     
    21:02:18.523: Can't find function 'TE2008' 
     
    21:02:18.525: Can't find function 'Server2008' 
     
    21:02:18.526: Obtaining application pool information for ATDT . 
     
    21:02:18.623: Obtaining event log information for ATDT . 

     
    21:02:18.845: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    21:02:19.075: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-Application-AllErrors.ps1 ScriptParam1 (Key5) = 
     
    21:02:19.336: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-EventLog-System-MostRecent.ps1 ScriptParam1 (Key5) = 
     
    21:02:19.667: Handled Exception: System.Management.Automation.RuntimeException Server parameter is required in format http://servername:port Script = Get-RegistrationEntries-vstfs.ps1 ScriptParam1 (Key5) = 
     
    21:02:19.713: Processing IIS metabase information for ATDT . 
     
    21:02:20.131: Error (Invalid namespace ) on WMI search SELECT * FROM IIsIPSecuritySetting WHERE name='W3Svc/1/ROOT' on scope root\microsoftiisv2 on server , skipping object. 
     
    21:02:20.208: Obtaining connection information for ATDT . 
     
    21:02:20.253: Obtaining Registration Service information for ATDT . 
     
    21:02:20.261: Obtaining services information for ATDT . 
     
    21:02:20.689: Can't find function 'SingleServer' 
     
    21:02:20.698: Can't find function 'SingleServer' 
     
    21:02:20.704: Can't find function 'SingleServer' 
    ... ...

    21:02:21.505: Can't find function 'SingleServer' 
     
    21:02:21.507: Can't find function 'SingleServer' 
     
    21:02:21.515: Obtaining SharePoint Products and Technologies information for WSS . 
     
    21:02:21.936: Handled Exception: System.Management.Automation.RuntimeException WSS hostname is required Script = get-wss-install-info.ps1 ScriptParam1 (Key5) = 
     
    21:02:22.196: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 
     
    21:02:22.452: Obtaining Reporting Services information for ATDT . 
     
    21:02:22.656: Handled Exception: System.Management.Automation.RuntimeException servername is required Script = get-SQLRS-Install-info.ps1 ScriptParam1 (Key5) = 
     
    21:02:22.889: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsReportDS.ps1 ScriptParam1 (Key5) = 
     
    21:02:23.088: Handled Exception: System.Management.Automation.RuntimeException basereportsurl is required Script = Get-ReportingServicesTfsOlapReportDS.ps1 ScriptParam1 (Key5) = 
     
    21:02:23.392: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "DownloadString" with "1" argument(s): "Illegal characters in path." Script = Get-ReportServer-Projects-From-AT-URL.ps1 ScriptParam1 (Key5) = /Pages/Folder.aspx?SelectedTabId=ContentsTab 
     
    21:02:41.720: Error connecting to SQL Server 

     21:02:41.720: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.037: Error connecting to SQL Server 
     
    21:03:00.037: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.040: Error connecting to SQL Server 
     
    21:03:00.040: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.042: Error connecting to SQL Server 
     
    21:03:00.043: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.048: Error connecting to SQL Server 
     
    21:03:00.048: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.054: Error connecting to SQL Server 
     
    21:03:00.054: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:00.060: Obtaining SQL Server information for ATDT . 
     
    21:03:00.282: Handled Exception: System.Management.Automation.RuntimeException servername is required Script = get-SQL-Install-info.ps1 ScriptParam1 (Key5) = 
     
    21:03:18.757: Error connecting to SQL Server 
     
    21:03:18.758: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:37.062: Error connecting to SQL Server 
     
    21:03:37.062: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.365: Error connecting to SQL Server 
     
    21:03:55.365: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.369: Error connecting to SQL Server 
     
    21:03:55.369: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.377: Error connecting to SQL Server 

     21:03:55.377: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.379: Error connecting to SQL Server 
     
    21:03:55.379: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.380: Error connecting to SQL Server 
     
    21:03:55.381: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:03:55.383: Obtaining Analysis Services information for ATDT . 
     
    21:03:55.589: Handled Exception: System.Management.Automation.RuntimeException server is required Script = Get-AnalysisServices-MetaData.ps1 ScriptParam1 (Key5) = 
     
    21:03:55.628: Obtaining Team Foundation Server database information for ATDT . 
     
    21:04:13.936: Error connecting to SQL Server 
     
    21:04:13.936: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:04:32.240: Error connecting to SQL Server 
     
    21:04:32.240: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:04:50.553: Error connecting to SQL Server 
     
    21:04:50.553: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:05:08.859: Error connecting to SQL Server 
     
    21:05:08.859: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:05:27.167: Error connecting to SQL Server 
     
    21:05:27.168: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:05:45.481: Error connecting to SQL Server 
     
    21:05:45.481: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:06:03.839: Error connecting to SQL Server 
     
    21:06:03.839: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:06:22.165: Error connecting to SQL Server 

     
    21:06:22.165: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:06:40.470: Error connecting to SQL Server 
     
    21:06:40.470: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:06:58.782: Error connecting to SQL Server 
     
    21:06:58.782: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:06:58.786: Error connecting to SQL Server 
     
    21:06:58.786: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)  
     

     21:06:58.789: Error connecting to SQL Server 
     
    21:06:58.789: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:07:17.095: Error connecting to SQL Server 
     
    21:07:17.095: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     
    21:07:35.406: Error connecting to SQL Server  

    21:07:35.406: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 

      
    21:07:35.410: Obtaining SharePoint Products and Technologies information for WSS . 
     
    21:07:35.610: Handled Exception: System.Management.Automation.RuntimeException WSS hostname is required Script = get-wss-install-info.ps1 ScriptParam1 (Key5) = 
     
    21:07:35.857: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 

     

     

    Caso os amigos possam me ajudar a achar uma luz estarei grato.

    Caso eu possa ajuda-los futuramente não exitem em me chamar - thiago.limax64@gmail.com

    Obrigado.

    Atenciosamente,
     
    Thiago Lima

     
    MCP 2.0;  MCTS ISA Server 2006, Network Infrastructure; MCSA
     
    EficienTI Consultoria
    Telefone: (21) 9529-9891
    www.EficienTI.com.br

     

    sexta-feira, 10 de dezembro de 2010 11:25

Respostas

  • depois de uma longa jornada no bloco do eu sozinho (claro, contando com a super equipe EficienTI) cheguamos a conclusão de que existia uma tabela corrompida no database TfsWorkItemTrackingAttachments.

    Essa tabela traz todos os anexos do portal TFS e por algum motivo corrompeu... para solucionar esse problema basta recorrer ao bom e velho bkp que não impactará nos outros dados do nosso portal e já que não conseguiamos anexar documentos fazia algum tempo, um restore não trouxe nenhuma perda para nossos projetos (o maximo que se perde aí sao os anexos que foram incluidos nos workitens caso o bkp seja de dias anteriores ao dia do problema ocorrido.

     

     

     

    quinta-feira, 23 de dezembro de 2010 13:23

Todas as Respostas

  • Seguda parte do powertools analyzer

     


    21:07:36.102: Obtaining SharePoint Products and Technologies information for WSS . 
     
    21:07:36.410: Handled Exception: System.Management.Automation.RuntimeException WSS hostname is required Script = get-wss-install-info.ps1 ScriptParam1 (Key5) = 
     
    21:07:36.648: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 
     
    21:07:36.901: Processing Project Creation Simulation. 

    21:07:37.119: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = PCW-ProcessTemplate-TemplateHeaders.ps1 ScriptParam1 (Key5) = /Services/v1.0/ProcessTemplate.asmx 

    21:07:37.350: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = connect-webservice.ps1 ScriptParam1 (Key5) = '/Services/v1.0/AuthorizationService.asmx?WSDL' 
     
    21:07:37.700: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = PCW-CommonStructureService-ListAllProjects.ps1 ScriptParam1 (Key5) = /Services/v1.0/CommonStructureService.asmx 
     
    21:07:37.923: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = connect-webservice.ps1 ScriptParam1 (Key5) = '/VersionControl/v1.0/repository.asmx?WSDL' 
     
    21:07:38.149: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = connect-webservice.ps1 ScriptParam1 (Key5) = '/Services/v1.0/GroupSecurityService.asmx?WSDL' 
     
    21:07:38.366: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = connect-webservice.ps1 ScriptParam1 (Key5) = '/Build/v2.0/BuildService.asmx?WSDL' 
     
    21:07:38.608: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = get-wss-languages.ps1 ScriptParam1 (Key5) = ?wsdl 
     
    21:07:38.844: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = Get-WSS-Templates.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = '/_vti_bin/sites.asmx' 
     
    21:07:39.072: Handled Exception: System.Management.Automation.RuntimeException url is required Script = PCW-ReportService-ListChildren.ps1 ScriptParam1 (Key5) = 
     
    21:07:39.556: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = GroupSecurityService-ReadIdentity.ps1 ScriptParam1 (Key5) = '' ScriptParam2 (Key6) = 'AccountName' ScriptParam3 (Key7) = 'Team Foundation Administrators' ScriptParam4 (Key8) = 'Expanded' 
     
    21:07:39.604: Error (Root element is missing.) accessing file with XML query ReadIdentityResults/Member, skipping object. 
     
    21:07:39.817: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = PCW-UserGroup-GetUserCollectionFromGroup.ps1 ScriptParam1 (Key5) = '/_vti_bin/usergroup.asmx' ScriptParam2 (Key6) = 'Farm Administrators' 
     
    21:07:40.047: Handled Exception: System.Management.Automation.MethodInvocationException Exception calling "OpenRead" with "1" argument(s): "Illegal characters in path." Script = PCW-UserGroup-GetUserCollectionFromSite.ps1 ScriptParam1 (Key5) = '/_vti_bin/usergroup.asmx' 
     
    21:07:40.275: Handled Exception: System.Management.Automation.RuntimeException url is required Script = PCW-ReportService-GetPolicies.ps1 ScriptParam1 (Key5) = 
     
    21:07:40.486: Handled Exception: System.Management.Automation.RuntimeException url is required Script = PCW-ReportService-GetSystemPolicies.ps1 ScriptParam1 (Key5) = 
     
    21:07:40.504: Displaying connection information. 
     
    21:07:40.552: Processing install check for ATDT . 
     
    21:07:40.555: Obtaining hardware/OS info for ATDT . 
     
    21:07:41.420: Error (Invalid namespace ) on WMI search SELECT __RELPATH, Name, ServerState FROM IIsWebServer WHERE Name='W3SVC/1' on scope root\MicrosoftIISv2 on server , skipping object. 
     
    21:07:41.425: Error (Invalid namespace ) on WMI search SELECT __RELPATH, Name FROM IIsFilter WHERE Name = 'W3SVC/1/Filters/fpexedll.dll' on scope root\MicrosoftIISv2 on server , skipping object. 
     
    21:07:41.427: Obtaining SQL Server info for ATDT . 
     
    21:07:41.432: Error (Invalid namespace ) on WMI search SELECT __RELPATH, ServiceName FROM sqlserviceadvancedproperty WHERE ServiceName='MSSQLSERVER' AND PropertyName='VERSION' AND PropertyStrValue>='9.00.1399.06' on scope root\Microsoft\SqlServer\ComputerManagement on server , skipping object. 
     
    21:07:41.864: Error (Invalid namespace ) on WMI search SELECT __RELPATH, InstanceName FROM ServerNetworkProtocol WHERE InstanceName='MSSQLSERVER' AND ProtocolName='Tcp' AND Enabled='True' on scope root\Microsoft\SqlServer\ComputerManagement on server , skipping object. 
     
    21:07:41.870: Error (Invalid namespace ) on WMI search SELECT __RELPATH, InstanceName FROM ServerNetworkProtocol WHERE InstanceName='MSSQLSERVER' AND ProtocolName='Tcp' AND Enabled='True' on scope root\Microsoft\SqlServer\ComputerManagement on server , skipping object. 
     
    21:07:41.876: Error (Invalid namespace ) on WMI search SELECT __RELPATH, InstanceName FROM ServerNetworkProtocol WHERE InstanceName='MSSQLSERVER' AND ProtocolName='Tcp' AND Enabled='True' on scope root\Microsoft\SqlServer\ComputerManagement on server , skipping object. 
     
    21:07:44.403: Processing install check for ATDT . 
     
    21:07:45.138: Error (Invalid namespace ) on WMI search SELECT __RELPATH, Name FROM IIsFilter WHERE Name = 'W3SVC/1/Filters/fpexedll.dll' on scope root\MicrosoftIISv2 on server , skipping object. 
     
    21:07:45.139: Obtaining SQL Server info for ATDT . 
     
    21:07:45.142: Can't find function 'SQLASServiceOffBox' 
     
    21:07:45.144: Completed Collecting Data phase. 
     
    21:07:45.212: Error The rule name DoConfig_TFSHealthCheck_HealthCheckAT_RootDisplayIISDirInfo_bBuiltInUsersPermsNotSufficient is used more than once in input file while running Void PreprocessRules(). 

    sexta-feira, 10 de dezembro de 2010 12:21
  • Resultado do trace executado no meu database no momento do erro

     

    exec prc_LogActivity @commandsXML=N'<?xml version="1.0" encoding="utf-16"?><commands><cmd tc="0" ws="WorkItem Tracking" md="AttachmentUpload" xc="1" rc="-1" st="2010-12-10T22:24:18.967Z" xt="360640" u="DOMAIN\USER" ip="194.0.0.41" id="019c793e-a6f0-4da8-9c1b-9e3266d7177b" ag="Team Foundation (devenv.exe, 10.0.30319.1)" ci="" /></commands>',@paramsXML=N'<?xml version="1.0" encoding="utf-16"?><params><p tc="0" k="areaNodeUriString" i="0" v="vstfs:///Classification/Node/63743038-5bf5-4e14-b819-f62255e10914" /><p tc="0" k="projectUri" i="1" v="vstfs:///Classification/TeamProject/5207fd6c-1959-49a4-a32e-f6c43d8fb9c9" /><p tc="0" k="fileGuid" i="2" v="f1c6a609-6c68-478e-beb6-b77b627f9446" /><p tc="0" k="ExceptionType" i="-1" v="SqlExistingConnectionForciblyClosedException" /><p tc="0" k="ExceptionMessage" i="-2" v="A severe error occurred on the current command.  The results, if any, should be discarded." /></params>'

    sexta-feira, 10 de dezembro de 2010 22:37
  • depois de uma longa jornada no bloco do eu sozinho (claro, contando com a super equipe EficienTI) cheguamos a conclusão de que existia uma tabela corrompida no database TfsWorkItemTrackingAttachments.

    Essa tabela traz todos os anexos do portal TFS e por algum motivo corrompeu... para solucionar esse problema basta recorrer ao bom e velho bkp que não impactará nos outros dados do nosso portal e já que não conseguiamos anexar documentos fazia algum tempo, um restore não trouxe nenhuma perda para nossos projetos (o maximo que se perde aí sao os anexos que foram incluidos nos workitens caso o bkp seja de dias anteriores ao dia do problema ocorrido.

     

     

     

    quinta-feira, 23 de dezembro de 2010 13:23