Hello,
I have exactely the same issue withProjectServer2003. I am very
interested if you have any solution ?
Thanks.
- Show quoted text -
Hi Alain,
I have been dealing with the same problem for three days. And today,
finally, I fixed it!
To put it shortly, in my case the problem was with MSP_RESOURCES
table. Please note, without looking inside the DB it is impossible to
find the problem. So, just query the Project Server DB with:
SELECT RES_UID, RES_ID, RES_EUID
FROM MSP_RESOURCES
WHERE (PROJ_ID = 999) AND (RES_UID > 0)
999 - PROJ_ID for your project. Can be gotten from the MSP_PROJECTS
table.
In the list I have found the duplicates for the resource with
partucular EUID. This is the problem. I have tested a few solutions on
the dev server and have choosen the softest one.
So, just change EUID for the one of the resources to NULL (convert it
to local). Then when you open the schedule (!!!!Oh, it is miracle!!!!)
you will find TWO resources with the same names! But now one of them
will be local one. So, if you are lucky, local resource will have no
assignments. So, go ahead and remove it from the schedule. Save the
project and enjoy the weekend!
Frankly, before changing the EUID I have determined (from the
MSP_ASSIGNMENTS table) which resource (EUID) does not have
assignments. Otherwise, you will have to come back and change EUID for
the another resource.
If you have any questions, please do not hesitate to ask!
Good luck,
Igor
P.S.
Please note, I have described my own case. Yours could be different.
