title: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server
body: <p>We are running TFS 2012 in our house for around 3 months and in particular "processing of cubes" was working fine till 14/08. At that point is just stopped to work (nothing was done on the server &lt;- or at least I didn't found any changes yet)</p>
  
  <p>What we get in the windows log looks like this:</p>
  
  <blockquote>
    <p>Detailed Message: TF221122: An error occurred running job Full
    Analysis Database Sync for team project collection or Team Foundation
    server TEAM FOUNDATION. Exception Message: Failed to Process Analysis
    Database 'Tfs_Analysis'. (type WarehouseException) 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&amp; resultMessage)    at
    Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext
    requestContext, TeamFoundationJobDefinition jobDefinition, DateTime
    queueTime, String&amp; resultMessage)</p>
  </blockquote>
  
  <p>Inner Exception Details:</p>
  
  <blockquote>
    <p>Exception Message: Errors in the high-level relational engine. The
    following exception occurred while the managed IDbConnection interface
    was being used: . Errors in the high-level relational engine. A
    connection could not be made to the data source with the DataSourceID
    of 'Tfs_AnalysisDataSource', Name of 'Tfs_AnalysisDataSource'. Errors
    in the OLAP storage engine: An error occurred while the dimension,
    with the ID of 'Dim Team Project', Name of 'Team Project' was being
    processed. Errors in the OLAP storage engine: An error occurred while
    the 'ProjectNodeSk' attribute of the 'Team Project' dimension from the
    'Tfs_Analysis' database was being processed. Internal error: The
    operation terminated unsuccessfully. Errors in the high-level
    relational engine. The following exception occurred while the managed
    IDbConnection interface was being used: . Errors in the high-level
    relational engine. A connection could not be made to the data source
    with the DataSourceID of 'Tfs_AnalysisDataSource', Name of
    'Tfs_AnalysisDataSource'. Errors in the OLAP storage engine: An error
    occurred while the dimension, with the ID of 'Dim Team Project', Name
    of 'Team Project' was being processed. Errors in the OLAP storage
    engine: An error occurred while the 'Project Node Type' attribute of
    the 'Team Project' dimension from the 'Tfs_Analysis' database was
    being processed. Errors in the high-level relational engine. The
    following exception occurred while the managed IDbConnection interface
    was being used: . Errors in the high-level relational engine. A
    connection could not be made to the data source with the DataSourceID
    of 'Tfs_AnalysisDataSource', Name of 'Tfs_AnalysisDataSource'. Errors
    in the OLAP storage engine: An error occurred while the dimension,
    with the ID of 'Dim Team Project', Name of 'Team Project' was being
    processed. Errors in the OLAP storage engine: An error occurred while
    the 'Is Deleted' attribute of the 'Team Project' dimension from the
    'Tfs_Analysis' database was being processed. Errors in the high-level
    relational engine. The following exception occurred while the managed
    IDbConnection interface was being used: . Errors in the high-level
    relational engine. A connection could not be made to the data source
    with the DataSourceID of 'Tfs_AnalysisDataSource', Name of
    'Tfs_AnalysisDataSource'. Errors in the OLAP storage engine: An error
    occurred while the dimension, with the ID of 'Dim Team Project', Name
    of 'Team Project' was being processed. Errors in the OLAP storage
    engine: An error occurred while the 'Project Node Name' attribute of
    the 'Team Project' dimension from the 'Tfs_Analysis' database was
    being processed. Errors in the high-level relational engine. The
    following exception occurred while the managed IDbConnection interface
    was being used: . Errors in the high-level relational engine. A
    connection could not be made to the data source with the DataSourceID
    of 'Tfs_AnalysisDataSource', Name of 'Tfs_AnalysisDataSource'. Errors
    in the OLAP storage engine: An error occurred while the dimension,
    with the ID of 'Dim Team Project', Name of 'Team Project' was being
    processed. Errors in the OLAP storage engine: An error occurred while
    the 'Project Path' attribute of the 'Team Project' dimension from the
    'Tfs_Analysis' database was being processed. Server: The current
    operation was cancelled because another operation in the transaction
    failed.</p>
    
    <p>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.</p>
  </blockquote>
  
  <p>...</p>
  
  <p>so far :
  - I've tried to force full processing of the cube, thru instruction from here <a href="http://msdn.microsoft.com/en-us/library/ff400237(v=vs.100).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ff400237(v=vs.100).aspx</a> 
  - I've tried to "rebuild reporting" from "TFS admin console"->"Application tire"->"Reporting"->"Start rebuild:
  - finally I've also tried just to process directly from "SQL Managment studio" : Tfs_analysie->Process
  - I've checked c:\olap\logs\msmdsrv file and I didn't found any errors there</p>
  
  <p>beside that we also tried to:
  - restart server
  - restart just services</p>
  
  <p>nothing of above helped.</p>
  
  <p>Our TFS is :
  - hosted on one machine 
  - updated to "Update 3" (right after setting it up)
  - we use three different domain account to host TFS services, SQL, reporting services &lt;- but nothing get changed in names/password of those account since installation. I've also verified that those accounts have access to proper databases. </p>
  
  <p>Does anyone have similar problem ? Any ideas are really welcome.</p>