none
Web Analytics Report DB Issue RRS feed

  • Question

  • Hi,

    We have a Sharepoint 2010 farm running fine since 2011, last month users reported us that web analytics was not working anymore on all web apps.

    After usual checks (https://blogs.msdn.microsoft.com/sharepoint_strategery/2012/03/16/troubleshooting-sharepoint-2010-web-analytics/), it seemed that everything was OK.

    Staging DB is correctly updated (From WASetting) :

    LastLoggingExtractionTime 2018-05-15T07:24:05.440

    But report DB is not :

    LastAggregationTime 2018-02-21T01:05:02.130 The time of the last successfully completed data aggregation

    First, i tried to delete then recreate Web Analytics & Proxy Service App keeping same DBs => no success.

    So i tried to recreate Web Analytics with new DB and it's working now.

    Any idea of what the issue with old Analytics report DB could be ?

    Wednesday, May 16, 2018 6:24 AM

All replies