MSP_EPMProject_Userview is missing in Project Server 2016 RRS feed

  • Question

  • Dear Experts

    I recently migrated from PS 2010 to PS 2016 a month ago and noticed that many views were missing (example - MSP_EPMProject_Userview) hence ran below command to fix this issue

    Repair-SPProjectWebInstance <PWA URL> -RepairRule 7

    Again today i faced the same issue that views are getting dropped out. Does someone experienced same issue in PS 2016 ? Any reasons for root cause ?

    We have experienced same issue in another environment PWA 2016 which is fresh set up (not migrated one)

    Any help on this much appreciated



    Wednesday, January 4, 2017 9:34 AM


All replies

  • Hello 

    It looks like a known issue.   I would check blog from Brian Smith and see Microsoft comes up with a solution.



    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, January 10, 2017 2:23 AM
  • Hi 

    As a work around, "Language Installation job for Project Server Services" timer job can be disabled. After that views are not getting dropped out.

    I hope this will help some one



    Tuesday, January 10, 2017 3:55 PM
  • Wednesday, March 15, 2017 1:42 PM
  • Thank you very much Paul for the info.

    I have already installed March 2017 CU. Let me keep an eye for a month to confirm



    Thursday, March 16, 2017 4:52 AM
  • Hi Santosh,

    We just upgraded to March CU and still getting the errors. Does disabling the Language Installation job for Project Server Services have any effect on other services. We only use English us/uk as local.



    Thursday, March 23, 2017 12:14 PM
  • Hi Ali

    I have  installed March 2017 CU before a week ago. As of now didn't face the issue

    Will let you know if i face any problem in future



    Thursday, March 23, 2017 6:47 PM
  • Dear Experts

    After installation of March 2017 CU, Project server views are still getting dropped out.



    Monday, April 17, 2017 9:22 AM
  • Hello There,

    March update for Project Server 2016 - Done

    "Language Installation job for Project Server Services" timer job can be disabled - Done

    Repair-SPProjectWebInstance <PWA URL> -RepairRule 7 - Done

    OutPut- No result!

    Can any one help as still unable to figure out missing UserViews


    Saturday, November 18, 2017 10:39 AM
  • Hello,

    I know this is a very old thread, but another reason userviews won't be populated will be due to multiple PWA sites on the same content database. There can only be one PWA site per content database in order for the userviews to be created. 

    Run the following SQL query to see how many sites you have:

    select * from pjpub.msp_web_admin

    If more than one show up, move the extra ones to their own content database.
    If a previously deleted site shows up in the query, that is an orphan site and will need to be properly removed in order to create the userviews.

    Wednesday, December 5, 2018 6:07 PM
  • 1.  T-SQL ->   

    SELECT *   FROM [WSS_Content].[pjpub].[MSP_WEB_ADMIN]

    2.   from sp powershell as spadmin


    Remove-spdeletedsite -Identity <siteid>

    3.  T-SQL ->   

    SELECT *   FROM [WSS_Content].[pjpub].[MSP_WEB_ADMIN]

    4. if you have only one PWA in database

    Repair-SPProjectWebInstance -Identity http://domain/sites/pwa -RepairRule 7

    Friday, December 18, 2020 12:54 PM