0

I'm receiving this error on our SharePoint server in event viewer.

When I check the Configure usage and health data collection I see WSS_Logging_fd8d31dd9b964a649407b44127593673 as the database name. When I check the database the DB is listed as WSS_Logging with no GUID attached to it.

If I try to Enable usage data collection, or make any changes at all, I receive the error:

A Usage Application already exists in this farm

The service app does exist in the Manage Service Applications page.

I'm thinking this may have become corrupt. Is there any downsides or repercussions to recreating this service?

  • Run powershell Get-SPServiceApplication and check if you have multiple Usage Service Applications. – Amal Hashim Dec 29 '14 at 22:47
  • There is only one – MickB Dec 29 '14 at 22:50
  • Then I would suggest deleting that and recreating a new one. You can use Powershell to specify the database name. – Amal Hashim Dec 29 '14 at 23:06
  • Amal's suggestion ended up being the route I took, if you post an answer I will mark it. – MickB Mar 17 '16 at 15:23
  • MickB, I have converted my comments to answer. – Amal Hashim Mar 17 '16 at 15:54
0

Run powershell Get-SPServiceApplication and check if you have multiple Usage Service Applications.

Then I would suggest deleting that and recreating a new one.

0

Please check the account running the SharePoint tracing service, add it into the "Performance Log Users" group, and give it read/write permissions on the 15/Logs folder , then restart the SharePoint tracing serice.

0

Did you try to change the database used by your Usage service application ?

Set-SPUsageApplication -DatabaseServer <DatabaseServerName> -DatabaseName <DatabaseName>

You can try this as a farm's administrator and SPShellAdmin :

Set-SPUsageApplication -DatabaseServer <DatabaseServerName> -DatabaseName WSS_Logging

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.