Accepted Solution

FearNoMore:

1.Query to list RES_UID ,

SELECT RES_UID FROM MSP_RESOURCES WHERE RES_NAME LIKE ‘Enter the resource name’

2.Query to list Project name and task name where resource is status manager

select a.proj_name,b.task_name from msp_projects as a , msp_tasks as b ,
msp_assignments as c where b.task_uid=c.task_uid and a.proj_uid=c.proj_uid and
c.WRES_UID_MANAGER like ‘Copy RES_UID of the resource’

3. Query to list orphaned records where resource is status manager.

select * from msp_assignments where WRES_UID_MANAGER like ‘Copy RES_UID of the
resource’

4.Query to delete orphan records where resource is status manager.

delete from msp_assignments where WRES_UID_MANAGER like ‘Copy RES_UID of the
resource’

5.Query to list all the projects where resource is the owner.

select proj_name,proj_uid from msp_projects where proj_uid in (select proj_uid from
MSP_WEB_SECURITY_PROJECT_OWNERS_PUBLISHED_VIEW where res_uid like ‘Copy RES_UID of
the resource’)

6.Query to list all Orphaned records where resource is the owner.

select * from MSP_WEB_SECURITY_PROJECT_OWNERS where res_uid like ‘Copy RES_UID of
the resource’

7.Query to delete orphaned records where resource is the owner.

delete from MSP_WEB_SECURITY_PROJECT_OWNERS where res_uid like ‘Copy RES_UID of the
resource’

Follow these actions
================

Ø If query 2 lists any project name and task name. Open those projects and replace
the status manager.
Ø If query 5 lists any projects. Open PWA àProject centerà Edit properties and
replace the project owner.
Ø If query 3 and 6 lists any orphaned records, delete those orphaned records with query 4 and 7.

Accepted Solution

04/11/09 12:48 PM, ID: 24123227Author Comment

MOSS_Lover:

Dear FearNoMore

was in vacation

Thank you so much. I have deleted the user finally.

now if I add any user or group to be synced to the AD group to be synced it gets failed with the same event above !!

If I keep exisiting users it will success :(

any clue

04/13/09 11:07 PM, ID: 24135296Author Comment

MOSS_Lover:

Dear FearNoMore

I have applied WSS 3.0 and office server 2007 infrastructure update and every thing is perfect now

thanks for your help