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

  • Article

APPLIES TO: yes-img-132013 yes-img-162016 yes-img-192019 yes-img-seSubscription Edition no-img-sopSharePoint in Microsoft 365

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 Server 2016 and 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 Microsoft 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 PowerShell cmdlets.

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

    Note

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

  2. Start the SharePoint Management Shell.

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

  3. To identify the paused database, type the following command at the 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.