Following are some of the errors that I encountered and resolutions:
Error:
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 6398
Task Category: Timer
Level: Critical
Keywords:
User: CONTOSO\spfarm
Computer: SPCONTOSO.contoso.com
Description:
The Execute method of job definition Microsoft.SharePoint.Administration.SPAppStateQueryJobDefinition (ID 885fac36-1363-4bc4-9e44-8f2ca4ac3a07) threw an exception. More information is included below.
Sorry, we can’t seem to connect to the SharePoint Store. Try again in a bit.. (Correlation=a031439e-6306-10bf-7f83-5043a769c083)
Resolution: If the error is occuring aroung 3 AM on SP server that does not have access to internet, CEIP (customer Experience Improvement Program) could be trying to contact CEIP server on the internet Disable CEIP at the farm level CA->System Settings->Configure Privacy Options and also disable in each web application including the SP Central Admin Web application
Error:
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 5214
Task Category: Database
Level: Critical
Keywords:
User: CONTOSO\SPServiceApps
Computer: SPCONTOSO.contoso.com
Description:
Insufficient SQL database permissions for user ‘Name: CONTOSO\SPServiceApps SID: S-1-5-21-1194933823-2077494717-1782085268-1112 ImpersonationLevel: None’ in database ‘SharePoint_Config’ on SQL Server instance ‘SharePointSQL’. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object ‘proc_putObjectTVP’, database ‘SharePoint_Config’, schema ‘dbo’.
Resolution:Give spserviceapps SPDataAccess permission to SharePoint_Config database.
Error
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 7043
Task Category: Web Controls
Level: Error
Keywords:
User: NT AUTHORITY\IUSR
Computer: SPCONTOSO.contoso.com
Description:
Load control template file /_controltemplates/15/KpiListFormTemplates.ascx failed: Could not load file or assembly ‘Microsoft.Office.Excel.WebUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.
Resolution:Ignore. Not an issue. As the file wasn’t included in 2016.
Error:
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 6398
Task Category: Timer
Level: Critical
Keywords:
User: CONTOSO\spfarm
Computer: SPCONTOSO.contoso.com
Description:
The Execute method of job definition Microsoft.SharePoint.Administration.SPAppStateQueryJobDefinition (ID 885fac36-1363-4bc4-9e44-8f2ca4ac3a07) threw an exception. More information is included below.
Sorry, we can’t seem to connect to the SharePoint Store. Try again in a bit.. (Correlation=fb5b439e-43df-10bf-7f83-572c7bea06cc)
Resolution:Disable App State Update. CA->Monitoring-Timer Jobs->Review Job Definitions- Disable App State Update. This is require only if you have purchased or installed apps from the SharePoint Store and to make sure the apps are up to date and updates the app in the farm if required.
Errors: The root of the certificate chain is not a trusted root authority. Resolution:SP does not recognize the Exchange server self-signed certificate. Go to Exchange servcer export the Exchange servers’ self signed certificate from the MMC. Go to Central Amdinistration->Security->General Security->Manage Trust-> New, give the name, browse the Exchange self-signed certificate from above, keep all the setting to default and click on. Use the script to test if it works now. Validation script should return True.
Error:
Log Name: Application
Source: Microsoft-SharePoint Products-SharePoint Foundation
Event ID: 8311
Task Category: Topology
Level: Error
Keywords:
User: CONTOSO\spadmin
Computer: SPCONTOSO.contoso.com
Description:
An operation failed because the following certificate has validation errors:
Subject Name: CN=CONTOSO-EXCH
Issuer Name: CN=CONTOSO-EXCH
Thumbprint: 8B3B09BBE626945D2FC1275879CA43DC4A820384