locked
Reporting/Analysis/Cube Processing Failure RRS feed

  • Question

  • Hi Friends,

    I have a newly built TFS 2010 SP1|CU1 stage environment installed and configured. Over the last few days I have been fighting with the reporting and analysis.

    Two App Tiers / SQL Server 2008 R2

    Windows 2008 R2

    Errors with Analysis- Full and Incremental :

    <?xml version="1.0" encoding="utf-8"?>
    <WarehouseProcessingStatus xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/TeamFoundation/2005/06/Services/Controller/03">
      <RequestTimeUtc>2012-09-07T16:36:15.9995585Z</RequestTimeUtc>
      <WarehouseProcessingOnlineStatus>Started</WarehouseProcessingOnlineStatus>
      <AnalysisProcessingOnlineStatus>Started</AnalysisProcessingOnlineStatus>
      <JobProcessingStatus>Idle</JobProcessingStatus>
      <JobsRunning>0</JobsRunning>
      <JobsQueued>0</JobsQueued>
      <Instance Name="TEAM FOUNDATION" JobProcessingStatus="Idle" JobsRunning="0" JobsQueued="0">
        <Jobs>
          <Job Name="Common Structures Warehouse Sync" JobProcessingStatus="Idle">
            <LastRun QueueTimeUtc="2012-09-07T16:33:59.273Z" ExecutionStartTimeUtc="2012-09-07T16:34:01.327Z" EndTimeUtc="2012-09-07T16:34:04.533Z" Result="Succeeded" />
            <NextRun QueueTimeUtc="2012-09-07T17:03:59.273Z" JobState="QueuedScheduled" />
          </Job>
          <Job Name="Full Analysis Database Sync" JobProcessingStatus="Idle">
            <LastRun QueueTimeUtc="2012-09-07T16:16:00.893Z" ExecutionStartTimeUtc="2012-09-07T16:16:03.753Z" EndTimeUtc="2012-09-07T16:16:03.763Z" Result="Failed">
              <ResultMessage>[Full Analysis Database Sync]:  ---&gt; Microsoft.TeamFoundation.Server.WarehouseException: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION. ---&gt; Microsoft.TeamFoundation.Server.WarehouseException: TF255040: Install SQL Reporting Services or at a minimum SQL Client Connectivity Tools on the application tier to ensure Analysis Services object model is present for warehouse processing. ---&gt; System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
       at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
       at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection, Boolean suppressSecurityChecks)
       at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.Load(String assemblyString)
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.CheckAnalysisServicesInstalled()
       --- End of inner exception stack trace ---
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.CheckAnalysisServicesInstalled()
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String&amp; resultMessage)
       at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String&amp; resultMessage)
       --- End of inner exception stack trace ---</ResultMessage>
            </LastRun>
            <NextRun QueueTimeUtc="2012-09-08T06:00:00Z" JobState="QueuedScheduled" />
          </Job>
          <Job Name="Incremental Analysis Database Sync" JobProcessingStatus="Idle">
            <LastRun QueueTimeUtc="2012-09-07T16:25:49.857Z" ExecutionStartTimeUtc="2012-09-07T16:25:51.957Z" EndTimeUtc="2012-09-07T16:25:51.97Z" Result="Failed">
              <ResultMessage>[Incremental Analysis Database Sync]:  ---&gt; Microsoft.TeamFoundation.Server.WarehouseException: TF221122: An error occurred running job Incremental Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION. ---&gt; Microsoft.TeamFoundation.Server.WarehouseException: TF255040: Install SQL Reporting Services or at a minimum SQL Client Connectivity Tools on the application tier to ensure Analysis Services object model is present for warehouse processing. ---&gt; System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
       at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark&amp; stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
       at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection, Boolean suppressSecurityChecks)
       at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark&amp; stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.Load(String assemblyString)
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.CheckAnalysisServicesInstalled()
       --- End of inner exception stack trace ---
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.CheckAnalysisServicesInstalled()
       at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String&amp; resultMessage)
       at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String&amp; resultMessage)
       --- End of inner exception stack trace ---</ResultMessage>
            </LastRun>
            <NextRun QueueTimeUtc="2012-09-07T17:04:13.117Z" JobState="QueuedScheduled" />
          </Job>
        </Jobs>
      </Instance>
      <Collections>
        <Collection Name="DefaultCollection_S" JobProcessingStatus="Idle" JobsRunning="0" JobsQueued="0">
          <Jobs>
            <Job Name="Build Warehouse Sync" JobProcessingStatus="Idle">
              <LastRun QueueTimeUtc="2012-09-07T16:24:37.517Z" ExecutionStartTimeUtc="2012-09-07T16:24:40.67Z" EndTimeUtc="2012-09-07T16:24:45.767Z" Result="Succeeded" />
              <NextRun QueueTimeUtc="2012-09-07T16:39:00.283Z" JobState="QueuedScheduled" />
            </Job>
            <Job Name="Common Structures Warehouse Sync" JobProcessingStatus="Idle">
              <LastRun QueueTimeUtc="2012-09-07T16:24:37.517Z" ExecutionStartTimeUtc="2012-09-07T16:24:41.71Z" EndTimeUtc="2012-09-07T16:24:45.76Z" Result="Succeeded" />
              <NextRun QueueTimeUtc="2012-09-07T16:39:00.283Z" JobState="QueuedScheduled" />
            </Job>
            <Job Name="Test Management Warehouse Sync" JobProcessingStatus="Idle">
              <LastRun QueueTimeUtc="2012-09-07T16:24:37.517Z" ExecutionStartTimeUtc="2012-09-07T16:24:41.72Z" EndTimeUtc="2012-09-07T16:24:45.963Z" Result="Succeeded" />
              <NextRun QueueTimeUtc="2012-09-07T16:39:00.283Z" JobState="QueuedScheduled" />
            </Job>
            <Job Name="Version Control Warehouse Sync" JobProcessingStatus="Idle">
              <LastRun QueueTimeUtc="2012-09-07T16:24:37.517Z" ExecutionStartTimeUtc="2012-09-07T16:24:41.717Z" EndTimeUtc="2012-09-07T16:24:45.923Z" Result="Succeeded" />
              <NextRun QueueTimeUtc="2012-09-07T16:39:00.283Z" JobState="QueuedScheduled" />
            </Job>
            <Job Name="Work Item Tracking Warehouse Sync" JobProcessingStatus="Idle">
              <LastRun QueueTimeUtc="2012-09-07T16:24:37.517Z" ExecutionStartTimeUtc="2012-09-07T16:24:40.603Z" EndTimeUtc="2012-09-07T16:24:43.897Z" Result="Succeeded" />
              <NextRun QueueTimeUtc="2012-09-07T16:39:00.283Z" JobState="QueuedScheduled" />
            </Job>
          </Jobs>
        </Collection>
      </Collections>
    </WarehouseProcessingStatus>

    Reporting Services Error:

    From Burndown

      • An error has occurred during report processing. (rsProcessingAborted)
        • Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand)Burndown

      I have already rebuilt the cube and warehouse several times

      I have already manually processed the warehouse, analysis (full and incremental)

      I have verified my user account for the tfs analysis datasource for the tfs analysis db (ImpersonateAcccount - using the TFSReports account)

      I have also added the disable loopback dword to LSA on both app tiers.

      Check my services- all started and running.

      I'm also unable to view the cube status report - error

      • An error has occurred during report processing. (rsProcessingAborted)
        • Query execution failed for dataset 'dsProcessingStatus'. (rsErrorExecutingCommand)

      I'm certain it's all related.

      Any help would be much appreciated.

      Regards

      Clint


    • Edited by czofnas001 Friday, September 7, 2012 4:50 PM Update
    Friday, September 7, 2012 4:48 PM

Answers

  • It appears that the warehouse is processed and both the warehouse and cube builds just fine, but it is failing on processing the cube. The exception that is seen in the above log is:

    Microsoft.TeamFoundation.Server.WarehouseException: TF255040: Install SQL Reporting Services or at a minimum SQL Client Connectivity Tools on the application tier to ensure Analysis Services object model is present for warehouse processing.

    Can you double check that you have the SQL Client Tools installed on your app tier?

    Thursday, September 13, 2012 4:50 PM

All replies

  • Hi Clint, 

    Thanks for your post.

    Please ensure the following steps:

    1        Check the Microsoft.AnalysisService dll(version:10.0.0.0) have already existed in GAC or not.

    2        Ensure the Tfs_Analysis DB created under Analysis Service, and ensure the http://servername/Reports(defualt path) can open correctly.

    3        In TFS Admin Console>>Application Tier>>Reporting, click Edit to open the Reporting window, under Analysis Services tab, click Test  Connection button, ensure can connect successfully.

    If you have any further research of this issue, please share your experience here.   


    John Qiao [MSFT]
    MSDN Community Support | Feedback to us

    Monday, September 10, 2012 5:30 AM
    Moderator
  • Hi Clint, 

    If misunderstood anything, please describe your question in more detail and we will be able to provide the better responses.


    John Qiao [MSFT]
    MSDN Community Support | Feedback to us

    Tuesday, September 11, 2012 8:11 AM
    Moderator
  • It appears that the warehouse is processed and both the warehouse and cube builds just fine, but it is failing on processing the cube. The exception that is seen in the above log is:

    Microsoft.TeamFoundation.Server.WarehouseException: TF255040: Install SQL Reporting Services or at a minimum SQL Client Connectivity Tools on the application tier to ensure Analysis Services object model is present for warehouse processing.

    Can you double check that you have the SQL Client Tools installed on your app tier?

    Thursday, September 13, 2012 4:50 PM
  • Hi James,

    Thanks for the reply.

    I didn't have the SQL Client Tools feature installed on my app tier. I have now added it.

    I'll see how this helps and I may do a rebuild of reporting.

    Do you have any other suggestions?

    Regards

    Clint

    Thursday, September 13, 2012 7:20 PM
  • No problem! If you try again and are seeing a different error, definitely post back the error and we can get it worked out. Otherwise, let me know if that did the trick!

    -James

    Thursday, September 13, 2012 9:15 PM
  • Hi, 

    I have the same problem, did this help? I do not have the client tools installed either but do not think this is the issue.

    Regards

    Geraint

    Monday, November 19, 2012 3:24 PM
  • Hi Geraint,

    This solution/answer actually did resolve my issue. I added clients tools to my second app tier and that cleared it up.

    I hope you see the same results.

    Regards

    Clint

    Monday, November 19, 2012 3:47 PM