SharePoint 2019 UsageAnalyticsTimerJob Failed to retrieve event configuration.

Question

Hi,

New OOTB 2019 farm. From time to time I receive critical event in ULS:

Unable to validate whether OOB event type definition collection is up to date and update it: Microsoft.SharePoint.SPException: We're sorry, we weren't able to complete the operation, please try again in a few minutes. If you see this message repeatedly, contact your administrator.
at Microsoft.Office.Server.SPScaleOutDatabaseMap.CreateSqlSession(ISPScaleOutDatabaseMapProvider mapProvider, Byte[] compositeKey, Guid forceRefreshVersion, Guid& version)
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.Execute(ExecuteDelegate operation, ISPScaleOutDatabaseMapProvider mapProvider, SPSqlCommand command, Byte[] compositeKey)
at Microsoft.Office.Server.Search.Analytics.AnalyticsReportingApi.GetTenantSettings(Guid tenantId)
at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.GetRawAnayticsTenantSettings(Guid tenantId)
at Microsoft.Office.Server.Search.Analytics.AnalyticsTenantConfigCollection.GetSingle(IAnalyticsServiceApplication application, Guid tenantId)
at Microsoft.Office.Server.Search.Analytics.AnalyticsEventTypeDefinitionCollection.IsOOBEventTypeDefinitionsCurrent(SearchServiceApplication serviceApplication)
at Microsoft.Office.Server.Search.Analytics.UsageAnalyticsUtils.GetEventTypeConfiguration(SearchServiceApplication searchApp, String UATimerJobId, AnalyticsTenantConfigCollection& tenantConfig, Boolean initialRun)

The scale out database mappings cache has been refreshed for service id 87bcdfd7-0e06-46f3-bea9-530946ed07ac. The new mappings are as follows:
Gap encountered before execution at end - Composite Key: 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00, Composite Key End NULL. Query details: The query range start: 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00, end NULL.
A valid and working database containing the necessary range data cannot be found. Composite Key: 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00
Unable to instantiate AnalyticsTenantConfigCollection(): Microsoft.SharePoint.SPException: We're sorry, we weren't able to complete the operation, please try again in a few minutes. If you see this message repeatedly, contact your administrator.
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.ThrowOperationalDatabaseCannotBeFound(Byte[] compositeKey, Byte[] compositeKeyEnd, Exception exception)
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.CheckForGapRetrialAndAddSkipped(Byte[] currentGapStart, Byte[] currentGapEnd, List1 skippedRanges, Byte[] retrialGapPoint, Byte[] nextRetrialRangeEnd, Boolean afterExecution, Boolean start, IEnumerable1 sqlSessionsWithRange, Byte[] queryStart, Byte[] queryEnd, Boolean mappingsRefreshExpected)
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.ExecuteOnMultipleDatabasesInternal(ExecuteAndReturnRecords executeAndReturnRecords, UpdateState updateState, ISPScaleOutDatabaseMapProvider mapProvider, SPSqlCommand command, Byte[] compositeKeyStart, Byte[] compositeKeyEnd, Boolean parameterValuesDependOnCumulativeResults, Boolean justReportGaps, Guid& cachedMappingsVersion, Guid forceRefreshVersion, Int32 partitionKeySize, List1 skippedRanges, Byte[] retrialGapPoint, Byte[]& nextRetrialGapPoint, Object state, Boolean isRangeEndExclusive, Boolean& shouldContinue) at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.ExecuteOnMultipleDatabasesInternal(ExecuteAndReturnRecords executeAndReturnRecords, UpdateState updateState, ISPScaleOutDatabaseMapProvider mapProvider, SPSqlCommand command, Byte[] compositeKeyStart, Byte[] compositeKeyEnd, Boolean parameterValuesDependOnCumulativeResults, Boolean justReportGaps, Guid& cachedMappingsVersion, Guid forceRefreshVersion, Int32 partitionKeySize, List1 skippedRanges, Byte[] retrialGapPoint, Byte[]& nextRetrialGapPoint, Object state, Boolean isRangeEndExclusive)
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.ExecuteOnMultipleDatabases(ExecuteAndReturnRecords executeAndReturnRecords, UpdateState updateState, ISPScaleOutDatabaseMapProvider mapProvider, SPSqlCommand command, Byte[] compositeKeyStart, Byte[] compositeKeyEnd, Boolean parameterValuesDependOnCumulativeResults, Int32 partitionKeySize, List`1 skippedRanges, Boolean justReportGaps, Boolean isGapRetrial, Guid retrialMappingsTicket, Guid& mappingsTicket)
at Microsoft.Office.Server.SPScaleOutDatabaseCommandExecutor.ExecuteOnMultipleDatabases(ExecuteAndReturnRecords executeAndReturnRecords, UpdateState updateState, ISPScaleOutDatabaseMapProvider mapProvider, SPSqlCommand command, Byte[] compositeKeyStart, Byte[] compositeKeyEnd, Boolean parameterValuesDependOnCumulativeResults, Int32 partitionKeySize)
at Microsoft.Office.Server.Search.Analytics.AnalyticsReportingApi.GetTenantSettingsBatch(Int32 batchSize, Guid lastTenantId)
at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.GetRawAnalyticsTenantSettingsBatch(Int32 batchSize, Guid lastTenantId)
at Microsoft.Office.Server.Search.Analytics.AnalyticsTenantConfigCollection.GetAll(IAnalyticsServiceApplication application, Int32 maxBatchSize)
at Microsoft.Office.Server.Search.Analytics.UsageAnalyticsUtils.GetEventTypeConfiguration(SearchServiceApplication searchApp, String UATimerJobId, AnalyticsTenantConfigCollection& tenantConfig, Boolean initialRun)
UsageAnalyticsTimerJob-87bcdfd7-0e06-46f3-bea9-530946ed07ac : Failed to retrieve event configuration.

Cannot find any failed timer jobs and unable to reproduce.
Can it be ignored, if not, how to fix?

Thanks

Answer 1

@Sergey Pelikh

If it does not affect the daily operation of SharePoint, it can be ignored. And you could follow below tips to troubleshoot the issue.

1.Clear cache.
(1)Stop the SharePoint Timer Service.
(2)Go to this directory %ALLUSERSPROFILE%\Microsoft\SharePoint\Config\
(3)There can be multiple folders here, backup the Cache.ini file.
(4)Remove all files except the Cache.ini file.
(5)Open the Cache.ini and remove the content of that file.
(6)Start the SharePoint Timer Service again.
2.Run the SharePoint Products Configuration Wizard.

---

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.