Friday, September 03, 2010 1:30 PM
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?
Friday, September 03, 2010 1:55 PM
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.
Friday, September 03, 2010 2:02 PM
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.
Friday, September 03, 2010 2:12 PMOpen 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.
Friday, September 03, 2010 2:18 PM
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"
Tuesday, September 07, 2010 9:05 AM
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?
Friday, September 10, 2010 6:31 AM
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.
Thursday, September 16, 2010 2:56 PM
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.
- Marked As Answer by dikkehaaj Thursday, September 16, 2010 2:56 PM
Thursday, September 30, 2010 1:49 PM
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
Wednesday, October 27, 2010 11:36 AM
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.
Thursday, October 28, 2010 1:25 PM
I have not got any solution yet. Problem is still there!!!
Thursday, October 28, 2010 7:19 PM
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.
Wednesday, November 03, 2010 3:02 PM
Sorry hadn't received an e-mail from this topic but this are the DBs and Procedures.
- Marked As Answer by dikkehaaj Wednesday, November 03, 2010 3:02 PM
Thursday, November 04, 2010 2:30 PM
Thank you for your response, I ran all stored procedures but still getting same problem with web analytics service. Any solution.........???
Thursday, November 04, 2010 7:41 PMRunning the stored procedures worked for me.
Did you also follow http://technet.microsoft.com/en-us/library/ff453926.aspx
Tuesday, November 09, 2010 1:16 PMI have followed every step on suggested URL (http://technet.microsoft.com/en-us/library/ff453926.aspx) but issue is still there.
Tuesday, November 16, 2010 10:55 AMTry to run (all) a couple of Stored Procedures.
Probaly data stuck in the Staging database.
Wednesday, November 17, 2010 2:17 PMStill not getting any Web Analytics Reports data.
Friday, August 10, 2012 1:43 PM
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'
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 (
FILENAME = "'+@DBFilePath+'WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212.ndf")
TO FILEGROUP [WebAnalyticsServiceApplication_ReportingDB_29ce45d5-af72-47c0-aabf-9c038c254ce5Aggregation20120212]'