Fixing the Usage and Health Data Collection Service Application Proxy

by Tristan Watkins

Unfortunately I’ve found a problem with our development build, or rather, with SharePoint 2010. You may notice that the Usage and Health Data Collection Proxy is Stopped after deploying it in your environment. This is not just a matter of starting the service like it is with some Service Applications. In this case the SA proxy itself appears to be stopped. It appears that this is a known problem when provisioning this Service Application via the GUI. In fact, ours was created automatically as part of the Search Service Application creation process. At any rate, it doesn’t work in its current state in our environments, so it won’t actually collect any data.

To fix this just requires a couple of lines of PowerShell, courtesy of this article (to which I’ve added some clarification here).

If you go to the Manage Service Applications link you’ll see the problem:

070810 1519 FixingtheUs1 Fixing the Usage and Health Data Collection Service Application Proxy

Open the SharePoint 2010 Management Shell and Run as Administrator.

070810 1519 FixingtheUs2 Fixing the Usage and Health Data Collection Service Application Proxy

Update, 10 January 2011
Tom suggested an improvement in the comments here, which I agree is better!

$sap = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”}
$sap.Provision()

Original approach

Run Get-SPServiceApplicationProxy to enumerate the IDs of all the Service Application Proxies in your farm.

070810 1519 FixingtheUs3 Fixing the Usage and Health Data Collection Service Application Proxy
(note: you will probably have more Service Application Proxies than these)

Copy the ID for the WSS_UsageApplication.

Run the following two lines of PowerShell.

$UP = Get-SPServiceApplicationProxy | where {$_.ID -eq "<PASTE COPIED ID HERE>"}
$UP.Provision()

070810 1519 FixingtheUs4 Fixing the Usage and Health Data Collection Service Application Proxy

If you refresh the Manage Service Application page the proxy should be started now.

070810 1519 FixingtheUs5 Fixing the Usage and Health Data Collection Service Application Proxy

Once that has been configured, the usage data will not appear immediately in all of the usage reports because the timer jobs to collect the data will not have run yet. The granularity of the data collection and processing is pretty fine if you want to reconfigure them for your needs, but keep in mind that none of the Web Analytics reports will appear for at least 24 hours after this fix is in place. They do not allow reporting on the current day. If you try to configure a Custom Date Range to include today’s date you will get the following message:

070810 1519 FixingtheUs6 Fixing the Usage and Health Data Collection Service Application Proxy

I’ll try to track this issue as updates come out.

Share:
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy
  • services sprite Fixing the Usage and Health Data Collection Service Application Proxy

12 Responses to “Fixing the Usage and Health Data Collection Service Application Proxy”

  1. Thanks, this was exactly what I needed.

    :-)

  2. An even simpler and quick method is to run the following commands, you don’t need to get the ID with this;

    $sap = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”}
    $sap.Provision()

  3. Great post! Ran into same issue…

  4. Hi /Tristan/Tom,

    Thanks! This worked perfectly for me.

    Regards
    Vishwas

  5. Excellent post. Helped a lot.

  6. Excellent Post. Worked like a charm.
    Thanks Tristan and Tom!!

    Vicky.

  7. Thanks for the post. This has made my day…. Great post

  8. Worked for me – thanks!

  9. Tristan – This worked great. Thank you for posting.!

  10. Trackbacks

Leave a Reply