MSP_EPMProject_Userview is missing in Project Server 2016

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

Regards

Santosh

Answer 1

Hello 

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

https://blogs.technet.microsoft.com/projectsupport/2016/07/08/project-server-2016-missing-some-userviews/

Wharton

---

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

Answer 2

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

Regards

Santosh

Answer 3

There is a fix in the March update for Project Server 2016:

https://support.microsoft.com/en-us/help/3178672/march-14-2017-update-for-sharepoint-server-2016-kb3178672

Paul

---

Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

Answer 4

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

Regards

Santosh

Answer 5

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.

Thanks,

Ali

Answer 6

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

Regards

Santosh

Answer 7

Dear Experts

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

Regards

Santosh

Answer 8

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

https://blogs.technet.microsoft.com/projectsupport/2016/07/08/project-server-2016-missing-some-userviews/

Answer 9

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.

Answer 10

1.  T-SQL ->   

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

2.   from sp powershell as spadmin

Get-SPDeletedSite

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