Home > PowerShell, SharePoint 2010, SharePoint Administration > Fixing Error: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

Fixing Error: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

Recently my SharePoint 2010 farm crashed.  Well just one server (index/CA Server), and then it was just the domino effect afterwards.  Luckily it was not the SQL Server so all my data files were still accessible/recoverable.  Since there were a lot of things going on behind the scenes of SharePoint with unexplained errors, and random things not working the decision to rebuild the farm was the direction I wanted to take to elevate majority of the problems.

So since I usually do everything via PowerShell, It was very simple to remove/add servers to the SharePoint farm and reconfigure, and since I already had all my data files (content dbs, service application dbs, search dbs, etc) It was very easy to get things back to a “stable” state.

Using PowerShell I reconfigured all the Service Applications over again pointing them back to their data files, however their are a few Service Applications that “bitch” about “used” databases.  One of those services is the Server State Service.  When I tried to reconfigure this Service Application via PowerShell it complained that the database was not empty, and it spit out that ugly red message we love to see when things go wrong.

However, I paid it no mind and told myself I would just configure it later since it’s not a show stopper.

Well today when a customer was trying to add a InfoPath Form Web Part onto their Site they were receiving this error:

“The form cannot be rendered.  This may be due to a misconfiguration of the Microsoft SharePoint Server State Service.  For more information, contact  your server administrator.”

Whoops…I forgot to go back and reconfigure Server State Service after rebuilding the farm.

The State Service is a shared service that is used by some Microsoft SharePoint Server 2010 components to store temporary data across related HTTP requests in a SQL Server database. In SharePoint Server 2010, the State Service is required by InfoPath Forms Services (including out of the box and custom workflow forms), the SharePoint Server 2010 Chart Web Part, and certain Microsoft Visio 2010 scenarios that do not use Microsoft Silverlight 3.

Now there are two ways to reconfigure the Server State Service.   You cannot configure it via Central Administration.

One way is to simply run the configuration wizard.  The second way is via PowerShell.

Since I like PowerShell I will use that, and plus running the wizard will interrupt SharePoint.

Below are the steps to follow to reconfigure the Server State Service.
For my case since I already had a database for Server State Service and I wanted to reuse that same DB name I had to delete the existing DB, or change its name on the SQL Server.   If this is the first time you are configuring Server State Service you don’t have to worry about the DB steps.

1. Open up SQL Server, find the ServerStateDB, right click and delete DB (this will prevent PS from laughing at you)
2.  Next open up SharePoint Administrator Shell (PowerShell) as Administrator
3.  Type: $serviceApp = New-SPStateServiceApplication -Name “State Service”
4.  Next:  New-SPStateServiceDatabase -Name “StateServiceDatabase” -ServiceApplication $serviceApp
5.  Then: New-SPStateServiceApplicationProxy -Name “State Service” -ServiceApplication $serviceApp -DefaultProxyGroup

This will provision the State Service Application.

Go back to the site where you were receiving the error:

“The form cannot be rendered.  This may be due to a misconfiguration of the Microsoft SharePoint Server State Service.  For more information, contact  your server administrator.”

The error should be gone, and the page or web part should render okay on the page.

Advertisements
  1. May 20, 2013 at 5:51 am

    Nice post. Here is one more post in same issue in sp2013
    http://sureshpydi.blogspot.in/2013/05/the-form-cannot-be-rendered-this-may-be.html

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: