Site Web Analytics Reports not updating

Question

When I go to my site > site settings > Site Web Analytics reports or Site Collection Analytics reports
I get old data as in the ribbon displayed "Data Last Updated: 7/10/2010 4:00:20 AM"

- Web Analytics Data Processing Service & Web Analytics Web Service are "Running"
- Followed http://technet.microsoft.com/en-us/library/ff453926.aspx

No success anyone an idea?

Answer 1

Did you change the SharePoint 2010 Tracing(SPTraceV4) service account recently ? It should be running under the built-in account "Local Service".  To verify the same, click start -> Type "services.msc" to open the services mmc.

Also please check the following In central administration:

• Click Manage services and check whether the Web Analytics Data Processing Service and Web Analytics Web Service are started on each server.
• Click Manage services applications and confirm that web analytics service application is started.

Answer 2

As per http://technet.microsoft.com/en-us/library/ff453926.aspx
- On all servers SharePoint 2010 Tracing(SPTraceV4) is running under the built-in account "Local Service". 

- Web Analytics Data Processing Service & Web Analytics Web Service are "Running" so started on all servers

- Web Analytics , Service Application is started.

 

 

Answer 3

Open up the folder C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS and check if any *.usage files are being created. Is they are being created, does it have any data in it ? Also navigate to central admin -> monitoring -> Configure usage and health collection and check if "Enable Usage Health collection" is enabled.

Answer 4

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS and check if any *.usage files are being created

I see .usage files approx 6mb filled with text.

Configure usage and health collection , Enable Usage Health collection is "Enabled"

Answer 5

Problem still exists, all servers and timer job succeed and even the *.usage files are present and filled.

Anyone got a directon where to look?

Answer 6

Please try to stop web analytics, restart server and then restart web analytics services. If problem still remain, what if you create a new web analytics service application and make it as default in case the web analytics service application wasn't working properly.

 

Thanks & Regards.

---

Lily Wu

Answer 7

Didnt want to create a new Web Analytics service as there is alreay 1 :-)
But prob is fixed.

Stored Procedure on SQL server in Web Analytics DB (deleteweb) didnt run after the Date in 1st post.
So ran the Stored Procedure and Reports are updated.

Answer 8

Hi,

Could you please guide how did you get results. I am still unable to see any data using Web Analytics service. Getting message "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;........"

I will be grateful if you could guide about this.

thanks and regards

---

OSMAN

Answer 9

What did you mean by "Stored Procedure on SQL server in Web Analytics DB (deleteweb) didnt run after the Date in 1st post.
So ran the Stored Procedure and Reports are updated."?

I have the same problem and wanting to know how you fixed it please.

Answer 10

Hi,

I have not got any solution yet. Problem is still there!!!

Regards,

Osman

---

OSMAN

Answer 11

dikkehaaj,

 

Could you take a moment to be a bit more specific? I cannot see any stored procedure called "Deletewebs". I have the exact same issue you do.

 

Thanks.

Answer 12

Sorry hadn't received an e-mail from this topic but this are the DBs and Procedures.

WebAnalyticsServiceApplication_ReportingDB
- proc_DefragmentIndices
- proc_UpdateStatistics
- proc_WA_CleanFloatingFeedbackData
- proc_WA_DeleteInvalidAdjacentHierarchyData
- proc_WA_DeleteInvalidFactData
- proc_WA_DeleteInvalidInventoryData
- proc_WA_PurgeReportingData

WebAnalyticsServiceApplication_StagingDB
- proc_DefragmentIndices
- proc_UpdateStatistics
- proc_WA_EnsureServiceBrokerEnabled
- proc_WA_PurgeStagingData

Answer 13

Dear Dikkehaaj,

 

Thank you for your response, I ran all stored procedures but still getting same problem with web analytics service. Any solution.........???

Regards,

---

OSMAN

Answer 14

Running the stored procedures worked for me.
Did you also follow http://technet.microsoft.com/en-us/library/ff453926.aspx

Answer 15

I have followed every step on suggested URL (http://technet.microsoft.com/en-us/library/ff453926.aspx) but issue is still there.

---

OSMAN

Answer 16

Try to run (all) a couple of Stored Procedures.
Probaly data stuck in the Staging database.

Answer 17

Still not getting any Web Analytics Reports data.

---

OSMAN

Answer 18

In my case there was a missing ndf file in the reporting database filegroup.

I checked that with the ULSViewer for reviewing ULS logs.

Failed to execute the command '[dbo].[proc_WA_AggregateClickByDate]'. Exception: The filegroup "WebAnalyticsServiceApplication_ReportingDB_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxAggregation20120212" has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added.

Check with this script if there is missing files

SELECT f.*,g.groupname, g.status AS FGStatus FROM sysfiles f right OUTER JOIN sysfilegroups g ON f.groupid= g.groupid

If so then run the following script to recreate the missing file, change the names to the apropriate ones

DECLARE @DBFilePath NVARCHAR(2000)
DECLARE @SQL nvarchar(1000)

SELECT @DBFilePath=LEFT(filename,LEN(filename)-CHARINDEX(N'\', REVERSE(filename))+1) FROM sysfiles WHERE RIGHT(filename,3)='mdf'
print @DBFilePath

IF NOT EXISTS (SELECT 1 FROM sysfiles f INNER JOIN sysfilegroups g ON f.groupid= g.groupid WHERE g.groupname='WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212')
SET @SQL = 'ALTER DATABASE [WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5] ADD FILE (

NAME= "WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212",

FILENAME = "'+@DBFilePath+'WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212.ndf")

TO FILEGROUP [WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212]'

print @sql

exec (@sql)

http://www.edunnewijk.nl/fatshark/index.php?/archives/418-Site-Web-Analytics-reports-and-Site-Collection-Web-Analytics-reports-show-no-datanot-updatingbreaks.html