A State Service Application has no database defined

During checking the Health analyzer in SharePoint 2013 Central Administration I found out below Configuration category the following error.

A State Service Application has no database defined.

state serveice not have database

Cause:

This problem might occur because of

  1. All databases associated with the State Service service application was deleted.
  2. All databases associated with the State Service service application was not created.

Solution:

  • Open Central administration as farm account.
  • Application Management > Service Application > Manage Service Application.
  • manage service application.PNGSelect State Service Application.
    state service application.PNG
  • Click Delete from the Ribbon.
    delete service application
  • Check Delete data associated with the service application.
    delete service application and all related
  • Repeat the previous steps to delete State Service Application Proxy.
  • Open SharePoint Management Shell as administrator.

Run SharePoint Management Shell as Administrator

  • Create a New State Service Application with its proxy by typing the following cmdlets one by one.

$serviceApp = New-SPStateServiceApplication -Name "State Service Application"
New-SPStateServiceDatabase -Name "SharePoint_Service_StateDB" -ServiceApplication $serviceApp
New-SPStateServiceApplicationProxy -Name "State Service Application Proxy" -ServiceApplication $serviceApp -DefaultProxyGroup

  • Go back to check the Health Analyzer issue list where the error should now be disappeared from it.

Enjoy 🙂

Advertisements

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