Project Server 2013 and Project Online: What happened to my resources?

*** Update 2/16/2015 - This fix has been in every CU and PU since April 2014 - so please patch rather than using the KB.  The final fix in the April 2014 CU and newer was slightly different in implementation that the stored procedure change shown in the KB - so do not be alarmed if you see that your DB has slightly different sprocs than listed in the KB.  Some additional where clauses were added in the final fix, but the KB did do the job of making sure the resource deletions stopped.  ***

*** Update 2/13 - please also see Knowledgebase article - for published details on this issue - including a detection script and a SQL command to correct a stored procedure to avoid this problem - only applicable to Project Server 2013 - Project Online is already patched ***

We have been working on this Project Server 2013 and Project Online ‘Lost Resources’ bug for a little while and we finally have it nailed, and already have the fix deployed to Project Online to ensure it cannot have any further effect there.  Now we wanted to share more information – as we have something actionable.  The scenario is that you open a plan and find that your resources appear to be gone.  Depends where you look, but you either see them as apparent material resources in the resource sheet – with no name, or in the Gantt you see numbers where you expected to see names – and similarly they are material resources in the resource form.  So imagine your plan looked like this:

Original Plan

You could open the plan and you find it is looking like this instead – with the resources missing. In this case two look like material resources – just one remains.  The numbers (8) in this case is coming from the hours of work.

Missing Resources showing with numbers instead

The resource sheet will look like this:

Missing resources blank

There are some variations on this theme – if all resources are removed from a task – or if you carry on using the plan, and try to add the resources back through build team, or publish the plan – then the symptoms can change and the resources can show as multiple <unassigned resource> placeholders – so best if you see the original issue to just close and don’t save – and follow the advice below.  The unassigned resource condition looks like the following.

Unassigned Resources

If you experience this then we can certainly help you if you open a support incident.  We do not charge for support incidents that are bugs – so you will either be refunded if you open a fixed cost incident, or you will not be decremented if this is a Premier incident.  Use your normal channels, either Premier or any of the options at – or in Project Online get one of your Project Online/Office 365 administrators to go to the Office 365 Admin Center, click the Support link in the left navigation ( and then click new service request – middle right on the page. 

In Project Server 2013 the easiest recovery is to just restore from the administrative backup (the timing of my recent reminder to make sure it was running was not an accident - Project Server 2013- Check your administrative backups before you need them). 

For Project Online one option is to open from the Published store – and then overwrite the working store – assuming you haven’t published.  If you are time tracking then this isn’t a good idea as GUIDs change and assignments won’t match the current timesheet.  We can help with the recovery if you open an incident.

The good news is that we have a fix to stop this happening again which, as I mentioned, we have already applied to all our Project Online customers.  As with most fixes, this addresses the original problem but does not correct the downstream issues.  Due to the nature of the issue we can address some of this correction in the database.  For on-premises customers we are pushing hard to get this into the next available fix package – but it will certainly be in the April Cumulative update for Project Server 2013.  And we are able to assist any customers who open an incident with the means to stop this happening again right now.

There could be some variations in the steps that lead to this issue – but in basic terms saving a plan over another plan after having removed some resources may also remove those resources from other plans they are assigned in.  It takes them out of the team – but their assignments still  exist.  One scenario, and the one used to produce the screenshots above was to create an enterprise project plan that included some of the resources in the plan (Project1), then use save-as to overwrite another server plan that also includes those resources (Project2).  You will then find that the removed resources are also removed from other plan too (Project1 in this example).

So to summarize:

  • If you are running Project Online and see this issue open an incident (even though we have fixed Project Online the issue may still be in plans you haven’t even opened).  If you are not time-tracking then opening a copy from the published store may get you back where you need to be
  • If you are running Project Server 2013 then you should stop using save-as back to the server from Project Professional 2013 (or Project Pro for Office 356) until you have the fix (open an incident and we can get it to you).  We will update this post when we know if we can beat the April CU release – but it will certainly be in the April 2014 Cumulative Update for Project Server 2013
  • Quickest recovery for Project Server 2013 customers already affected by this is to restore all the affected plans from an administrative backup
  • If you haven’t seen the issue yet – you can still open a support incident to get the fix earlier than the April CU if you are concerned about this scenario

Some people may remember a similar sounding issue with 2010 – but this isn’t the same thing or same root cause.  This wasn’t and isn’t a problem that could occur in 2007 or 2010.  Also this was in Project Server 2013 and Project Online since the release – so don’t be afraid to apply cumulative updates – this wasn’t introduced by any of them.

If you have hit this issue then we are very sorry for the inconvenience and frustration that bugs like this can cause – we have been pushing hard to both get this fixed and make sure we can assist with any clean-up that you need.

Comments (26)

  1. anonymouscommenter says:

    I’ve also discovered the end user can fix the issue by adding the resource back to the team using Build Team. Assuming meta data is configured for the resource, double-clicking the blank row in the Resource Sheet will allow you to determine who is missing
    based on fields like Resource Manager and Role. Will be opening a ticket to get the fix for our on-premise solution, thanks!!

  2. anonymouscommenter says:

    Brian Tengo un caso en Project Prof 2013, lo he probado en varias PCs de varias empresas y es el mismo caso. Cuando abro la ventana de "Asignar recursos" y asigno el recurso seleccionado a la tarea, no se asigna el que seleccione sino el primero de la
    lista, a veces selecciona otro al azar, hago el intento varias veces y luego acepta mi selección. Creo que es un bug. ahora estoy asignando los recursos desde otras opciones, pero este caso es especial.

  3. anonymouscommenter says:

    Hi we just had the same issue with two project plans. One (team) resource became converted to a blank local material resource. We had been able to fix it by converting it to a local work resource first and then replace the resource in the build team dialog.
    To be able to do so we had to remove all actual data from this resource in the plan, but this was OK for us, as we are able to push the actuals back into the plan from an external timesheeting system. But in our case no one saved the plan as file and back
    to the server. So there might be more reasons that lead to the issue.

  4. anonymouscommenter says:

    We were greatly affected by this. Started noticing something strange mid-December, but nothing in the blogs and root cause not known yet. Took several different routes to try to fix including those mentioned above. Finally received the full fix scripts
    and have just finished a manual restore of 70 projects. Too much would have been lost in an Admin Restore back to December. Crossing my fingers for Monday morning that everything is still OK. Need to build User confidence now. Is a big hill to climb after
    this issue.

  5. anonymouscommenter says:

    We had some early signs in Mid December, but it was not until January that the full force of this major Microsoft bug, hit our projects. Both the Business and IT Teams have spent many, many hours applying patches, correcting projects, etc…. The impact
    that this has caused our Business, not to mention our reputation is incalculable. The confidence in the system has been severally damaged and our entire global roll-out has been placed on hold. We have now finally implemented the Store Procedure modification
    to our system, as supplied by Microsoft and corrected all of our projects for the third/fourth time. After reviewing the fix, I am feeling slightly more confident that it should stop this issue from reoccurring. But as a member of the IT Team responsible for
    maintaining this system. It has deeply affected me personally. Right now, if any one asks me whether to install or upgrade to 2013, I will tell them to wait or look to another more stable platform. We now are embarking on a new journey, rebuilding confidence
    in the system that may take many more months to come. Our global roll-out is still on hold, pending this cooling down period.

  6. anonymouscommenter says:

    When Microsoft give you the patch, ensure you apply it to both the DRAFT and PUB versions of the Store Procedure. Although I am not sure what good it will do, because we still have the issue. Even after spending countless hours fixing all of our projects.
    Referring to my earlier post; Rebuild user confidence? Rebuild Project Server 2013, if I were you Microsoft. Right now, I wish we never upgraded to 2013.

  7. Thanks for the feedback everyone – and Darlene and Matthew – sorry you got hit so hard with this one. I do appreciate this hits confidence hard and not just for your users in the system – but your confidence in Microsoft. I do hope you give us the chance
    to gain your confidence again. Matthew, you are correct that the fix should be applied to both draft and pub schema. We often have mirrored stored procedures in both schema and the ‘pub’ version is not actually used – but even so it makes sense to have it
    ‘correct’. Best regards, Brian.

  8. anonymouscommenter says:

    Hi Brain, When will be the patch for this issue will be released ? Thanks and Regards, Mustaq Hussain.

  9. Hi Mustaq, it will definitely be in the April CU – we have just missed out on getting it into SP1. We are looking to other options to get it out publically as soon as possible – but by far the quickest way would be to open a support incident. Best regards,

  10. Hola, Alberto Pajuelo. Muchas gracias por tu comentario. La verdad es que, a raíz de tus indicaciones, no tenemos del todo claro se trate del mismo asunto. Nos gustaría preguntarte si en tu caso estás usando sólo Project PRO sin conectar a un sitio PWA,
    o si pudieras confirmarnos que sí estás conectado a un sitio PWA. También te agradeceríamos nos indicaras la versión de Project PRO 2013 que estás usando. Por si te pudiera resultar de interés, publiqué una versión traducida de este post de Brian, en mi blog,
    relacionado con Project y Project Server en castellano. Me permito hacerte llegar la referencia: Espero te resulte
    de ayuda. Jorge

  11. anonymouscommenter says:

    Hi Brian/Jorge, could you please embed the TSQL or provide a link to the query required to fix/replace the stored procedures in the draft and pub schemas? Keeping my fingers crossed to get it included into SP1 or concurret extracurricular hotfix. I even
    have a Daruma to burn if that helps … Kind regards, Adrian

  12. Hi Adrian, happy to share this with you – but currently we are not releasing via the blog. Use the e-mail the author option at and we can get this to you. Best regards, Brian

  13. Hola, Alberto. Hablando con Brian, nos preguntábamos si no resultaría más recomendable que nos hicieras llegar tu problemática a través de un incidente de Soporte. De esta manera nos resultaría mucho más fácil poder ayudarte. Gracias.

  14. anonymouscommenter says:

    I have been working closely with Microsoft and I know that they have been listening to all of the pain that this caused many users/customers around the world. Their support team, although occasionally slow to respond, have been working with me constantly
    for weeks. For that level of support and dedication, especially since I further understand that they have working around the clock to fully understand this problem, is admirable and gratifying. They also provided some additional scripts, that have been extremely
    helpful in correcting our data. Although we are over the Mountain, we are not as yet off the trail. But despite everything over the last few months; I have regained some degree of confidence in the journey. Thank you Microsoft and Brian for your support.

  15. anonymouscommenter says:

    Hi Brian, I checked in our Case with the SQL script that has been provided in the KB article mentioned. By that I found that "saving a plan over an other" also seems to apply to templates – for which this is the only procedure to edit them. So if you have
    ressources in a template (which makes sense with generic or Team resources), changing the template might also crash the plans. Regards Christoph

  16. anonymouscommenter says:

    Hi Brian, hi Adrian glad to hear that You are able to fix this uggly issue so fast. I already came across this issue in autumn 2013 but nobody knows about that and nowadays 140 Projects are affected in that environment. Hoping that the scripts will prevent
    the issue happening again. Regards from Munich Imma

  17. Thanks Christoph, I and I certainly think templates are an area that has had most affect with this bug. Thanks Matthew too for taking the time to respond again. We are getting there.

  18. If you need any help Imma you know where we are. Best regards, Brian

  19. anonymouscommenter says:

    Good Day Brian, We had a number of live projects affected and have run the patch. I believe all projects were restored successfully except one! Is there a manual workaround to fix one off project which is in progress with work assigned and status applied.
    Thanks in advance, Bill

  20. anonymouscommenter says:

    experienced this. attesting to the pain this one brought on … kudo’s to the Project team for addressing so quickly !

  21. Hi WKC, best open a support incident – no charge as this is a bug – and we can help you through this – and sorry that you hit this one.. Apologies also for the delayed response – the e-mail triggers didn’t fire for these comments for some reason.
    Best regards,

  22. anonymouscommenter says:

    I have a question. I am new at using MS Projects. Has anyone been able to input their budgeted cost for the project and then input the invoice amounts as a task so it automatically updates the budgeted amount for the project?

  23. Yael says:

    Hi Brian,

    We are working with Project Pro 2013. This issue just happened to us today and few months ago with a different file.
    We don’t know what to do. It causes us to escalations and users don’t trust the system.
    Could you please share your solution?

    1. Hi Yael, the solution in this case is to ensure the server is patched up to date – and this fix has been in every update since April 2014. If you are patched beyond that then I’d suggest you open a support incident to work with us to establish what happened in your specific case. Also ensure you have archiving turned on and keeping several versions – that way you can quickly revert to a previous version if you notice something bad happened – whether due to a bug or user error.
      Best regards,

  24. Mchael says:

    We are seeing this exact same issue in Project Online w/ O365. About 100 plans in Project Online and corrupted plans are popping up everywhere…so far about 30 confirmed corrupted plans. Currently MS support is looking at the issue, (going on 3 weeks now) but it is exactly as described here. Resources disappear. We can see the resources missing in Online and when you open the plan you may or may not see numbers…i.e., “[80]” or whatever – which appears to be the UNITS value of the missing resource name. Save the file locally, then reopen and you see al the missing resources set to “Standard” calendar, material duplicates made with blank resource names that coincide with the bad resources.

    While we have a sort of workaround, everyone assures this was taken care of in 2013….but we have a new 2016 deploy Online with MS and still seeing the same thing. (11/2017)

    1. Hi Michael, I am certainly aware of your case and it does feel very similar to this problem we saw before with 2013. At this point I’m not aware of any other customers seeing exactly this behavior but reviewing the case I do note that you see this following a ‘save-as’ – which was implicated in the earlier issue. I’ll speak with the case owner to ensure this is getting the right level of attention.
      Best regards,

Skip to main content