All State Service databases are paused for a State Service Application (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010

Rule Name:   All State Service databases are paused for a State Service Application

Summary:   All of the databases associated with a State Service service application are paused. This may result in errors when using some Microsoft SharePoint Server 2010 components such as InfoPath Web browser forms and the Microsoft SharePoint Chart Web Part.

Cause:   This might be caused by the administrator pausing all databases for the service application.

Resolution:   Resume the State Service service application databases by using Windows PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. To identify the paused database, type the following command at the Windows PowerShell command prompt:

    Get-SPStateServiceDatabase
    
  6. If you want to resume a paused database, type the following command at the Windows PowerShell command prompt:

    Resume-SPStateServiceDatabase -Identity <DatabaseID>
    

    Where:

    • <DatabaseID> is the identifier for the State Service service application database as a GUID.
  7. If you want to create a new database instead of using an existing database, type the following command at the Windows PowerShell command prompt:

    New-SPStateServiceDatabase -Name <DatabaseName> -ServiceApplication <ID> -DatabaseServer <ServerName> [-DatabaseCredentials <Credential>] 
    

    Where:

    • <DatabaseName> is name of the database as a string.

    • <ID> is the identifier for the affected State Service service application as a string or a GUID. If there is only one State Service service application, you do not have to specify this parameter.

    • <ServerName> is name of the database server.

    • <Credential> is SQL Server authentication credentials for the database server. If this parameter is not specified, Windows authentication will be used.

For more information, see Resume-SPStateServiceDatabase or New-SPStateServiceDatabase.