question

shashank-2951 avatar image
0 Votes"
shashank-2951 asked shashank-2951 answered

SharePoint 2013 Popularity Trend Empty for one site collection

One site collection shows ZERO data from last 6 months after running Popularity Trends report. Earlier it used to show the data. Also, we can see this report working fine for other site collections. Only 1 site collection is having this empty data issue which is weird.
The search is crawling the site, WSS_Usage service application is also running, Reporting feature is also active. What could I check other than these?
@trevorseward

office-sharepoint-server-administrationoffice-sharepoint-server-development
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.

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

Hello @shashank-2951 ,

Please perform the following troubleshooting

1.Please make sure this site collection is added to content source & crawled successfully.

130157-s1.png

2.Make sure Microsoft SharePoint Foundation Usage Data Import and Microsoft SharePoint Foundation Usage Data Processing timers jobs are running.

130181-s2.png

3.Check the SharePoint ULS Logs to check proper logs files are being generated.

  • C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\LOGS

130182-s4.png

4.If the SarePoint Server says Upgrade Available. Please make sure you install the latest CU and run PSConfig Wizard in all the SharePoint Servers.

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.







s1.png (63.3 KiB)
s2.png (37.5 KiB)
s4.png (76.2 KiB)
· 4
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.

All these checks are done and it looks fine. Also please note that popularity trends is running fine for all the site collections. It is only one site collection which is showing ZERO values. And all the above checks are farm level. I believe if there was any issue with any of these then the issue should have happened to all the sites and not just one site collection

0 Votes 0 ·

Hi @shashank-2951 ,

Thanks for your reply.

According to my research, the Popularity Trends report is an Excel report that shows daily and monthly hits and unique users per usage event type. The report shows the daily count for the last 14 days and the monthly count for the last three years.

Please check the following points:

1.Does the site collection a recently created one?

2.Has the site collection been accessed orused in the past 14 days?

3.Whether the site collection is search crawled?

For example: I created a Crawl Rule so that the site collection will not be crawled when performing a search crawl.

130976-s1.png

130928-s2.png

Thanks,
Echo Du


0 Votes 0 ·
s1.png (71.4 KiB)
s2.png (64.4 KiB)

Hi @EchoDu-MSFT This site was created many years ago and is being accessed extensively as well as being crawled regularly. Also as mentioned in my first comment, we were getting regular report till around 6 months back. Not sure what happened suddenly

0 Votes 0 ·

Hi @shashank-2951 ,

This is indeed a very strange phenomenon

Please navigation to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\LOGS\RequestUsage.

In the logging folder, we need to find a folder called RequestUsage. In this folder, if healthy and working correctly, we will see a .tmp file and periodically a .usage* file being generated. If there is no file being created in here then the site is not listening for page requests.*

130970-k1.png

We suggest you take the following measures:

1.Install the latest CU package

2.Delete the Health and usage service application in Central Admin. Then re-enable it by going to Monitoring >> Configure usage and Health Data Collection and then checking the Enable usage data collection and Enable health data collection check boxes and validating the other information.

131043-k2.png

Thanks,
Echo Du


0 Votes 0 ·
k1.png (32.0 KiB)
k2.png (109.7 KiB)
shashank-2951 avatar image
0 Votes"
shashank-2951 answered

CU we are updating regularly. It says 'No Action Required'
Regarding Deleting the service application, I am not very comfortable because it is a production environment and all other sites are showing regular popularity reports.
For the logs, Please see below
131315-capture5.png



capture5.png (35.6 KiB)
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.