PS 2003 Exception Error Code 9573

[Robbit]

We have a client on PS 2003 where a single project is throwing an exception
error upon opening. It also generates an item in the Application Event log,
which I detail below. The project opens after you click OK on the error,
but it happens every time and the customer is concerned. I've been searching
and I see many instances where others have asked this question, but cannot
find any answers.

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.

 

[Stan Kappiris]

Has anyone come up with a solution to this issue?
version: MS Project Server 2003

 

[Chak]

Has anyone come up with a solution to this issue?
version: MS Project Server 2003

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

 

[Sara]

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]

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

 

[Sara]

Hi Chak,

Thank you for your support.
I did the following steps, and it did work!

Sara

 

[Chak]

Sara,

You are most welcome.

Thanks
Chak

Hi Chak,

Thank you for your support.
I did the following steps, and it did work!

Sara
--
New project administrator













- Show quoted text -

 

[Saikat]

I could not find the solutions link here anywhere. The solution 3 Sara mentions here, I assume, is the same as the solution mentioned under the below link:
http://epmcentral.com/pjadmin/ps03err9573.php

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

Sar

:

Previous Posts In This Thread:

PS 2003 Exception Error Code 9573
We have a client on PS 2003 where a single project is throwing an exception
error upon opening. It also generates an item in the Application Event log,
which I detail below. The project opens after you click OK on the error,
but it happens every time and the customer is concerned. I've been searching
and I see many instances where others have asked this question, but cannot
find any answers

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 lo
Source: Microsoft Project Serve
Type: Erro
Event ID
User: NT Authority/Local Servic

Component: PD
Line:
Error Number: 0x256
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

Error 9573
Has anyone come up with a solution to this issue
version: MS Project Server 2003

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

Sar

:

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 sur
there are no pending updates for project. PM need to approve all th
task updates submitted by team members. Once this is done, do th
following

1) Save the project plan to local machin

2) Delete the project from serve

3) Open the project plan saved to your local machine by step 1, fi
the resource names by sorting (eliminate any duplicate names

4) Import the project plan from local machine to serve

5) PM need to Republish Assignments by choosing overwrite actual
entered by resource

There will not be duplicated tasks in PWA. We already deleted th
instance of the project on step 2. Deletion of the project als
removed tasks and assignments from PWA. But step 5 repopulates the PW
tasks, assignments and timesheet for that project

I hope this helps

Thank
Cha
http://www.epmcentral.co

uplicate

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

Sar
-
New project administrato

:

Re: Error 9573
Sara

You are most welcome

Thank
Cha



ny duplicate


Submitted via EggHeadCafe - Software Developer Portal of Choice
Observations on MSXML 4.0 RTM [RELEASE]
http://www.eggheadcafe.com/tutorial...ca-87394399f51e/observations-on-msxml-40.aspx