Unknown Resource in an approved TimesheetLine RRS feed

  • Question

  • Hello all,

    we are working with an on-premise installation of MS Project Server 2013. When we use the ODATA-Feed "timesheetlines" or a SQL-Query based on the User-Views, we get some approved TimesheetLines with the resource "Unknown Resource".

    Does everyone know the reason for that and how we can solve this?

    Thank's a lot for your help!

    • Edited by Hae_Thomas Tuesday, April 25, 2017 6:48 PM
    Wednesday, April 12, 2017 6:54 AM

All replies

  • Hello all,

    Does no one have an idea?

    Thank's a lot for your help!

    Tuesday, April 25, 2017 6:48 PM
  • Sounds like resources have been deleted from enterprise resource pool and timesheet lines are still pointing to them.

    Look at task assignment for project list for any clues as to who is missing?  Try republishing projects that have the missing resources. 

    its also possible that the database has a corrupt record and it may require a support call to Microsoft to fix the issue.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Tuesday, May 2, 2017 3:33 AM