We recently had a problem with a brand new Project Web App (PWA) site in Project Server Subscription Edition (SE). Database views used for reporting (normally suffixed by UserViews) were missing from the pjrep schema in the content database.
Running Repair-SPProjectWebInstance -Identity 'https://domainname.for.pwa.site/sites/sitename' -RepairRule 7 did not resolve this issue.
There were two sites in the content database, one site that had been soft deleted and the actual site.