Work resources become material after inactive

[Reinoud]

Hi,

In project server 2007 SP1 I use several work resources that are now
marked as inactive, when opening all resources in project professional
I see several of these inactive work resources been converted to
material resources, which results in errors when trying to save
changes in the resource data.

Anyone got an idea how to fix this?

Reinoud

 

[Marc Soester [MVP]]

Hi Reinoudi,

Do you use AD synch for yoyr resources?

 

[Reinoud]

Dear Marc,

There is no AD sync in place, when looking in the resource ceter these
resources are still marked as work resources, but when openning them in
project, some are marked as material.

Reinoud

 

[Marc Soester [MVP]]

hmmmm, I am sorry Reinoud, I have never come accross this issue or even heard
about it. You may want to open a Microsoft support call.
Sorry I cant be of more help

 

[Reinoud]

Too bad, Thanx for trying anyway.
Anybody else got an idea??

 

[Skip W]

Did you do a 2003 to 2007 migration? My company migrated 2 weeks ago and we
are seeing the same thing. And seeing up to 45 minutes to open, save, or
publish. Did you open a ticket with Microsoft?

 

[Chris C]

Good Day,

we do have the same problem. What's problematic with this is that it
remvoes the actual work from the project, making the status of the project
totally unreliable.

I've openned a service ticket with MSFT. Did you get an answer from them ?
Any fix available ?

 

[Skip W]

I also have a ticket into MS and they are working on it. Notice in your
schedules that the units or "h" in Actual Work changes to no units and while
a number is still there it doesn't roll up into Total Actual Work.
And it gets worse the more these projects are opened and saved. Wh had some
that I just killed after 24 hours of 100% processor churning. These
schedules are now useless unless MS can find a fix.
What I had to do was add a new enterprise field to preserve each resource's
Active/Inactive status and then set all Inactive resources back to Active.
This restores the resource Type back to Work and prevents further schedule
corruption.
Immediately add a new resource enterprise flag field and name it "Active"
and then in PWA select all Inactive resources and bulk edit the selected ones
and set the new Active field to False of No. Then edit the same group in
Project Pro and set all not Active resources to True or Yes.

 

[Chris C]

Thank you Skip,

I Agree with your proposal. I'll get working on it right away.

 

[Chris C]

Skip,

one interesting thing that I found that could help.

If you use the button Deactivate users, the problem will occur (re-Work
resource becomes material resource). However, if you open the user profile,
and toggle it to deactivate with the available drop down box, I can't
reproduce it. Resource stays of type = Work.

Chris

 

[Skip W]

Yes. I also forgot to mention that if you view Email, Windows User Account,
and Type for the affected resources will appear to be ok. Viewing the same
resources again in Project Pro both Email and Windows User Account are blank
and the Type is Material.

 

[JenniferW]

Has Microsoft provided any answers about this? I am having the same issue.

 

[Skip W]

I have submitted an incident report with Microsoft but have not gotten a
solution yet. I will make them aware that you are experiencing this too.

 

[Skip W]

If you open an Inactive Work resource in PWA and then save the resource back
without making any changes, Inactive Work resources become Inactive Material
resources. Microsoft has reproduced the problem and is working on a hotfix.