Category not opening on clicking giving error message

When I click a category on Manage Categories page in Project Sever 2010 it gives an error with a corelation ID. On analyzing the ULS log it gives the message:

Project Server   Project Web App    2q1k      Exception       System.Data.ConstraintException: Column 'PROJ_UID' is constrained to be unique.  Value '(unique identifier)' is already present.    at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent) . Any suggestions?
freezegravityAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
freezegravityAuthor Commented:
Thanks for tje links provided. In our case only 1 item out of over 80 items in the list on manage categories page goes to error on AddModifyCategory page. Rest of the items are opening fine. The item cannot be deleted yet. I had the chance to glance through  the above links before also but they mostly deal with issues concerning all the items. Not sure how to apply to our case or how to go troubleshooting further.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.