Unable to add new resources to Enterprise Resource Pool

[juzion]

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. Can anyone advise on this? It is quite urgent. Thanks!

 

[dwolf]

juzion,

We had a problem like this. It turned out we had had a problem with a
deleted resource and had to go through SQL to delete it completely. As
it turned out there was still a record for the resource in the Calendar
table. Evidently you 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.

I hope this helps.

DWolf

 

[Aubrey]

One way to avoid this problem is by only using the clean up database tool
under admin on the web access piece to delete resources. You run into trouble
when you delete it from the project side.

 

[juzion]

Hi DWolf,
Please elaborate further on this as I am not sure what to look out for.
i.e. the field columns to compare etc. Thanks again!