Tuesday, May 14, 2013

Errors with Webanalytics Reports in SharePoint 2010

Error:

There is no data available for this report. Here are some possible reasons: 
(1) Web Analytics has not been enabled long enough to generate data; 
(2) There is insufficient data to generate this report; 
(3) Data logging required for this report might not be enabled;
(4) Data aggregation might not be enabled at the level required for this report

Solution:

Clear SharePoint CONFIGURATION cache. (not output cache, configuration cache).
  1. Stop the Windows SharePoint Services Timer service
  2. Navigate to the cache folder
    • In Windows Server 2008, the configuration cache is in the following location: %SystemDrive%:\ProgramData\Microsoft\SharePoint\Config\GUID
    • In Windows Server 2003, the configuration cache is in the following location: %SystemDrive%:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\GUID
  3. Locate the folder that has the file "Cache.ini" in it
  4. Back up the Cache.ini file. DO NOT DELETE THIS FILE
  5. Delete all the XML configuration files 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.
  6. Edit the Cache.ini file and replace all content with "1" (without quotes).
  7. Start the Windows SharePoint Services Timer service
  8. Make sure the the xml files are re-created in after you start the service
  9. Wait untill all files are re-created and the value in the Cache.ini file matches the one on the backup file and repeate the procedure on every SharePoint servers in the farm.
References:
http://www.rogeriocruzeiro.com/tech-blog/item/clear-the-sharepoint-configuration-cache