Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

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]
Marc Timberlake
User offline. Last seen 18 weeks 5 days ago. Offline
Joined: 11 Feb 2019
Posts: 3
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

Replies

Santosh Bhat
User offline. Last seen 5 hours 13 min ago. Offline
Joined: 15 Apr 2005
Posts: 195

Glad that worked for you

Marc Timberlake
User offline. Last seen 18 weeks 5 days ago. Offline
Joined: 11 Feb 2019
Posts: 3
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.

Raymund de Laza
User offline. Last seen 5 hours 10 min ago. Offline
Joined: 23 Nov 2009
Posts: 685

Refresh (F5) will do...

Santosh Bhat
User offline. Last seen 5 hours 13 min ago. Offline
Joined: 15 Apr 2005
Posts: 195
~duplicate post~
Santosh Bhat
User offline. Last seen 5 hours 13 min ago. Offline
Joined: 15 Apr 2005
Posts: 195
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.
David Kelly
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 19 Oct 2004
Posts: 557

Wow. 

Never seen this. Orphan records are very rare.

I would edit them out at the database level.