locked
TFS Sharepoint Project Dashboard Reporting Errors RRS feed

  • Question

  • Hello,

    When I browse to the shrepoint project dashboard I get Reporting Services Error for both the Task Burndown and Burn Rate.

      • An error has occurred during report processing. (rsProcessingAborted) Get Online Help
        • Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand) Get Online Help
        • The Team System cube either does not exist or has not been processed.

    • An error has occurred during report processing. (rsProcessingAborted) Get Online Help
      • Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand) Get Online Help
        • The Team System cube either does not exist or has not been processed.

      • Any help would be great.  Thanks,

      • PS
      • I also see this when checking getprocessingstatus

      • <?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>2013-03-07T21:23:26.1051038Z</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="2013-03-07T20:29:24.26Z" ExecutionStartTimeUtc="2013-03-07T20:29:25.287Z" EndTimeUtc="2013-03-07T20:29:25.67Z" Result="Succeeded" />
        </Job>
        - <Job Name="Full
        Analysis Database Sync
        "
        JobProcessingStatus
        ="Idle">
        - <LastRun QueueTimeUtc="2013-03-07T10:00:00Z"
        ExecutionStartTimeUtc
        ="2013-03-07T10:00:00.92Z" EndTimeUtc="2013-03-07T10:00:11.617Z" Result="Failed">
        <ResultMessage>[Full Analysis Database Sync]: --->
        AnalysisDatabaseProcessingType=Full, needCubeSchemaUpdate=True. --->
        Microsoft.TeamFoundation.Warehouse.WarehouseException: TF221122: An error
        occurred running job Full Analysis Database Sync for team project collection or
        Team Foundation server TEAM FOUNDATION. --->
        Microsoft.TeamFoundation.Warehouse.WarehouseException: Failed to Process
        Analysis Database 'Tfs_Analysis'. --->
        Microsoft.TeamFoundation.Warehouse.WarehouseException: Warning: Errors in the
        OLAP storage engine: The attribute key cannot be found when processing: Table:
        'dbo_DimFile', Column: 'FileExtension', Value: '.SCT'. The attribute is 'File
        Extension'.Errors in the OLAP storage engine: The process operation ended
        because the number of errors encountered during processing reached the defined
        limit of allowable errors for the operation. Errors in the OLAP storage engine:
        An error occurred while the 'File' attribute of the 'Version Control File'
        dimension from the 'Tfs_Analysis' database was being processed. Errors in the
        OLAP storage engine: The process operation ended because the number of errors
        encountered during processing reached the defined limit of allowable errors for
        the operation. Internal error: The operation terminated unsuccessfully. Errors
        in the back-end database access module. The read operation was cancelled due to
        an earlier error. Errors in the OLAP storage engine: An error occurred while the
        'File' attribute of the 'Version Control File' dimension from the 'Tfs_Analysis'
        database was being processed. Errors in the OLAP storage engine: The process
        operation ended because the number of errors encountered during processing
        reached the defined limit of allowable errors for the operation. Server: The
        current operation was cancelled because another operation in the transaction
        failed. Warning: Parser: Out of line object 'Binding', referring to ID(s)
        'Tfs_Analysis, Team System, FactCurrentWorkItem', has been specified but has not
        been used. Warning: Parser: Out of line object 'Binding', referring to ID(s)
        'Tfs_Analysis, Team System, FactWorkItemHistory', has been specified but has not
        been used. Warning: Parser: Out of line object 'Binding', referring to ID(s)
        'Tfs_Analysis, Team System, v Fact WorkItem To Tree', has been specified but has
        not been used. Warning: Parser: Out of line object 'Binding', referring to ID(s)
        'Tfs_Analysis, Team System, v Fact Linked Current WorkItem', has been specified
        but has not been used. Warning: Parser: Out of line object 'Binding', referring
        to ID(s) 'Tfs_Analysis, Team System, Fact WorkItem To Category', has been
        specified but has not been used. Warning: Parser: Out of line object 'Binding',
        referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem Changeset', has
        been specified but has not been used. Warning: Parser: Out of line object
        'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Project',
        has been specified but has not been used. Warning: Parser: Out of line object
        'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Details',
        has been specified but has not been used. Warning: Parser: Out of line object
        'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Code Churn', has
        been specified but has not been used. Warning: Parser: Out of line object
        'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Test Result
        Overlay', has been specified but has not been used. Warning: Parser: Out of line
        object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build
        Changeset', has been specified but has not been used. Warning: Parser: Out of
        line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build
        Coverage', has been specified but has not been used. Warning: Parser: Out of
        line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact
        WorkItem Test Result', has been specified but has not been used. Warning:
        Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team
        System, v Fact Linked Current Work Item Test Case', has been specified but has
        not been used. Warning: Parser: Out of line object 'Binding', referring to ID(s)
        'Tfs_Analysis, Team System, Fact Run Coverage', has been specified but has not
        been used. at
        Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(String
        finalXmla) at
        Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType
        processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed,
        Boolean cubeSchemaUpdateNeeded) --- End of inner exception stack trace --- at
        Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType
        processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed,
        Boolean cubeSchemaUpdateNeeded) at
        Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext
        requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime,
        String& resultMessage) at
        Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext
        requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime,
        String& resultMessage) --- End of inner exception stack trace
        ---
        </ResultMessage>
        </LastRun>
        <NextRun QueueTimeUtc="2013-03-08T10:00:00Z"
        JobState
        ="QueuedScheduled" />
        </Job>
        - <Job Name="Incremental Analysis Database Sync" JobProcessingStatus="Idle">
        - <LastRun QueueTimeUtc="2013-03-07T20:24:38.447Z" ExecutionStartTimeUtc="2013-03-07T20:24:39.103Z" EndTimeUtc="2013-03-07T20:24:41.053Z" Result="Blocked">
        <ResultMessage>[Incremental Analysis Database Sync]: --->
        TF221106: Reporting for Team Foundation Server cannot execute job Incremental
        Analysis Database Sync for TEAM FOUNDATION because the Analysis Services
        processing is offline. Use the Team Foundation Administration Console to start
        reporting.
        </ResultMessage>
        </LastRun>
        </Job>
        </Jobs>
        </Instance>
        - <Collections>
        - <Collection Name="Advantage360"
        JobProcessingStatus
        ="Idle" JobsRunning="0"
        JobsQueued
        ="0">
        - <Jobs>
        - <Job Name="Build
        Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:27:21.053Z" ExecutionStartTimeUtc="2013-03-07T20:27:22.403Z" EndTimeUtc="2013-03-07T20:27:22.623Z" Result="Succeeded" />
        </Job>
        - <Job Name="Common
        Structures Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:51:19.41Z" ExecutionStartTimeUtc="2013-03-07T20:51:19.717Z" EndTimeUtc="2013-03-07T20:51:19.947Z" Result="Succeeded" />
        </Job>
        - <Job Name="Test
        Management Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:27:21.053Z" ExecutionStartTimeUtc="2013-03-07T20:27:22.403Z" EndTimeUtc="2013-03-07T20:27:22.743Z" Result="Succeeded" />
        </Job>
        - <Job Name="Version
        Control Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:27:21.053Z" ExecutionStartTimeUtc="2013-03-07T20:27:22.403Z" EndTimeUtc="2013-03-07T20:27:24.16Z" Result="Succeeded" />
        </Job>
        - <Job Name="Work Item
        Tracking Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:27:21.053Z" ExecutionStartTimeUtc="2013-03-07T20:27:22.403Z" EndTimeUtc="2013-03-07T20:27:37.78Z" Result="Succeeded" />
        </Job>
        </Jobs>
        </Collection>
        - <Collection Name="DefaultCollection"
        JobProcessingStatus
        ="Idle" JobsRunning="0"
        JobsQueued
        ="0">
        - <Jobs>
        - <Job Name="Build
        Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:26:25.43Z" ExecutionStartTimeUtc="2013-03-07T20:26:26.17Z" EndTimeUtc="2013-03-07T20:26:26.41Z" Result="Succeeded" />
        </Job>
        - <Job Name="Common
        Structures Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:26:25.417Z" ExecutionStartTimeUtc="2013-03-07T20:26:26.17Z" EndTimeUtc="2013-03-07T20:26:27.16Z" Result="Succeeded" />
        </Job>
        - <Job Name="Test
        Management Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:26:25.43Z" ExecutionStartTimeUtc="2013-03-07T20:26:26.17Z" EndTimeUtc="2013-03-07T20:26:26.45Z" Result="Succeeded" />
        </Job>
        - <Job Name="Version
        Control Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:26:25.43Z" ExecutionStartTimeUtc="2013-03-07T20:26:26.17Z" EndTimeUtc="2013-03-07T20:48:32.78Z" Result="Succeeded" />
        </Job>
        - <Job Name="Work Item
        Tracking Warehouse Sync
        "
        JobProcessingStatus
        ="Idle">
        <LastRun QueueTimeUtc="2013-03-07T20:26:25.43Z" ExecutionStartTimeUtc="2013-03-07T20:26:26.17Z" EndTimeUtc="2013-03-07T20:26:58.9Z" Result="Succeeded" />
        </Job>
        </Jobs>
        </Collection>
        </Collections>
        </WarehouseProcessingStatus>
    Thursday, March 7, 2013 9:51 PM

Answers

  • Hi Ozzy,

    Thanks for your post!

    First, please go to SQl Server Configuration Manager, and verify that All related SQL Servers are running(i.e. SSAS, and SQL Server Browser), and The network protocols "Shared Memory" and "TCP\IP" are enabled for the instance.

    If that doesn’t resolve the issue, make sure the user is a member of a group (or single user) that has been granted BROWSER Role permissions on the SSRS Server.

    • Open SQL Server Management Studio
    • Connect to the Reporting Server
    • Select Home->Properties
    • Add Domain/Users group for example and select Browser role.

    Hope it helps!

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 8, 2013 8:09 AM
    Moderator

All replies

  • Hi Ozzy,

    Thanks for your post!

    First, please go to SQl Server Configuration Manager, and verify that All related SQL Servers are running(i.e. SSAS, and SQL Server Browser), and The network protocols "Shared Memory" and "TCP\IP" are enabled for the instance.

    If that doesn’t resolve the issue, make sure the user is a member of a group (or single user) that has been granted BROWSER Role permissions on the SSRS Server.

    • Open SQL Server Management Studio
    • Connect to the Reporting Server
    • Select Home->Properties
    • Add Domain/Users group for example and select Browser role.

    Hope it helps!

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 8, 2013 8:09 AM
    Moderator
  • Hi Ozzy,

    I marked the reply as answer, if you have any concern with it, please feel free to unmark it.

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, March 19, 2013 1:54 AM
    Moderator
  • Hi!

    I'm experimenting the same error, but in my case, everything was working normal until somebody change the password of the account used by TFS Server, Reporting Services and SharePoint. I have to manually change the password on the IIS Application Pools, on the Windows Services and on PowerShell for SharePoint. I also use the Reporting Services Configuration Manager to change the password on The Service Account and the Database. Finally I change the password on the Team Foundation Administration Console on Reporting. Everything Works fine, except the Release Burndown report.

    The first error is: "Validation Parameter Error. (rsParameterError)"... Then I go to Team Foundation Administration Console on Reporting and do a Start Rebuild, that's when the error goes to: "An error has occurred during report processing. (rsProcessingAborted). Query execution failed for dataset 'dsArea'. (rsErrorExecutingCommand)"

    Any idea of what can I do?

    Thanks!

    Friday, September 19, 2014 4:17 PM