Resource repeated 46339 times (Error 9446)

[Carolina]

Hello all,

There is a project with a Generic resources (test1) repeated 46339 times on
the resource usage view. The PM claims he hasn't add this resource that many
times, even this resource has not assigment.
Using MS Project Proffessional 2003, we tried to delete some records, but
now we are getting an error when saving (9446)

I need some guidelines, what should be the best, trying to get a backup copy
and upload again?, go into the database to directly delete the records? any
other idea?

Thanks in advance.
Carolina.

 

[Mauricio@BVFG]

Hi Carolina,

I have experienced the same error three times during the last cuple of
months. here you have my solution to it:

1) Open the project file in Project Professional
2) Click on the Assign Resources icon
3) Locate the first record where the dups start - click on it and while
pressing shift scroll down to the bottom of the list - If you have 46k
records it will take a while till you reach the bottom
4) Click the Remove botton on the right side
5) Be very patient because it takes a long time to delete 46K records!
6) When Project Pro finishes deleting the dups save again/publish your files

Your file will be ready to be used again

Hope this help (like Gary says



Mauricio Iannini, PMP, EPM-BlackBelt

 

[Carolina]

Hi Mauricio,
I already did that, but, I can't save!!! the Error 9446 appears. but I can
save it on my disk and delete the rows, I probably will delete and upload
again.

Thanks.
Carolina.