Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Tuesday, February 19, 2013 3:58 AM
Hi folks,
We have a problem with state service during worklow or any infopath rendering time.
We have build the sharepoint farm with DB created datbases due to collation issue. It went well to bring the farm up and configured MMS and BCS service application.
I have created State Service application using a temporary sql 2008 express server using below powershell commands
Add-pssnapin Microsoft.sharepoint.powershell -EA 0$sa = New-SPstateserviceapplication -name "State Service App SIT"new-spstateservicedatabase -name "sps_StateServiceApp_SIT" -databaseserver "server\SP2010sqlexpress" -serviceapplication $sanew-spstateserviceapplicationproxy -name "State Service App SIT Proxy" -serviceapplication $sa -defaultproxygroup
It worked well for all workflows and infopath forms to render in browser.
Now we moved the state service database from temp server to actual server and ran dismount and mount commands
as described in this article http://technet.microsoft.com/en-us/library/ff851878(v=office.14).aspx#State
Also, Initalized state service. now. when we run a new workflow (ex: approval or publishing) or infopath forms then getting above error.
Can anyone have a workaround for smilar issue?
All replies (2)
Tuesday, February 19, 2013 5:55 AM âś…Answered
sharepoint collation Latin1_General_CI_AS_KS_WS
Also solved my problem.
when we run the Mount command as below and then Initialize command then went well.
Mount-SPStateServiceDatabase -Name StateService_DB
-DatabaseServer servername -ServiceApplication "state service"
Initialize-SPStateServiceDatabase
Earlier we missed to give service application name and it's failing to bind the respectice service application though mount-spstateservicedatabase command belongs to state service application
Tuesday, February 19, 2013 4:44 AM
What is the collation of the State Service database now?
SharePoint - Nauplius Applications
Microsoft SharePoint Server MVP
MCITP: SharePoint Administrator 2010
This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.