Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Active Directory Enterprise Resource Pool Synchronization 'WRES_AD_GUID' in table 'Resources' is DBNull" RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I was trying to set "Active Directory Enterprise Resource Pool Synchronization" in Project Server 2010 but I get this error:

    "The synchronization failed. To identify where the errors occurred, see the Windows event log on the server".

     

    Then in the LOG file I see this:

    "SSP Name: Project Server  PSError: NoError (0) A general exception occurred during communication with Active Directory. Context: ExecuteERPSync. Additional Information: An exception occurred when reading resource data and synchronizing the enterprise resource pool with active directory.. Exception Info: The value for column 'WRES_AD_GUID' in table 'Resources' is DBNull."

     

    I don't have any custom fields.

    The Active Directory group has ~200 users, and Enterprise Resource Pool has ~400.

    Should they have the same number before I start the synchronization?

    What should I do?

    Thanks

    Wednesday, April 20, 2011 12:15 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Mario:

    You have some bad or missing data in the resource pool for Active Directory GUIDs. You should set your logging to verbose to see if you can get more detail and determine which resource(s) are causing the error.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Thursday, May 19, 2011 10:40 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I get exactly the same error.
    I've set my logging to verbose but I don't see any relevant informations...

    Just the stack trace :
     PSI:   ULS Event: AdSyncExceptionOccurred, tag tag_8yi7 was associated with exception: System.Data.StrongTypingException: The value for column 'WRES_AD_GUID' in table 'Resources' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.    
    at Microsoft.Office.Project.Server.Schema.ResourceAuthorizationDataSet.ResourcesRow.get_WRES_AD_GUID()     -
     -- End of inner exception stack trace ---    
     at Microsoft.Office.Project.Server.Schema.ResourceAuthorizationDataSet.ResourcesRow.get_WRES_AD_GUID()    
     at Microsoft.Office.Project.Server.BusinessLayer.AdSync.ReadResourceData()    
     at Microsoft.Office.Project.Server.BusinessLayer.AdSync.ExecuteERPSync(MessageContext mContext)

     

    Maybe it could be due to "old" users coming from EPM 2003 (I've got a migrated database).

    Any idea ?

    Nicolas Mattioni
    Wednesday, January 11, 2012 11:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I get exactly the same error.
    I've set my logging to verbose but I don't see any relevant informations...

    Just the stack trace :
     PSI:   ULS Event: AdSyncExceptionOccurred, tag tag_8yi7 was associated with exception: System.Data.StrongTypingException: The value for column 'WRES_AD_GUID' in table 'Resources' is DBNull. ---> System.InvalidCastException: Specified cast is not valid.    
    at Microsoft.Office.Project.Server.Schema.ResourceAuthorizationDataSet.ResourcesRow.get_WRES_AD_GUID()     -
     -- End of inner exception stack trace ---    
     at Microsoft.Office.Project.Server.Schema.ResourceAuthorizationDataSet.ResourcesRow.get_WRES_AD_GUID()    
     at Microsoft.Office.Project.Server.BusinessLayer.AdSync.ReadResourceData()    
     at Microsoft.Office.Project.Server.BusinessLayer.AdSync.ExecuteERPSync(MessageContext mContext)

     

    Maybe it could be due to "old" users coming from EPM 2003 (I've got a migrated database).

    Any idea ?

    Nicolas Mattioni
    I have the same problem. Have you solved? Can you give me some help?
    Monday, September 9, 2013 7:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    When creating a new instance:
    If the administrator user created by default ("AdminProject") has the user account of an existing user, the synchronization fails (    Admin project has WRES_AD_GUID = NULL; existing user has WRES_AD_GUID <> NULL ). I changed the user account of "AdminProject", I disabled the user and I blocked the user synchronization. In this way I solved the problem.
    Tuesday, September 10, 2013 4:00 PM