“TF53010: The following error has occurred in a Team Foundation component or extension” when processing the TFS Cube

The Details of this message are:

“Detailed Message: The pending configuration changes were not successfully added to the cube because of the following error: System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.

at System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess)

at System.Security.Principal.NTAccount.Translate(Type targetType)

at Microsoft.TeamFoundation.Warehouse.OlapCreator.AddAccountToRole(Role role, String accountName, Boolean needToUpdate)

at Microsoft.TeamFoundation.Warehouse.OlapCreator.SetupAnalysisDatabase(Server server, String analysisDBName, String accessUser, String[] dataReaderAccounts)

at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOlap(WarehouseConfig whConf, String accessUser, String[] dataReaderAccounts, Boolean dropDB, Boolean processCube)

at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.EnsureCubeIsUpToDate()”

So what can we do about it?

There are two actions to take in this situation:

Action 1:

Purpose: Removing users that are invalid or old.

Step 1: Connect to your analysis services database using Sql Server Management Studio.

Step 2: Right click on the server node.

Step 3: Select properties and look under the Security tab.

Step 4: Remove any invalid or old users.

Step 5: Browse to Databases –> TfsWarehouse –> Roles

Step 6: Double click on TfsWarehouseDataReader

Step 7: Go to the Membership tab

Step 8: Remove any invalid or old users.

In case this action doesn’t help go to Action 2.

Action 2:

Purpose: Rebuild the OLAP cube.

Go to this Post that I have published in the past and follow the instructions there.

Have Fun!!!