Missing server side dependencies: number of column pool tables exceeds the database limit

Question

After a migration from SP2013 to SP2016 i got the following errors in the "Health Analyzer":

[Upgrade] The number of column pool tables exceeds the database limit. The tables that exceed this limit and should be dropped are 
[Security] The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'

[Upgrade] The number of column pool tables exceeds the database limit. The tables that exceed this limit and should be dropped are 
[Security] The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'

I don't get any infos or name about the database regarding these errors.

Current System: SP 2016 Patch ver. 16.0.5378.1000

Upgrade status on all databases successful.

PSConfig runs through without problems:

psconfig.exe -cmd helpcollections -installall -cmd secureresources -cmd services -install -cmd installfeatures -cmd applicationcontent -install -cmd upgrade -inplace b2b -force -wait  

How to i get rid of them?

Answer 1

Hi @Thomas Stessl ,

Did you install the CU for SP2016 after the migration was complete?

It is recommended that you install KB3115437.

Fixes the following issues:

• In the SharePoint Central Administration Health Analyzer, the Missing server side dependencies Configuration rule shows multiple errors that should not be listed. For example, on the Configuration category, the explanation says: [Upgrade] The number of column pool tables exceeds the database limit. The tables that exceed this limit and should be dropped.

For more information, please refer to:

https://social.technet.microsoft.com/wiki/contents/articles/35100.sharepoint-2016-august-2016-cu-issue-fixed.aspx

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I removed the list-item directly from the "Review problems and solutions"-list and it seems to be to not reoccur.

Answer 3

Hi @Thomas Stessl ,

Great to know that and thanks for sharing the update here.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

[Missing server side dependencies: number of column pool tables exceeds the database limit]

Issue Symptom:
After a migration from SP2013 to SP2016 i got the following errors in the "Health Analyzer":

[Upgrade] The number of column pool tables exceeds the database limit. The tables that exceed this limit and should be dropped are

[Security] The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'

Current status:
Solution: I removed the list-item directly from the "Review problems and solutions"-list and it seems to be to not reoccur.

You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!