SharePoint 2007 workflows missing after migrating to SharePoint 2010

SharePoint 2007 workflows missing after migrating to SharePoint 2010.

Advertisements

SharePoint 2010 -Error in InfoPath web browser form: “An error occurred querying a data source.”

SharePoint 2010 -Error in InfoPath web browser form: “An error occurred querying a data source.”

On the Web Application are some browser enabled InfoPath forms. Some of them consume a SharePoint Web Service to query user information. After switching the Web App to HTTPS there was an Error while loading the form in browser.

First error message: “An error occurred querying a data source.”

Second error message: “You do not have permissions to access a Web service that provides data required for this form to function correctly.”

Cause: we are using SSL certificates for SharePoint 2010 web applications and we need to import the certificate into SharePoint trusted root certify ate store in order to InfoPath service to work.

$cert = Get-childItem "cert:\LocalMachine\CA\9A68CD6434D370CA40AA6CF443D86B46D2D3B485"
new-SPTrustedRootAuthority -Certificate $cert -Name "Sempra Energy Utilities Root Authority"

One last note – the ‘Get-childItem’ cmdlet can be used to walk the cert store as follows:
Get-childitem “cert:\*”
Get-childitem “cert:\LocalMachine\ *”
Get-childitem “cert:\LocalMachine\CA\*”
Resource: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/55471ccb-3efe-48e0-b6e7-007f64bbac04
http://ikarstein.wordpress.com/2011/07/01/869/
http://practicalsharepoint.blogspot.com/2012/06/info-path-forms-using-sharepoint-web.html