John smith 2014-07-11 11:43:37
First of all, I apologize for spamming this post on several newsgroup. I
didn’t know which one is the most appropriate one to get the answer to
my question since there isn’t one specifically for ProjectServer2007.
I’m instructed to install and administer ProjectServer2007 so that the
company can use it to share and manage Project Pro 2007 files and
resources. Everything went smoothly; everything except one that is.
We encountered no issue when manually adding user to the Project Web
Access workspace. However the scheduled synchronization always generates
an error. What’s worse, this error actually checks-out resources and the
checked-out resources would be ‘stuck’ in checked-out status.
Getting the checked-out status resolved is not a problem as the database
record/values can be easily updated back to check-in status (i.e. NULL).
set target.res_checkoutby = null
from msp_resources target
where target.res_checkoutby is not null
— and target.res_checkoutby = cast(0 as uniqueidentifier)
And it all would be fine, except we are trying to schedule a daily AD
I suppose I will be fine if I have to keep manually synchronizing it
everyday or as needed. But since the scheduler /is/ there and is
supposed to work but doesn’t… well what gives?
Am I doing anything wrong during the installations? (I followed the
instructions to the letter, then some trial and errors to make it right,
but I think all is well).
Has anyone experienced the same thing?
If yes to Q2, how did you resolve it? Hints appreciated. Workable answer
If no to Q2, do you think this is a Microsoft bug?
Thank you all for reading this lengthy post.