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