SharePoint 2019 Web Analytics provide empty results

Question

Hello,

Web Analytics are providing empty results and the tables RequestUsage_* in the usage database are empty.

I have done the following to try to fix the issue:
-Checked if Usage and Health Data Collection was configured
-Checked if the Search Service status and topology had any issues
-Verified that the WSS_Admin_WPG and WSS_WPG groups had access to the log file location
-Checked ULS logs for folder RequestUsage and is being populated with files. However in the "C:\Program Files\Microsoft Office Servers\16.0\Data\Office Server" no analytics files were being created.
-Verified that the Microsoft SharePoint Foundation Usage Data Import and Microsoft SharePoint Foundation Usage Data Processing timer jobs were enabled and running successfully.
-Verified the web application pool account and farm account had permission on the WSS_UsageApplication.
-Checked Event receivers for the Usage Service and are present.

When i get the search timer using the script below it shows that it is stopped, i am able to start it with no errors.

$a = Get-SPTimerJob -Type Microsoft.Office.Server.Search.Analytics.AnalyticsJobDefinition
$sa = $a.GetAnalysis("Microsoft.Office.Server.Search.Analytics.SearchAnalyticsJob")
$sa.GetAnalysisInfo()

However even after waiting a full day i still have no data.
Any idea on what else can i do?

Thank you.

Answer 1

Hi @RP ,

Pleas follow the following steps to troubleshooting this issue:

1.Navigate to Central Administration > Manage service applications > Usage and Health Data Collection Service Application and check if the service application is up and running. Make sure you have the events checked under Event Selection.

2.Delete and then rebuild the mentioned service applications if necessary. Usage and Health Data Collection Service Application is enabled via Monitoring > Configure usage and health data collection > check “Enable usage data collection”.

3.Run this commands below:

$instance = Get-SPUsageService  
 $instance.Provision()  
 $instance.Update()  

For Reference: SharePoint 2019 Empty Usage and Health Data Report

---

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

Hi,

I'm currently seeing results in the Usage Database, but when I run the script to get an export I get empty results.
I'm trying, for now, avoiding having to rebuild the service.

$result.GetMonthlyData($date,[REF]$hits,[REF]$uniqueVisitor)

I have checked step 1 and executed script from step 3.