Patch update fail on Project Server Content Database

prabu lk 1 Reputation point
2020-08-02T02:52:06.41+00:00

We are updating the April 2020 patchs KB 4484299 (Language Independent Files) & KB 4484301 April 2020 Patch (Language Dependent Files) update in our SharePoint Server 2016. There is no issues with installation and it was successful, but when we do the configuration wizard it get failed with below error.

I have recreated pjrep.MSP_EpmProject_UserView view but still it deletes the view and throws the below error.

An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information:
Upgrade [SPContentDatabase Name=SP_PRD_Migration_1] failed. (EventID:an59t)

Exception: Cannot drop the view 'pjrep.MSP_EpmProject_UserView', because it does not exist or you do not have permission.Failed to generate the user entity views (EventID:an59t)

Upgrade Timer job is exiting due to exception: System.Data.SqlClient.SqlException (0x80131904): Cannot drop the view 'pjrep.MSP_EpmProject_UserView', because it does not exist or you do not have permission.Failed to generate the user entity views

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,236 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Trevor Seward 11,691 Reputation points
    2020-08-02T22:58:25.93+00:00

    Make sure your timer service account is mapped to the dbo user in your content database(s) prior to running the upgrade.

  2. Itch Sun-MSFT 2,556 Reputation points
    2020-08-03T02:14:54.143+00:00

    Any progress on your troubleshooting?

    You should also check the following:

    1.Restart your Timer service before you run config wizard."Run As Administrator" on the Products Configuration Wizard.

    2.Make sure no other user, other than SharePoint managed accounts, have Database owner permissions for the SharePoint databases

    0 comments