Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

Published: July 16, 2012

Summary: Learn how to resolve the SharePoint Health Analyzer rule "All State Service databases are paused for a State Service Application."

Applies to:  SharePoint Foundation 2013 | SharePoint Server 2013 

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 SharePoint 2013 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 have the following memberships:

    • securityadmin fixed server role on the SQL Server instance.

    • db_owner fixed database role on all databases that are to be updated.

    • Administrators group on the server on which you are running the Windows PowerShell cmdlets.

    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 Products cmdlets.

    note Note:

    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about Windows PowerShell permissions, see Add-SPShellAdmin.

  2. Start the SharePoint 2013 Management Shell.

    • For Windows Server 2008 R2:

      • On the Start menu, click All Programs, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Management Shell.

    • For Windows Server 2012:

      • On the Start screen, click SharePoint 2013 Management Shell.

        If SharePoint 2013 Management Shell is not on the Start screen:

      • Right-click Computer, click All apps, and then click SharePoint 2013 Management Shell.

    For more information about how to interact with Windows Server 2012, see Common Management Tasks and Navigation in Windows Server 2012.

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

    Get-SPStateServiceDatabase
    
  4. 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.

  5. 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.