http://blogs.technet.com/b/manharsharma/archive/2012/10/13/sharepoint-2010-web-analytics-troubleshooting-reporting-db.aspxWe can divide the Troubleshooting of Web Analytics into 3 different multiple parts. The data is moves from 1.) .usage files are created on all the WFEs. 2.) Data moves from .usage files to Stagingen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/manharsharma/archive/2012/10/13/sharepoint-2010-web-analytics-troubleshooting-reporting-db.aspx#3570166Wed, 01 May 2013 13:42:55 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3570166Cool<p>Hi Manhar,</p> <p>This is very helpful for me.</p> <p>But can you help me of how to troubleshoot if the Data moved from Staging Database to Reporting Database it is showing LAST AGGREGATION TIME is showing null value in my case where it is supposed to show current datevalue, when I run a query in SQL SELECT * FROM WASETTING.</p> <p>It would really be helpful if you suggest me how to remove null value coming for LAST AGGREGATION TIME.</p> <p>THANKS for your help.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3570166" width="1" height="1">http://blogs.technet.com/b/manharsharma/archive/2012/10/13/sharepoint-2010-web-analytics-troubleshooting-reporting-db.aspx#3525904Sat, 13 Oct 2012 23:01:18 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3525904Hezequias Vasconcelos<p>Very good article congratulations. Thanks for sharing the information.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3525904" width="1" height="1">