Dear All

I have an Eventlog Errormessage that I cannot resolve. The strange thing is, that I cannot found a problem with the excel service itself. Also it not appears during a crawl or another known scheduled tasks.

Our Environment is a full virtual SharePoint 2010 SP1 Enterprise Server with 2 Front End Servers and one SQL 2008 R2 Server.

Event ID: 5244
Source: Excel Services Application
User: Service User responsible for Application Pool for Excel Services

Message:
Unexpected error when trying to access service settings in the configuration database. Make sure the proxy for this service application is a member of the default proxy group for the active web application. Error = The SharePoint farm has not been provisioned properly..

Date Time this message last time occurs:
29.01.2013 - 05:22:32
29.01.2013 - 08:24:02
30.01.2013 - 05:42:42
30.01.2013 - 10:01:05
30.01.2013 - 19:56:05

I have found similar forum posts, but not one with the "Error = The SharePoint farm has not been provisioned properly.."
I already tried to run the SharePoint 2010 Products Configuration Wizard. This runs to the end without any problems.

Do you have any ideas how to resolve this?

Do you have any servers in the Farm that are actually running the Excel Services service (not the service application, but the "Services on server" page).

Hi Chris,

Do you mean the "Excel Calculation Services" on the "Services on Server" page? Yes this service is Status "Started" in the CA. But only on 1 of 2 Front End Servers.

Regards
r-f

Hi r-f,

Did you try the following article to Grant correct permissions to the database access account enough the error part is not same exactly?

http://technet.microsoft.com/en-us/library/ee513113(v=office.14).aspx

Best Regards.

Hi Kelly,

I did this configuration steps before, yes. The Excel Service Application User has already db_owner permissions on the Farm Configuration Database.

Thanks & Regards

I think you should stop the service on all the farm servers.  Remove the excel services app. Add it back, then start the service on one or both of your servers.

Warning:  this will remove all the settings in your Excel Services (if you set any) and you would need to put them back.

Chris

I think you should stop the service on all the farm servers.  Remove the excel services app. Add it back, then start the service on one or both of your servers.

Hi Chris, sorry for my late answer. We had other issues in the meantime.

I tried your solution but it not resolves the error in the eventlog. But we found out that we had another SQL Connection error and I will try to resolve that one and maybe come back to this error later.

Thanks & Regards

Hi All, I try to find out the cause for this problem.

In ULS Logs i found the following entries:

Area: Excel Services Application
Category: Excel Calculation Services
Level: Medium

ExcelServerSharedWebApplication.Local: An exception was thrown by configdb infrastructure: System.InvalidOperationException: The SharePoint farm has not been provisioned properly.     at Microsoft.Office.Excel.Server.MossHost.ExcelServerWebService.get_Local()     at Microsoft.Office.Excel.Server.MossHost.ExcelServerWebServiceApplication.get_Local(). Can't determine request Url.

***********

Area: Excel Services Application
Category: Administration
Level: Critical

Unexpected error when trying to access service settings in the configuration database. Make sure the proxy for this service application is a member of the default proxy group for the active web application. Error = The SharePoint farm has not been provisioned properly..

************

Thanks for your thoughts.

Any findings??

HI, I got the solution SharePoint Web Services Root application pool was stopped