question

AvaTomlinson-7607 avatar image
0 Votes"
AvaTomlinson-7607 asked EchoDu-MSFT commented

SharePoint 2016 - Popularity Trends usage report return 0 value.

o to site settings and click on popularity trends.
when download the excel it shows 0 values instead of no. of site visits.

Troubleshooting

Checked following things:-

  1. We have connected to search service farm and Search Service application is connected to the web application

  2. Search is actively crawling the content.

  3. "Microsoft SharePoint Foundation Usage Data Import" timers jobs running on schedule.

  4. The daily job is on Schedule.

  5. Checked the ULS logs but no clue as we are not familiar with usage related entries

  6. Event Receivers for both the usage definitions are enabled.

  7. We see data populated in the usage database but still not populated in the usage reports.

office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hello @AvaTomlinson-7607 ,

Step1. Please make sure to enab the Event Receivers:

Page Requests

 $prud = Get-SPUsageDefinition | where {$_.Name -like "Page Requests"}
 $prud.EnableReceivers=  $true
 $prud.Enabled = $true
 $prud.Update()
 $aud = Get-SPUsageDefinition | where {$_.Name -like "Page Requests*"}
 $aud | fl

85552-1.png


For Analytics

 $aud = Get-SPUsageDefinition | where {$_.Name -like "Analytics*"}
 $aud.EnableReceivers=  $true
 $aud.Enabled = $true
 $aud.Update()
 $prud = Get-SPUsageDefinition | where {$_.Name -like "Analytics"}
 $prud | fl

85496-2.png


Step2. Now we wait for 24 hours and everything is working as expected.

85497-3.png

Thanks,
Echo Du
================
If an Answer is helpful, please click "Accept Answer" and upvote it.
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.



1.png (50.4 KiB)
2.png (34.5 KiB)
3.png (34.0 KiB)
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

as mentioned before Event receivers for both usage definitions are enabled, waited for 24 hours still usage report returns 0.85595-image-usage-report.png


0 Votes 0 ·

Hi @AvaTomlinson-7607 ,

Thanks for your reply.

Please perform the following troubleshooting:

1) Make sure your SharePoint Farm is up to date.

Check Manage Servers in Farm from Central Admin and make sure all the servers say No Action Required. If the SarePoint Server says Upgrade Available please make sure you install the latest CU and run PSConfig Wizard in all the SharePoint Server.

2) Check the Usage and Health Data Collection service is running

Because Usage Analytics is part of Search Servcie Application from SharePoint 2013 Onwards, check that the Usage and Health Data Collection service is up and running.

85753-usage.png

Thanks,
Echo Du


0 Votes 0 ·
usage.png (72.0 KiB)

Hi @AvaTomlinson-7607 ,

Would you tell me whether your issue has been resolved or have any update ?
I am looking forward to your reply.

Have a nice day!

Thanks,
Echo Du

0 Votes 0 ·

Hi @AvaTomlinson-7607 ,

Is there anything else I can help with regarding this issue?

You can comment us at any time and we will continue to follow up.

Thanks,
Echo Du

0 Votes 0 ·

Hi @EchoDu-MSFT ,

Good day!

Currently, we have April 2020 CU on SharePoint Environment and we planning to implement the January 2021 CU. I will update you after the CU upgrade.

Thanks,
Ava

0 Votes 0 ·
Show more comments