Error opening Resource Pool

[StrongBad]

I have a client who gets the following error whenever they try to open a
project in 2003 Pro.

"There was an error opening the enterprise resource pool. You may not have
sufficent permission to access the selected resource(s). Would you like to
retry?"

If the user hits the Retry button, they are presented with a Select Data
Source window, as if Project was looking for a DSN . If the user hits
Cancel, the project comes up, but they aren't sure if the entire resource
pool is available.

I am pretty stumped as to what could be causing this. Any ideas?

Thanks!!

 

[Vig]

I struggled with this for weeks; The error is caused by out of range
assignment dates being written to the db. It is usually associated with a 24
hour calendarin the project. IF you can query the assignments table in the
db, you can find the bad dates and identify which Project they are in. What I
have done to get rid of the error is: Use Access to identify the bad
assignment and project. Save a copy of the project off line and fix the
assignment. Delete the original project from server, and import the offline
file back into server. Make sure you assign resources only when their
calendar has them available, and do not assign someone 0 hours work.
Microsoft is working on a hotfix for this; should be out soon. Good luck!

Vig

 

[Luigi Stilo]

Vig,
I have resolved the problem monitoring the VWNOTIFY process on project
server and waiting before attempt to do another save until it raise 0. I
don't know way, but it works. I'm using a non-standard calendar with working
days on saturdays an sundays.
If you monitor this process you'll realize that it is high only when you
leave (exit) the project. If you leave open the file, the process is always
zero. Get it a try... and let me know if this resolve your problem. I also
have for this problem a workaround from ms that delete some record in a
table....

 

[LT]

Vig, can you please provide more details such as:

1. Which date field in the assignments table does this affect?
2. What do you mean by "bad" date?
3. Do you also get this error is you assign 0 hour work to a resource?

I've been trying to find a solution for a few days now with no luck.

Thanks for any help I can get.

 

[Vig]

1. ASSN_START_DATE in MSP_ASSN_ENTERPRISE table.
2. A bad date is described by MS error as "out of range or wrong format".
The date in my table rows is 1/1/1984 (no time stamp).
3. The error is related to 0 hours work. In my case we have fixed duration
tasks, so if we assigned a resource to a task when they were not available,
such as resource on days, task at night, Project assigned to the task with 0
work. After making this assignment, the first time I save, leaves the
assnstartdate blank. The next time I open and save the date becomes 1/1/1984
(with no time stamp, which I believe causes the wrong format error)