Feb15
Finally got my SharePoint usage processing to run for more than a week
Categories: SharePoint<div class=ExternalClass46687BB08CE6425BA1DB0B6351B6B4C6><p>I'm not 100% sure but I think the problem was related to having reporting services installed and then applying SQL SP1 which doesn't upgrade the Reporting Service Database and then SQL Server reporting an error that it couldn't connect to the reporting db (even though this should have nothing to do with MOSS reports?). As soon as this error was reported in the NT Event log, usage analysis would fail (no data in the graph)
</p><p><img src="/blog/Lists/Photos/021407_2304_Finallygotm1.jpg" alt="">
</p><p> but the timer job wouldn't indicate a failure. Selecting the properties of the Report db gives you an Upgrade option. Since doing that I haven't had a usage processing gap<span style="font-family:Wingdings">J</span></p></div>