SharePoint Web Analytics service not showing any data "Solution"

Web Analytics service in SharePoint was not showing any data, all the values were showing as zero. The main reason might be that the data may not be flowing to logging DB or Staging DB.

Below are the few checks to start the troubleshooting process:

• Check the web analytics service is running in central admin.
• Check the timer job status.
• Check event logs in all servers including DB server.

In my case we had this below error in the event logs of DB server:

"The Execute method of job definition Microsoft.SharePoint.Administration.SPUsageImportJobDefinition (ID GUID) threw an exception. More information is included below.
An update conflict has occurred, and you must re-try this action. The object SPUsageServiceInstance was updated by domain\serviceaccoutn, in the OWSTIMER (ID) process, on machine SharePointFrontEndServer. View the tracing log for more information about the conflict."

and which is why the analytics report was showing zero numbers. To fix this issue, we followed some steps to clear cache files from all the servers(WFE and App server) and restart SharePoint timer service.

Below are the steps to fix this:

To resolve this issue, clear the file system cache on all servers in the server farm on which the Windows SharePoint Services Timer service is running. To do this, follow these steps:

• Stop the Timer service. To do this, follow these steps:
• Click Start, point to Administrative Tools, and then click Services.
• Right-click Windows SharePoint Services Timer, and then click Stop.
• Close the Services console.
• On the computer that is running Microsoft Office SharePoint Server 2007 and on which the Central Administration site is hosted, click Start, click Run, type explorer, and then press ENTER.
• In Windows Explorer, locate and then double-click the following folder:
• Drive:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\GUID
• Notes
• The Drive placeholder specifies the letter of the drive on which Windows is installed. By default, Windows is installed on drive C.
• The GUID placeholder specifies the GUID folder.
• The Application Data folder may be hidden. To view the hidden folder, follow these steps:
• On the Tools menu, click Folder Options.
• Click the View tab.
• In the Advanced settings list, click Show hidden files and folders under Hidden files and folders, and then click OK.
• In Windows Server 2008, the configuration cache is in the following location:
• Drive:\ProgramData\Microsoft\SharePoint\Config\GUID
• Back up the Cache.ini file.
• Delete all the XML configuration files in the GUID folder. Do this so that you can verify that the GUID folder is replaced by new XML configuration files when the cache is rebuilt. 

Note When you empty the configuration cache in the GUID folder, make sure that you do not delete the GUID folder and the Cache.ini file that is located in the GUID folder.

• Double-click the Cache.ini file.
• On the Edit menu, click Select All.
• On the Edit menu, click Delete.
• Type 1, and then click Save on the File menu.
• On the File menu, click Exit.
• Start the Timer service. To do this, follow these steps:
• Click Start, point to Administrative Tools, and then click Services.
• Right-click Windows SharePoint Services Timer, and then click Start.
• Close the Services console.
• Note The file system cache is re-created after you perform this procedure. Make sure that you perform this procedure on all servers in the server farm.
•  Make sure that the Cache.ini file has been updated. For example it should no longer be 1 if the cache has been updated.
• Click Start, point to Programs, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
• Click the Operations tab, and then click Timer job status under Global Configuration.
• In the list of timer jobs, verify that the status of the Config Refresh entry is Succeeded.
• On the File menu, click Close.

Hope this will fix your issue.

Reference : https://support.microsoft.com/en-us/help/939308/error-message-when-you-try-to-modify-or-to-delete-an-alternate-access