Here are the errors:
An exception occurred in the Project Server.
Project Server encountered a problme with this error code: 9573. Please
contact your server administrator.
In the Event Log:
Application Event log
Source: Microsoft Project Server
Type: Error
Event ID 2
User: NT Authority/Local Service
Component: PDS
Line: 0
Error Number: 0x2565
Description: <Description><![CDATA[CDataAccess.ParseSQLException;
-2147217873 : Cannot insert duplicate key row in object 'MSP_RES_SECURITY'
with unique index 'I_MSP_RES_SECURITY'.]]></Description>
I would appreciate any information anyone has on resolving this problem.
--
Robbit - IT Manager
Hello Robbit,
Error codes between 9300 to 9599 are data access exception errors and
not documented by Microsoft.
I resolved this issue (error code 9573) earlier at one of my work
place.
I am listing my experience here, please take the appropriate action as
per your situation:
9573 Error: This Issue might related to resources in project plan.
*******************************************************
Solution 1: Please open the project plan and in resource sheet view,
see any resource name is appearing twice (sort the names and verify)
The major cause of the error might be resource name added as local
resource in project plan and assigned work. Later the same local
resource added as enterprise resource in resource pool. At this point
Project server unable to map the local resource with enterprise
resource and in result enterprise resource marked as local resource in
project plan.
Delete the wrong resource, but careful while deleting, verify the work
and actula work associated with resource name.
********************************************************************
Solution 2: If unable to find anything from above, you have to deal
this issue from database:
STEPS:
1) Select
RES_NAME,Res_UID,RES_ID,RES_WORK,RES_EUID,RES_ACT_WORK,RES_COST from
msp_resources
where proj_id = xxx
order by res_name
See here carefully :
Any names appearing as twice.
OR
Any enterprise resource appering as local resource
2) You can also run the following query to find out the enterprise
resource EUID and UID info from Enterprise Resource Pool
Select RES_NAME,Res_UID,RES_EUID from msp_resources
where proj_id = 1
order by res_name
Once you identify the wrong resource with no work and no act work from
first query, you have to run the following query to delete the
resource
DELETE FROM dbo.MSP_RESOURCES
WHERE RES_ID = XXX and PROJ_ID = XXX and RES_UID = XXX
DELETE FROM dbo.MSP_RESOURCE_BASELINES
WHERE RES_UID = XXX and PROJ_ID = XXX
***************************************************************
Solution 3:
Save the project to local machine
Fix the resource names by sorting (eliminate any duplicate
names)
Delete the project plan from server
Reload the plan to server.
***************************************************
Thanks
Chak
http://www.epmcentral.com
If Solution 3 is chosen, what happens to the tasks assigned to resources
from the deleted project? Since we are reloading same project, we do not
have any issues here? No duplicated tasks in PWA?
Sara
If you are choosing the solution 3, first of all you have to make sure
there are no pending updates for project. PM need to approve all the
task updates submitted by team members. Once this is done, do the
following:
1) Save the project plan to local machine
2) Delete the project from server
3) Open the project plan saved to your local machine by step 1, fix
the resource names by sorting (eliminate any duplicate names)
4) Import the project plan from local machine to server
5) PM need to Republish Assignments by choosing overwrite actuals
entered by resources
There will not be duplicated tasks in PWA. We already deleted the
instance of the project on step 2. Deletion of the project also
removed tasks and assignments from PWA. But step 5 repopulates the PWA
tasks, assignments and timesheet for that project.
I hope this helps.
Thanks
Chak
http://www.epmcentral.com
Thank you for your support.
I did the following steps, and it did work!
Sara
--
New project administrator
You are most welcome.
Thanks
Chak
> > > Chakhttp://www.epmcentral.com- Hide quoted text -
>
> - Show quoted text -
Although many thanks for the information below.
Sar wrote:
Hi Chak,If Solution 3 is chosen, what happens to the tasks assigned to
03-Jun-08
Hi Chak,
If Solution 3 is chosen, what happens to the tasks assigned to resources
from the deleted project? Since we are reloading same project, we do not
have any issues here? No duplicated tasks in PWA?
Sara
"Chak" wrote:
Previous Posts In This Thread:
On Wednesday, March 07, 2007 2:41 PM
Robbi wrote:
PS 2003 Exception Error Code 9573
Here are the errors:
In the Event Log:
On Wednesday, April 09, 2008 7:09 PM
Stan Kappiris wrote:
Error 9573
Has anyone come up with a solution to this issue?
version: MS Project Server 2003
On Tuesday, June 03, 2008 1:05 AM
Sar wrote:
Hi Chak,If Solution 3 is chosen, what happens to the tasks assigned to
Hi Chak,
If Solution 3 is chosen, what happens to the tasks assigned to resources
from the deleted project? Since we are reloading same project, we do not
have any issues here? No duplicated tasks in PWA?
Sara
"Chak" wrote:
On Wednesday, June 04, 2008 6:04 AM
Chak wrote:
Hi Sara,If you are choosing the solution 3, first of all you have to make
Hi Sara,
If you are choosing the solution 3, first of all you have to make sure
there are no pending updates for project. PM need to approve all the
task updates submitted by team members. Once this is done, do the
following:
1) Save the project plan to local machine
2) Delete the project from server
3) Open the project plan saved to your local machine by step 1, fix
the resource names by sorting (eliminate any duplicate names)
4) Import the project plan from local machine to server
5) PM need to Republish Assignments by choosing overwrite actuals
entered by resources
There will not be duplicated tasks in PWA. We already deleted the
instance of the project on step 2. Deletion of the project also
removed tasks and assignments from PWA. But step 5 repopulates the PWA
tasks, assignments and timesheet for that project.
I hope this helps.
Thanks
Chak
http://www.epmcentral.com
On Apr 9, 6:58=A0pm, Chak <chak...@hotmail.com> wrote:
uplicate
On Tuesday, June 10, 2008 9:01 PM
Sar wrote:
Hi Chak,Thank you for your support.I did the following steps, and it did work!
Hi Chak,
Thank you for your support.
I did the following steps, and it did work!
Sara
--
New project administrator
"Chak" wrote:
On Thursday, June 12, 2008 7:47 AM
Chak wrote:
Re: Error 9573
Sara,
You are most welcome.
Thanks
Chak
ny duplicate
Submitted via EggHeadCafe - Software Developer Portal of Choice
Observations on MSXML 4.0 RTM [RELEASE]
http://www.eggheadcafe.com/tutorials/aspnet/20d234be-2a42-45d4-9bca-87394399f51e/observations-on-msxml-40.aspx