none
팀프로젝트를 만들 수 없습니다. RRS feed

  • 질문

  • 현재, TFS2010버전과 SharePoint2010 버전을 쓰고 있는데,

    어느날 갑자기 TeamProject를 만들 수 없게 되었습니다.

    에러 사항은 아래와 같습니다.

    ---begin Exception entry---
    Time: 2013-05-10T17:12:43
    Module: Engine
    Event Description: TF30162: Task "Populate Reports" from Group "Reporting" failed
    Exception Type: Microsoft.TeamFoundation.Client.PcwException
    Exception Message: The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services on http://idg/ReportServer/ReportService2005.asmx.
    Exception Details: The Project Creation Wizard encountered a problem while 
    creating reports on the SQL Server Reporting Services on http://idg/ReportServer/ReportService2005.asmx. 
    The reason for the failure cannot be determined at this time. 
    Because the operation failed, the wizard was not able to finish 
    creating the SQL Server Reporting Services site.
    Stack Trace:
       at Microsoft.VisualStudio.TeamFoundation.PCW.RosettaReportUploader.Execute(ProjectCreationContext context, XmlNode taskXml)
       at Microsoft.VisualStudio.TeamFoundation.PCW.ProjectCreationEngine.TaskExecutor.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml)
       at Microsoft.VisualStudio.TeamFoundation.PCW.ProjectCreationEngine.RunTask(Object taskObj)
    --   Inner Exception   --
    Exception Message: TF30225: Error uploading report 'Bug Status': An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors (type ReportingUploaderException)
    Exception Stack Trace:    at Microsoft.TeamFoundation.Client.Reporting.ReportingUploader.UploadReport(XmlNode report)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingUploader.HandleCreateReports(XmlNode node)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingUploader.Run()
       at Microsoft.VisualStudio.TeamFoundation.PCW.RosettaReportUploader.Execute(ProjectCreationContext context, XmlNode taskXml)

    Inner Exception Details:

    Exception Message: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors (type SoapException)SoapException Details: <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReportServerDatabaseError</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">10.50.2550.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsReportServerDatabaseError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.</Message><MoreInformation><Source></Source><Message>For more information about this error navigate to the report server on the local server machine, or enable remote errors</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
    Exception Stack Trace:    at Microsoft.TeamFoundation.Client.Channels.TfsHttpClientBase.HandleReply(TfsClientOperation operation, TfsMessage message, Object[]& outputs)
       at Microsoft.TeamFoundation.Client.Channels.TfsHttpClientBase.Invoke(TfsClientOperation operation, Object[] parameters, TimeSpan timeout, Object[]& outputs)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingService.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingUploader.UploadReport(XmlNode report)

    --- end Exception entry ---

    2013-05-10T17:12:43 | Module: Engine | Thread: 30 | TF30202: Task "" from Group "" will not be run because a prior task failed.
    2013-05-10T17:12:43 | Module: Engine | Thread: 30 | TF30202: Task "SharePointPortal" from Group "Portal" will not be run because a prior task failed.
    2013-05-10T17:12:43 | Module: Engine | Thread: 30 | TF30202: Task "" from Group "" will not be run because a prior task failed.
    2013-05-10T17:12:43 | Module: Engine | Thread: 27 | Deleting from Build ...
    2013-05-10T17:12:43 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:43 | Module: Engine | Thread: 27 | Deleting from Version Control ...
    2013-05-10T17:12:44 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:44 | Module: Engine | Thread: 27 | Deleting from Work Item Tracking ...
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Deleting from TestManagement ...
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Deleting from LabManagement ...
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 |   Not found
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Deleting from ProjectServer ...
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:45 | Module: Engine | Thread: 27 | Deleting Report Server files ...
    2013-05-10T17:12:47 | Module: Engine | Thread: 27 | An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
    2013-05-10T17:12:47 | Module: Engine | Thread: 27 | Warning. Did not find SharePoint site service.
    2013-05-10T17:12:47 | Module: Engine | Thread: 27 | Deleting from Team Foundation Core ...
    2013-05-10T17:12:48 | Module: Engine | Thread: 27 | Done
    2013-05-10T17:12:48 | Module: Engine | Thread: 27 | The team project could not be deleted. Either the delete operation failed, or project creation failed but the partially-created project could not be deleted. Review the previous entries in this log for details. The team project has been taken offline and remains in a non-operational state. It is not accessible to Team Explorer. To complete the deletion, address the errors noted in this log, and then attempt deleting the project again.
    ---begin Exception entry---
    Time: 2013-05-10T17:12:48
    Module: Engine
    Event Description: TF30002: The New Team Project Wizard encountered an error deleting the project 
    Exception Message: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors (type SoapException)SoapException Details: <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReportServerDatabaseError</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">10.50.2550.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsReportServerDatabaseError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.</Message><MoreInformation><Source></Source><Message>For more information about this error navigate to the report server on the local server machine, or enable remote errors</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
    Exception Stack Trace:    at Microsoft.TeamFoundation.Client.Channels.TfsHttpClientBase.HandleReply(TfsClientOperation operation, TfsMessage message, Object[]& outputs)
       at Microsoft.TeamFoundation.Client.Channels.TfsHttpClientBase.Invoke(TfsClientOperation operation, Object[] parameters, TimeSpan timeout, Object[]& outputs)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingService.ListChildren(String Item, Boolean Recursive, CatalogItem[]& CatalogItems)
       at Microsoft.TeamFoundation.Client.TeamProjectDeleter.ReportSiteExists()
       at Microsoft.TeamFoundation.Client.TeamProjectDeleter.DoRosettaDelete()

    --- end Exception entry ---

    2013-05-10T17:12:48 | Module: Engine | Thread: 27 | Attempting to delete folder "C:\Users\nick.VI-NYL\AppData\Local\Temp\TPW_tmp4544.tmp"
    2013-05-10T17:12:49 | Module: Engine | Thread: 27 | The folder C:\Users\nick.VI-NYL\AppData\Local\Temp\TPW_tmp4544.tmp was removed.

    설정을 바꿔 보고, 관련자료 검색을 해보았지만, 해결이 쉽지 않네요.

    도와주세요..ㅠ.ㅠ

    2013년 5월 10일 금요일 오전 8:48

모든 응답

  • 권한 설정의 문제로 보입니다. 

    리포팅 사이트로 가셔서

    http://<reportserver>/Reports/Pages/Folder.aspx

    TfsOlapReportsDS , TfsReportDS  커넥션 세팅 부분을 확인 해보세요.

    id/pw 가 일치 하는지도 확인 해보세요.

    관련 링크 입니다.

    http://social.msdn.microsoft.com/forums/en-US/tfsgeneral/thread/251f0534-82af-45a2-bb6e-f2ae4ef76581

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/444c3bab-985b-40a0-8362-2742df1a6577

    원하시는 답변이 아닐 경우에 다시 질문 주세요.

    2013년 5월 10일 금요일 오전 11:22
  • 응답 주셔서 감사합니다.

    문제는 DB가 부족해서 인것 같아서 SQL Server에 들어가 해당하는 컬렉션 DB를 늘려 주었습니다.

    그리고 다시 위에 리포팅 서비스로 가서 저희가 사용하는 컬렉션에 접속을 해보면

    "보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다. (rsReportServerDatabaseError) 온라인 도움말 보기

    이 오류에 대한 자세한 내용을 보려면 로컬 서버 컴퓨터의 보고서 서버를 탐색하거나 원격 오류를 활성화하십시오.

    "

    이런 식으로 나옵니다.

    용량 문제 인것 같은데.. 도움 부탁 드립니다.

    2013년 5월 16일 목요일 오전 8:47
  • 아래 링크 가셔서

    http://support.microsoft.com/kb/2146315?wa=wsignin1.0

    설정 변경 하신 다음에

    로그 정보 다시 좀 남겨주세요.

    2013년 5월 16일 목요일 오후 9:19
  • 말씀해 주신대로 설정 변경해도 문제가 해결 되지 않습니다.



    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin경로에서 ReportingServiceService.exe.config 파일을

    아래와 같이 value=3을 4로 변경했습니다.

    <configuration>

      <configSections>
        <section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
      </configSections>
      <system.diagnostics>
        <switches>
          <add name="DefaultTraceSwitch" value="4" />
        </switches>
      </system.diagnostics>
      <RStrace>
        <add name="FileName" value="ReportServerService_" />
        <add name="FileSizeLimitMb" value="32" />
        <add name="KeepFilesForDays" value="14" />
        <add name="Prefix" value="appdomain, tid, time" />
        <add name="TraceListeners" value="file" />
        <add name="TraceFileMode" value="unique" />
        <add name="Components" value="all:4,reportrendering:4,http:4" />
      </RStrace>
      <runtime>
        <alwaysFlowImpersonationPolicy enabled="true"/>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
                 publicKeyToken="89845dcd8080cc91"
                 culture="neutral" />
            <bindingRedirect oldVersion="8.0.242.0"
                 newVersion="10.0.0.0"/>
            <bindingRedirect oldVersion="9.0.242.0"
                 newVersion="10.0.0.0"/>
          </dependentAssembly>
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" 
                 publicKeyToken="89845dcd8080cc91" 
                 culture="neutral" />
            <bindingRedirect oldVersion="9.0.242.0" 
                 newVersion="10.0.0.0"/>
          </dependentAssembly>
        </assemblyBinding>
        <gcServer enabled="true" />
      </runtime>
    </configuration>





    현재 발생하는 문제를 다시 정리하자면, 아래와 같이 visual studio 에서 팀프로젝트 생성시 에러가 발생합니다.

    Error 
    The Project Creation Wizard encountered an error while creating reports to the SQL Server Reporting Services on http://idg/ReportServer/ReportService2005.asmx.
    Explanation 
    The Project Creation Wizard encountered a problem while creating reports on the SQL Server Reporting Services on http://idg/ReportServer/ReportService2005.asmx. The reason for the failure cannot be determined at this time. Because the operation failed, the wizard was not able to finish creating the SQL Server Reporting Services site.
    User Action 
    Contact the administrator for the SQL Server Reporting Services on http://idg/ReportServer/ReportService2005.asmx to confirm that the SQL Server Reporting Services server is running and you have sufficient privileges to create a project. Your user account on SQL Server Reporting Services must have Content Manager permission to create a new project. Also, you might find additional helpful information in the project creation log. The log shows each action taken by the wizard at the time of the failure and may include additional details about the error.
    Warning 
    TF30144: The New Team Project Wizard attempted to roll back all of the steps taken to this point but was unsuccessful. Contact your Team Foundation Server administrator for further instructions.  
    로그는 아래와 같습니다.

    Time: 2013-05-20T14:54:46
    Module: Engine
    Event Description: TF30002: The New Team Project Wizard encountered an error deleting the project 
    Exception Message: 보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: 보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다. ---> System.Exception: 이 오류에 대한 자세한 내용을 보려면 로컬 서버 컴퓨터의 보고서 서버를 탐색하거나 원격 오류를 활성화하십시오. (type SoapException)SoapException Details: <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReportServerDatabaseError</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">10.50.2550.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsReportServerDatabaseError" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerDatabaseError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.2550.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다.</Message><MoreInformation><Source></Source><Message>이 오류에 대한 자세한 내용을 보려면 로컬 서버 컴퓨터의 보고서 서버를 탐색하거나 원격 오류를 활성화하십시오.</Message></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

    Exception Stack Trace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at Microsoft.TeamFoundation.Client.Reporting.ReportingService.ListChildren(String Item, Boolean Recursive)
       at Microsoft.TeamFoundation.Client.TeamProjectDeleter.ReportSiteExists()
       at Microsoft.TeamFoundation.Client.TeamProjectDeleter.DoRosettaDelete()

    --- end Exception entry ---

    2013-05-20T14:54:46 | Module: Engine | Thread: 6 | Attempting to delete folder "C:\Users\banana\AppData\Local\Temp\TPW_tmpDCFD.tmp"
    2013-05-20T14:54:46 | Module: Engine | Thread: 6 | The folder C:\Users\banana\AppData\Local\Temp\TPW_tmpDCFD.tmp was removed.


    그리고

    SQL Server Reporting Services인

    http://localhost/Reports/Pages/Folder.aspx 에서 

    TfsReports/IdxCollection 경로로 들어가면 DB에러가 발생합니다

    보고서 서버 데이터베이스 내에서 오류가 발생했습니다. 이는 데이터베이스 내의 연결 실패, 시간 초과 또는 디스크 부족 상태로 인해 발생할 수 있습니다. (rsReportServerDatabaseError) 온라인 도움말 보기
    Warning: Fatal error 824 occurred at May 20 2013 2:58PM. Note the error and time, and contact your system administrator.




    1. 권한 설정

    2. config 파일 세팅

    3. 디비 용량 늘리기를 했는데 아직 문제가 해결 되지 않았습니다.



    다른 아이디어 없으신지요...



    부탁드립니다.


    2013년 5월 20일 월요일 오전 6:00
  • 2013년 5월 21일 화요일 오후 2:15