Need clarifications on Resource Engagement (migrated 2013 to 2016) RRS feed

  • Question

  • Dear Experts

    Recently i have migrated successfully from PS 2010 to 2013 and 2013 to 2016 with 3500+ plans and 5000+ users

    However i need some clarification on Resource Engagement part, I just ran below SharePoint Powershell command (existing PS 2013 resource plans for use as resource engagement) and it went without any issues

    Migrate -SPProjectResourcePlans -URL <PWA URL>

    My questions is, when i execute below query in SQL against Publish schema


    Select * from pjpub.MSP_RESOURCE_PLANS

    Why is it showing only one record against projectUID ? what does it mean ?

    Any idea ?



    Sunday, November 27, 2016 5:01 AM


  • Hi Santosh,

    I have not yet done a migration with resource plans so far. So just an assumption: Only published Resource Plans will be migrated ( So maybe your Resource Plans haven't been published before?

    Had your resource plans be published in PS2013? Have a look at 2013, if it is still available:

    SELECT *

    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    Sunday, November 27, 2016 8:55 AM