Active Directory Synch Failure Project Server 2007 Event ID 7710

[daviddiep]

Hello,

When I try to synch my PWA with the Active Directory, I get the following event:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Active Directory Synchronization
Event ID: 7710
Date: 7/27/2011
Time: 9:24:33 AM
User: N/A
Computer: ODC1_ACCESS
Description:
Standard Information:PSI Entry Point:
Project User: OJS\diepd
Correlation Id: a3b446f1-e747-4ade-9e9f-d16efead841b
PWA Site URL: http://mfaccess.in.dc.gov:4905/PWA
SSP Name: SharedServices1
PSError: Success (0)
Active Directory Synchronization cannot start for the enterprise resource pool because the Active Directory Guid was not found in the Project Server Database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Would anyone know how to fix this? Thank you for all your help... this is a great forum.

[EINSTEIN_007]

Well, if you have corrupted assignments, you may use the script to find out:

SELECT MSP_PROJECTS.PROJ_NAME,
MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME,
MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID,
MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID)))

[daviddiep]

Hi Einstein,

Thank you for the recommendation. When I created a script with the information you provided, I get the following... what modifications do I need to make to it?



C:\>SELECT MSP_PROJECTS.PROJ_NAME,
'SELECT' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_ASSIGNMENTS_SAVED.TASK_NAME,
'MSP_ASSIGNMENTS_SAVED.TASK_NAME' is not recognized as an internal or external c
ommand,
operable program or batch file.

C:\>MSP_RESOURCES.RES_NAME,
'MSP_RESOURCES.RES_NAME' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_ASSIGNMENTS_SAVED.ASSN_UID,
'MSP_ASSIGNMENTS_SAVED.ASSN_UID' is not recognized as an internal or external co
mmand,
operable program or batch file.

C:\>MSP_ASSIGNMENTS_SAVED.PROJ_UID,
'MSP_ASSIGNMENTS_SAVED.PROJ_UID' is not recognized as an internal or external co
mmand,
operable program or batch file.

C:\>MSP_ASSIGNMENTS_SAVED.TASK_UID,
'MSP_ASSIGNMENTS_SAVED.TASK_UID' is not recognized as an internal or external co
mmand,
operable program or batch file.

C:\>MSP_ASSIGNMENTS_SAVED.RES_UID
'MSP_ASSIGNMENTS_SAVED.RES_UID' is not recognized as an internal or external com
mand,
operable program or batch file.

C:\>FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
'FROM' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
'MSP_PROJECTS' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_PROJECTS.PROJ_UID INNER JOIN
'MSP_PROJECTS.PROJ_UID' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
'MSP_RESOURCES' is not recognized as an internal or external command,
operable program or batch file.

C:\>MSP_RESOURCES.RES_UID
'MSP_RESOURCES.RES_UID' is not recognized as an internal or external command,
operable program or batch file.

C:\>WHERE (NOT EXISTS
INFO: Could not find files for the given pattern(s).

C:\>(
SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID
)
'SELECT' is not recognized as an internal or external command,
operable program or batch file.
'FROM' is not recognized as an internal or external command,
operable program or batch file.
INFO: Could not find files for the given pattern(s).

C:\>

[Simond]

Can you try to remove AD Sync configured for Resource Pool in additional server settings, and save it as blank i.e. without any AD group configured for Sync, Next again re configure the AD group in Resource pool sync and initiate synchronization, make sure your resources are checked in before sync. Also share the ULS Log erors, next step suggested would be to isolate wether this error is due to specific user or specific AD group

[daviddiep]

Hi Simond,

Do you mean 'Active Directory Resource Pool Synchronization' under Operational Policies? Cause when I go to 'Additional Server Settings' under Operational Policies in PWA, it does not have anything for AD Sync.

Also, where would I find the ULS log?

thanks for all your help!