Bonjour,

Je vous propose à nouveau un script que j’avais partagé pour Project Server 2007 et que ‘'j’ai remis à jour pour la version 2013.

Si vous rencontrez des problèmes de mise à jour des temps à partir de Project Server Web App, cela signifie certainement que des transactions ont échouées ou sont en attente.

Ce script vous permet de lire le type, l’état, l’erreur le cas échéant des transactions dans la base de Project Server 2013:

SELECT
 
      MAT.ASSN_TRANS_UID,
      MAT.ASSN_TRANS_SUBMIT_DATE,
      MAT.ASSN_TRANS_UPDATE_DATE,
      MR.RES_NAME AS 'SUBMITTER',
      MP.PROJ_NAME AS 'PROJECT',
      MT.TASK_NAME AS 'TASK',
 
      STATUS =
      CASE ASSN_TRANS_STATE_ENUM
            WHEN '0' THEN '0 - Saved'
            WHEN '1' THEN '1 - Submitted Pending Approval'
            WHEN '2' THEN '2 - In Process'
            WHEN '3' THEN '3 – Apply Successfully'
            WHEN '4' THEN '4 – Apply Failed'
            ELSE CAST (ASSN_TRANS_STATE_ENUM as VARCHAR) + ' - Unknown'
      END,
 
      TYPE =
      CASE MAT.ASSN_TRANS_TYPE_ENUM
            WHEN '0' THEN '0 - Task Assignment Update'
            WHEN '1' THEN '1 - Declined Task Assignment'
            WHEN '2' THEN '2 - Create Task Request'
            WHEN '3' THEN '3 - Delegate Task Assignment Request'
            WHEN '4' THEN '4 - Create Task Assignment Request (assign existing task)'
            WHEN '5' THEN '5 - Team Delegation Request'
            WHEN '6' THEN '6 - Delete Task Request'
            WHEN '7' THEN '7 - Delete Task Assignment Request'
            ELSE CAST (ASSN_TRANS_TYPE_ENUM as VARCHAR) + ' - Unknown'
      END,
 
      ACTION =
      CASE MAT.ASSN_TRANS_ACTION_ENUM
            WHEN '0' THEN '0 - Pending'
            WHEN '1' THEN '1 - Update Approved'
            WHEN '2' THEN '2 - Update Rejected'
            ELSE CAST (ASSN_TRANS_ACTION_ENUM as VARCHAR) + ' - Unknown'
      END,
 
      ERROR =
      CASE MAT.ASSN_TRANS_ERROR_ENUM
            WHEN '0' THEN '0 - Applied'
            WHEN '1' THEN '1 - Undefined'
            WHEN '2' THEN '2 - Conflict'
            WHEN '3' THEN '3 - ProjectDeleted'
            WHEN '4' THEN '4 - InvalidUpdate; InvalidDelegation'
            WHEN '5' THEN '5 - InternalError'
            WHEN '7' THEN '7 - Count'
            ELSE CAST (ASSN_TRANS_ERROR_ENUM as VARCHAR) + ' - Unknown'
      END
 
FROM PUB.MSP_ASSIGNMENT_TRANSACTIONS MAT
INNER JOIN PUB.MSP_RESOURCES MR
ON MAT.ASSN_TRANS_SUBMITTER_RES_UID = MR.RES_UID
INNER JOIN PUB.MSP_PROJECTS MP
ON MAT.PROJ_UID=MP.PROJ_UID
LEFT JOIN PUB.MSP_TASKS MT
ON MAT.TASK_UID=MT.TASK_UID
 
Bonne journée,
 
Marc Biarnès