Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P6 "Ghost" resources - not assigned to WBS/Activity, but exist in Resource Assignments?

6 replies [Last post]
Mon, 2019-02-11 10:30
Marc Timberlake
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 11 Feb 2019
Posts: 6
Groups: None

Hi All,

wondering if anyone has come across this before and has a solution at all?

I've got a project with circa 250k hours remaining, and on 'Activities' screen all looks ok. When I switch to 'Resource Assignments', grouped by WBS, I have three resources sitting outside the project under 'No WBS' / 'No Activity Name' / Blank Activity ID but with remaining hours meaning the total is different. I'm not able to delete them via this screen either, although I am able to delete others?

any help much appreciated

Many thanks

Top

Replies

Tue, 2019-02-12 01:05
#1
Santosh Bhat
User offline. Last seen 26 weeks 6 days ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering

Glad that worked for you

Top
Mon, 2019-02-11 15:57
#2
Marc Timberlake
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 11 Feb 2019
Posts: 6
Groups: None

Thanks for responses.

We've taken a copy of the project. During the copy encountered an error referring to constraining foreign keys in resource assignments virtual table (wording made me think it related to these orphaned resources). Everything now looks ok, and the resources have now disappeared.

Top
Mon, 2019-02-11 13:28
#3
Raymund de Laza
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 22 Nov 2009
Posts: 762
Groups: Civil Engineering, Pinoy Planning Planet Community

Refresh (F5) will do...

Top
Mon, 2019-02-11 12:21
#4
Santosh Bhat
User offline. Last seen 26 weeks 6 days ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering
~duplicate post~
Top
Mon, 2019-02-11 12:20
#5
Santosh Bhat
User offline. Last seen 26 weeks 6 days ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering
Marc. Try taking a copy of the project and see if they are still there. Sometimes just creating a new copy gets rid of these orphaned records.
Top
Mon, 2019-02-11 11:00
#6
David Kelly
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas

Wow. 

Never seen this. Orphan records are very rare.

I would edit them out at the database level.

Top