Monday, July 14, 2014

SharePoint error: This service instance 'Microsoft SharePoint Foundation Usage' cannot be provisioned on server 'WFE1' because it is mapped to server 'WEF2'.


While working with Configure web analytics and health data collection
,got an error saying that “This service instance 'Microsoft SharePoint Foundation Usage' cannot be provisioned on server 'WFE1' because it is mapped to server 'WEF2'.




ULS Logs : Microsoft.SharePoint.SPException: This service instance 'Microsoft SharePoint Foundation Usage' cannot be provisioned on server 'WFE1' because it is mapped to server 'WFE2"

Troubleshooting steps:
1) Stop All web analytical Services in all servers
2) Went to Manage Services on the Server, switched the view to WFE1 and WFE2, noticed the services were Stopped. I started them so now they are running on all server in Farm  but no luck
3)     Next actions would be  Deleted both services (Usage and Health Data Collection Service  and Web Analytics Service Application) and recreated.
4) Started services again but no results
 5) After long research and found another way to achieve this issue.
6) Stop web analytics service in all Servers using services.msc
7) Restarted the service again
8) Checked all Sharepoint services are running or not on a farm using stsadm -o enumservices
9) Observed Microsoft.SharePoint.Administration.SPUsageService Provision service was disabled in one of the WFE server()
10) Start service using  below command
11) stsadm -o provisionservice -action start -servicetype Microsoft.SharePoint.Administration.SPUsageService
12) Again stop all services in both services as well application server
13) Recreate services (Web Analytics Service Application) and configured
14) After that ,Configured events in usage and health data collection
15) Started Web Analytics Web Service  services in all the servers using  CA .
16) After that web analytics reports has been working in all prod Sites.