SharePoint 2013: A State Service Application Has No Database Defined

Description

After configuring the State Service Application, Central Administration, Monitoring, Health Analyzer, Review Problems and Solutions shows an error; "A State Service Application has no database defined" even though a database does exist.

Solution

I've seen this problem occur when the the State Service Application was configured while logged into the server with an account different from the Farm Account.

1.  Log into the SharePoint Server using the Farm Account.
2.  In Central Administration, Application Management, Service Applications, Manage Service Applications, delete the State Service Application Proxy.
3.  Delete the State Service Application.
4.  Use PowerShell to find the Identity of the State Service Database you would like to remove; Get-SPStateServiceDatabase (Microsoft TechNet, 2012).
5.  Using PowerShell, remove the State Service Application Database; Remove-SPStateServiceDatabase -Identity 00000000-0000-0000-0000-000000000000, replace the zeros with the ID of the State Service Database retrieved from the prior cmdlet.
6.  Using PowerShell, create a new State Service Application.


References

Bisciotti, N. (November, 2012).  SharePoint 2013: How to Configure State Service Application using PowerShell. Retrieved June, 6, 2014 from http://njbblog.blogspot.com/2012/11/sharepoint-2013-how-to-configure-state.html

Microsoft TechNet (July, 2012).  Get-SPStateServiceDatabase.  Retrieved June 6, 2014, from http://technet.microsoft.com/en-us/library/ff608133(v=office.15).aspx

SharePoint 4.0: Content Type Hub Synchronization Steps (Publish/Subscribe)

Description

In a SharePoint Server 2010 environment, custom content types have been created on a Content Type Syndication Hub site collection (Content Type Publisher).  However, the Content Type Subscriber site collection does not contain published content types in its Site Content Types Gallery.

Assumptions

The following configurations have already been verified:

1) The service account permissions are correct
2) The Managed Metadata Service Application is configured properly
3) The Managed Metadata Service Connection is configured properly and the setting for "This service application is the default storage location for Keywords" is checked off.
4) The Subscriber site collection has the following Site Collection Features enabled: 

SharePoint Server Publishing Infrastructure5) The Publisher site collection has the following Site Collection Features enabled: 

SharePoint Server Publishing Infrastructure, Content Type Syndication Hub

Solution

The following steps may be required to synchronize the content types between the publisher and the subscriber.

1) Publish the Content Types

• Content Type Hub Publisher site collection > Site Actions > Site Settings > Galleries > Site Content Types
• Click on Content Type
• Click on "Manage publishing for this content type"
• Click OK

• Repeat this step for all content types that requiring publishing

2) Run the Timer Jobs

• Central Administration > Monitoring > Timer Jobs > Review Timer Job Definitions

2a) Run the Content Type Hub Timer Job

• Set the View to "All"

• Click on the Timer Job, "Content Type Hub" Timer Job
• Click "Run Now"

2b)  Run the Content Type Subscriber Timer Job

• Set the View to "Web Application"
• Select the Web Application that contains the subscriber site collection
• Click on the Timer Job, "Content Type Subscriber"
• Click "Run Now" 

3) Verify

• Content Type Hub Subscriber site collection > Site Actions > Site Settings > Galleries > Site Content Types
• Verify that the subscriber has received the published content type from the Content Type Hub 

Reference

Microsoft TechNet (May, 2010). Content type and workflow planning (SharePoint Server 2010). Retrieved May 26, 2011 from http://technet.microsoft.com/en-us/library/cc262735.aspx.

Share-n-dipity (October, 2009). Publish and Subscribe to Content Types in SharePoint 2010. Retrieved May 26, 2011 from http://blogs.technet.com/b/speschka/archive/2009/10/30/publish-and-subscribe-to-content-types-in-sharepoint-2010.aspx