SharePoint 2010 Web Analytics ‘No Data Available’

I am running into an issue with Web Analytics.

I have a WFE (domain name and IP point to this) and an App Server (Central Admin, reporting Services, etc). When I would go to ‘…_layouts/WebAnalytics/Report.aspx’ and look at top users or pages I would get the no data available message. But when I would look at storage or Site Count I see data.

I came across this:

Its recommended when using a multiple server farm to start these service on multiple servers.

I went to Manage Services on the Server, switched the view to my WFE, noticed the services were Stopped. I started them so now they are running on all server in my Farm. We only had the services running on the App Server. I had a large consulting firm assisting on the installation and trusted the installation scripts they provided took this into account.

I think this is the fix. I’ll update this post tomorrow.

…

update 10/28/11

No Luck. I put a call into MSDN support. I think my eyes are getting crosses trying to figure this out. I know it’s going to end up being a stupid check box or a permission thing. I’ll update this when I get this fixed.

—-

update 11/10/2011

Still, no luck! I have been working with MS Support on this issue and tried have things from deleting/recreating the service and changing the service account and permissions on the SQL DBs. I have to say, I am very confused. I’ll be talking to MS Support later today and will provide another update with my findings.

On the positive side they have been able to replicate the issue. (makes me feel better knowing this is not ‘just me’)

Side note…
MS Support has been very helpful though this process. Actually, I have had a great experience with them every time I have needed to use them. I have had a couple issues over the past 12 months that have popped up and required me to use a support ticket from my MSDN or Select/EA. Knowing I would be routed to India, I was a little hesitant at first. Accents, language barriers, phone signal delays, all can make communications a challenge.  I am more than happy to say I have been extremely satisfied with the reps who assigned to my cases and their assistance working through the various issues. I can’t say the same about Office 365 Support, but that will be a post for another day.

update 11/10/2011 (b)

Just to make sure I had this working in the first place, I took a look at my Dev farms. They are a one server farm (not Standalone) connected to a SQL server. And, even though I haven’t used them since the first few days after installation, I see data, charts, usage; everything I am supposed to see. I am even more confused, but it’s good to know I do know how to set it up. Also, I guess this tells me there is something missing for my multi-server farms.

————————–

update 11/22/11

No news yet. MS Support is still working the ticket.

—————————

update 12/19/2011

The holidays are here, and it’s making it a challenge to coordinate with Microsoft. Still no resolution. MS Support and I have been playing phone tag.

Stay tuned.

—————————

update 01/05/2012

Nothing new. I have been esclated to the next level of MS Support, but still no progress.

Stay tuned (I know I am!)

————————————————————————–

Using Web Analytics

by Leon Lennaerts

original link http://www.lennaerts.com/?p=26

When you want to run a Web Analytics report you will receive
the following error:

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; (2) There is insufficient data to generate this report; (3) Data logging required for this report might not be enabled; (4) Data aggregation might not be enabled at the level required for this report.

In order to view a report you will have to install the Web Analytics Service Application. The next steps will describe how to install the Web Analytics Service Application in a multiple server farm (with 2 farms). The Web Analytics Service Application will be installed on the backend farm.

1. Go to the Central Administration à Application Management à Manage Service Applications
2. Click within the Ribbon on New à Web Analytics Service Application
3. Provide a name for the Service Application and create a new app pool or use an existing (I recommend to use one Application pool for several Service Applications)
4. Provide a unique name for the Web Analytics, Staging and Reporting Database
5. After you have created the Service Application you will have to start two services for populating the data. Go to Central
   Administration -> Application Management -> Manage service on server . Start the following two services:

• Web Analytics Data Processing Service
• Web Analytics Web Service

Its recommended when using a multiple server farm to start these service on multiple servers.

After you have performed these steps you can use the Web Analytics reporting. It can take one day before you can view any results. This because the data has to be populated.