Blogs

Construction du cube OLAP dans Project Server 2010 - Messages d'erreur – Trust Relationship

  • Comments 1
  • Likes

Bonjour,

Un autre message d’erreur (assez rare) que vous pouvez recevoir lors de la construction du cube OLAP est le suivant:

===== Initiating OLAP database build process =====

[9/30/2010 9:23 AM] Cube build request message has been added to the Project Server queue
===== Verifying and running pre-build server event handler =====
[9/30/2010 9:23 AM] Verifying and running pre-build server event handler
===== Determining database and OLAP database structure =====
[9/30/2010 9:23 AM] Cube build initialization started
[9/30/2010 9:23 AM] OLAP database and cube structure was determined successfully
===== Building database and cubes =====
[9/30/2010 9:23 AM] Cube build session started
===== Process Completed =====
[9/30/2010 9:24 AM]
Failed to build the OLAP cubes. Error: Error Setting Olap Database 'CubeprodITrepor' roles: Error: The trust relationship between the primary domain and the trusted domain failed.

Ce message est du a un ou plusieurs comptes d’utilisateur incorrects parmi ceux qui ont accès au cube OLAP.

Pour tous les comptes qui ont accès au cube OLAP il suffit de suivre les étapes suivantes:

- Identifier le GUID du cube OLAP; exécutez le script suivant sur la base Published:

select WADMIN_AS_DATABASE_UID from MSP_WEB_ADMIN_CUBE

- Récupérez ce GUID et exécutez la procedure stockée suivante:

EXEC MSP_WEB_SP_QRY_GetAllCubeViewDomainAccount 'GUID CUBE'

Une fois que vous avez obtenu la liste de ces utilisateurs vérifiez les comptes Windows et corrigez-les si nécessaire.

Dragos Diamandescu

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Thanks for sharing the information. I've 800+ accounts in the role membership in a inherited system. How to quickly find out which ones are inactive without going through each one in the list?

    Faisal Masood
    http://www.softvative.com
    PMP
    MCSE, MOS: SharePoint 2013
    MCITP, MCTS: SharePoint 2010
    MCSA: Office 365
    MS: MS Project 2013
    MS: Azure
    SharePoint, Office 365, Azure, ProjectServer EPM Consultant