Trying to view the Web Analytics Reports in Sharepoint Central Admin 2010 get: An unexpected error has occurred.

Question

on the error screen we get: 

Correlation ID: 6b381eee-d7c4-4306-a8cb-08bc800e2a48

Date and Time: 7/27/2012 9:13:43 AM

I've checked the log file against this specific time and have the following logged:

 

07/27/2012 08:50:53.56 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Monitoring                     nasq Medium   Entering monitored scope (Request (GET:http://srv-moss2010:4000/_layouts/WebAnalytics/WebAppSelection.aspx?t=WebApplicationSelectionReport&l=wa))
07/27/2012 08:50:53.56 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Logging Correlation Data       xmnv Medium   Name=Request (GET:http://srv-moss2010:4000/_layouts/WebAnalytics/WebAppSelection.aspx?t=WebApplicationSelectionReport&l=wa) 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.56 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Logging Correlation Data       xmnv Medium   Site=/ 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.59 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Topology                       e5mc Medium   WcfSendRequest: RemoteAddress: 'http://srv-moss2010:32843/3362200682dc429184f7be092c6e10d1/WebAnalyticsService.svc' Channel: 'Microsoft.Office.Server.WebAnalytics.Administration.IWebAnalyticsWebServiceApplication' Action: 'http://tempuri.org/IWebAnalyticsWebServiceApplication/GetData' MessageId: 'urn:uuid:4e028631-35a5-49db-a834-48058d310290' 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.60 w3wp.exe (0x1C80)                       0x258C SharePoint Foundation         Topology                       e5mb Medium   WcfReceiveRequest: LocalAddress: 'http://srv-moss2010.notley.local:32843/3362200682dc429184f7be092c6e10d1/WebAnalyticsService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://tempuri.org/IWebAnalyticsWebServiceApplication/GetData' MessageId: 'urn:uuid:4e028631-35a5-49db-a834-48058d310290' 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.60 w3wp.exe (0x1C80)                       0x258C SharePoint Foundation         Monitoring                     nasq Medium   Entering monitored scope (ExecuteWcfServerOperation) 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.60 w3wp.exe (0x1C80)                       0x258C Web Analytics Services         Administration                 c253 Unexpected GetData suppressed DataRetrieverFailure: Invalid query parameters. Could not find a matching warehouse subscription for the query. 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.60 w3wp.exe (0x1C80)                       0x258C SharePoint Foundation         Monitoring                     b4ly Medium   Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=1.08400648685797 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.61 w3wp.exe (0x2438)                       0x2BD8 Web Analytics Services         Administration                 c25g Unexpected Failed to get data. Exception: System.ServiceModel.FaultException`1[Microsoft.Office.Server.WebAnalytics.ProcessedDataRetriever.DataRetrieverFailure]: The creator of this fault did not specify a Reason. (Fault Detail is equal to Microsoft.Office.Server.WebAnalytics.ProcessedDataRetriever.DataRetrieverFailure). 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.61 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Runtime                       tkau Unexpected System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.Office.Server.WebAnalytics.Reporting.WebApplicationSelectionReport.GetDataPacket(AggregationContext context, DateTime date, Dictionary`2 parameters, Boolean bypassCache)     at Microsoft.Office.Server.WebAnalytics.Reporting.ReportViewWebPart.SetConnectionInterface(Dictionary`2 inputParameters)     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Control.LoadRecursive()     at System.Web.UI.Page.ProcessRequestMain... 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.61* w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Runtime                       tkau Unexpected ...(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 1d08412e-ffc0-449d-8108-c3b3be896a8c
07/27/2012 08:50:53.61 w3wp.exe (0x2438)                       0x2BD8 SharePoint Foundation         Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (GET:http://srv-moss2010:4000/_layouts/WebAnalytics/WebAppSelection.aspx?t=WebApplicationSelectionReport&l=wa)). Execution Time=55.9441213897297 1d08412e-ffc0-449d-8108-c3b3be896a8c

When checking in: Configure Usage and Health within the Monitoring section I can confirm that Enable usage data collection is enabled and all events selected.  The build version obtained from Programs and Features is: 14.0.6029.1000

Any suggestions on this?

Regards

Answer 1

I would go back to the Configure Usage and Health Data Collection screen in Central Admin and select the Log Collection Schedule link.  This should take you to two specific timer jobs; Please verify they are both enabled and running.  Also, you may want to verify the Web Analytics Data Processing Service is started by browsing to Services on Server.

---

-Chopps

Answer 2

Hi, 

thanks for the reply, I can confirm that all of the timer jobs seem to be succeeding and also that the Web Analytics Data Processing Service is running too.

Al 

Answer 3

Can you query the WASetting table in the Web Analytics Reporting database to see the last copy and aggregation?

SELECT * FROM [<WebAnalyticsReportingDatabase>].[dbo].[WASetting]

Answer 4

Hi,

This is the info:

SettingName SettingValue

LastFloatingClickthroughBatchId  5069

LastFloatingQueryBatchId 4825

LastLoggingExtractionTime 2012-07-30T16:20:07.757

Answer 5

What about LastDataCopyTime in Reporting database WASetting table?

Answer 6

Those were the only fields reported back.  Something that has been spotted on this setup is that the reporting database and staging database are the same so I'm going to get the web application setup again using different databases.

thanks