ODATA_VIEW

[AdrienPirson]

Hello,

Recently we noticed a strange phenomenon on our Project Server. Indeed, when we use a Sharepoint administrative restore (custom field or resource and calendar) we notice that the odata views in the Project database have disappeared.

We then recreate these views manually and when we redo the backup and restore operation via Sharepoint administrative restore the phenomenon starts again.

We analyzed all the logs, all the possibilities (by deleting all the projects, by deleting the custom fields, by deleting the resources, ...) and we find absolutely nothing.

Can anyone help us?

[#2]

Hello @AdrienPirson ,

What version of Project Server are you using and what is the build version / patch level for Project Server? 

Paul

[#3]

@Paul_Mather 

MS Project 2019 on premice

[#4]

Hello @AdrienPirson ,

Running the Repair-SPProjectWebInstance <PWA URL> -RepairRule 7 should fix it: https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/repair-spprojectwebinstance?vie... 

It will be worth reviewing the latest patches for PS 2019 for a fix that might prevent this happening again: https://techcommunity.microsoft.com/t5/project-support-blog/project-server-2019-public-updates/ba-p/... 

Paul

[#5]

Hello Paul Mather

Thank you very much for the patch links because I tested with a blank install and I have the same problem. So I think it's a Project bug and I need to find a fix or an update to prevent it from coming back.

For the Repair, I have already tried and it does not work, I rebuild the views manually. But thanks again.

[#6 · Accepted solution]

Hello @AdrienPirson ,

If you are on the latest patches and it still occurs, I would recommend opening a support query with Microsoft.

Many thanks