Still unable to resolve adding new users to Enterprise Resource Po

J

juzion

Previous post: I have created an intial Enterprise Resource Pool few months
back. I have new
users coming in and would like to add them into this pool, but I have been
unable to, encountering an Update error in MS SQL with a check option
constraint.

someone suggested that there is a need to maintain consistency between the
Web_Resources, Resources, and Calendar tables, other wise the system will not
permit any additional resources to be added. The way to check is to compare
these three tables in a query to see if there is one record that is either
missing in one or more of the tables.

However, I am not sure what to look out for.
i.e. the field columns to compare etc.

Please elaborate and advise possible solutions.

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to add new resource 0
Unable to add new resources to Enterprise Resource Pool 3
AD Enterprise Resource Pool Synchronization & Domain Users Group 3
Restore custom fields in entry table of Enterprise Resource Pool 5
Proj Pro2002 - Unable to edit or add new resources to Enter Resour 1
Unable to add new resources or update existing resources 1
An import error when build team from enterprise resource pool 1
Deleting corrupted(?) users/resources from Project Server 2007 3

Top