InfoPath Dev

Hello everyone and happy holiday weekend!

I'm trying to figure out an issue.  This if our first browser-based InfoPath form with SharePoint 2010.   With that said, it is entirely possible that we just don't have something setup correctly.

I've attached a copy of the form and the errors that we are seeing.  Basically we cannot get our qrules data connections to post data back to the SharePoint list when the forms are browser-based.  When the forms are submitted in the InfoPath Filler they submit successfully.  Since 90% of our users are still on InfoPath 2003, we are not able to have them fill out the form in InfoPath.

 Here are the errors from the SharePoint log:

05/28/2011 11:52:49.09  w3wp.exe (0x2060)                        0x1294 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (POST:https://mysite.com:443/sites/hr/_layouts/Postback.FormServer.aspx) 5f6e7f24-954b-4e46-894d-4441f120cbd5
05/28/2011 11:52:51.86  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (Request (POST:https://mysite.com:443/sites/hr/_vti_bin/Lists.asmx)) 
05/28/2011 11:52:51.86  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Request (POST:https://mysite.com:443/sites/hr/_vti_bin/Lists.asmx) 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.88  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          General                        fbv5 Medium   SoapAction: "http://schemas.microsoft.com/sharepoint/soap/CheckOutFile" 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.88  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          General                        fbv6 Medium   <?xml version="1.0" encoding="utf-8"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:CheckOutFile xmlns:tns="https://mysite.com/sites/hr/Shared/2011%20Development%20plan-test.docfalsehttp://schemas.microsoft.com/sharepoint/soap/"><tns:pageUrl>https://mysite.com/sites/hr/Shared/2011%20Development%20plan-test.doc</tns:pageUrl><tns:checkoutToLocal>false</tns:checkoutToLocal><tns:lastmodified></tns:lastmodified></tns:CheckOutFile></SOAP-ENV:Body></SOAP-ENV:Envelope>    7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.88  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          General                        8e2s Medium   Unknown SPRequest error occurred. More information: 0x80070005 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.89  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          General                        avfx High     SOAP exception: System.Threading.ThreadAbortException: Thread was being aborted.     at System.Threading.Thread.AbortInternal()     at System.Threading.Thread.Abort(Object stateInfo)     at System.Web.HttpResponse.End()     at Microsoft.SharePoint.Utilities.SPUtilityInternal.SendResponse(HttpContext context, Int32 code, String strBody)     at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(HttpContext context)     at Microsoft.SharePoint.Utilities.SPUtility.HandleAccessDenied(Exception ex)     at Microsoft.SharePoint.Library.SPRequest.GetFileAndFolderProperties(String bstrUrl, String bstrStartUrl, ListDocsFlags ListDocsFlags, Boolean bThrowException, Int32& phrStatus, Object& pvarFiles, Object& pvarDirs, UInt32& pdwNumberOfFiles, UInt32& pdwNumberOfDirs)     at Microsoft.ShareP... 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.89* w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          General                        avfx High     ...oint.SPWeb.GetFileOrFolderProperties(String strUrl, ListDocsFlags listDocsFlags, Boolean throwException, SPBasePermissions& permMask)     at Microsoft.SharePoint.SPFile.PropertiesCore(Boolean throwException)     at Microsoft.SharePoint.SPFile.get_CheckOutType()     at Microsoft.SharePoint.SoapServer.ListDataImpl.CheckOutFile(String pageUrl, String checkoutToLocal, String lastmodified)     at Microsoft.SharePoint.SoapServer.ListDataValidatorImpl.CheckOutFile(String pageUrl, String checkoutToLocal, String lastmodified)     at Microsoft.SharePoint.SoapServer.Lists.CheckOutFile(String pageUrl, String checkoutToLocal, String lastmodified) 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.89  w3wp.exe (0x2060)                        0x23F8 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (POST:https://mysite.com:443/sites/hr/_vti_bin/Lists.asmx)). Execution Time=29.6050564988107 7e3795ea-040e-40e2-84f4-83ec3c32cf1e
05/28/2011 11:52:51.93  w3wp.exe (0x2060)                        0x1294 InfoPath Forms Services        Runtime - Data Connections     eq8l Warning  The following query failed: CheckOutFile (User: 0#.w|corporate\simpsonc, Form Name: SDTP14, IP: , Connection Target: , Request: https://mysite.com/sites/hr/_layouts/FormServer.aspx?XsnLocation=https://mysite.com/sites/hr/FormServerTemplates/SDTP14.xsn&SaveLocation=https://mysite.com/sites/hr/SDTP&Source=https://mysite.com/sites/hr/SDTP/Forms/MyItems.aspx&DefaultItemOpen=1, Form ID: urn:schemas-microsoft-com:office:infopath:SDTP14:-myXSD-2011-05-22T00-30-20 Type: DataAdapterException, Exception Message: The remote server returned an error: (403) Forbidden. The remote server returned an error: (403) Forbidden.) 5f6e7f24-954b-4e46-894d-4441f120cbd5
05/28/2011 11:52:52.05  w3wp.exe (0x2060)                        0x1294 SharePoint Server              State Service                  8kfs Medium   The StateManager is disposing and calling ReleaseLockedStates() (Count=0) 5f6e7f24-954b-4e46-894d-4441f120cbd5
05/28/2011 11:52:52.05  w3wp.exe (0x2060)                        0x1294 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (POST:https://mysite.com:443/sites/hr/_layouts/Postback.FormServer.aspx)). Execution Time=2959.6388379382 5f6e7f24-954b-4e46-894d-4441f120cbd5

 Any help is appreciated.  Thank you

First thing I noticed is that your data connections have not been converted to UDCx files. In Designer, click Data Connections and go through and convert these to UDCs. You'll have to create a Data Connections library on SharePoint to store them and make sure you approve them after you convert them. Try that and you should get further. The other thing you will need is to make sure your 2010 site has the InfoPath Sandbox enabled. This is in the Admin options for the Site Collection. If you are running MOSS 2007, you will have to Admin Approve when you publish, but in 2010 it's a lot easier (since the sandbox will enable it automatically).

We should have documents on all of this. Please search around the qRules documentation area. Downloads->qRules (under Tools on right).

Best of luck!

Patrick

Awesome information.  I created a data connection library and then I converted the data connection in InfoPath that is supposed to submit the items from the form to the SharePoint list.  I went to the data connection library and I approved that item.  I then enabled sandboxed solutions in SharePoint Central Administration.  I then published the InfoPath template and uploaded it to Central Administration (replacing the earlier version of that template).

 I then crossed my fingers and when to the SharePoint site form library and filled out the form and then hit the button that should call that data connection to populate the SharePoint list.

:-(

Unfortunately, I got the same results as before:

Result:  <null>

Success: <null>

Error:  Failed to submit to SharePoint URL

I've attached an updated copy of the template just in case someone could look at it and give some advise.  Since this is our first browser-based form, it could be something with our SharePoint configuration.  I check the trust level in the web.config and it is set to minimal.  There has to be something that allows this to work correctly in the InfoPath Filler but not the browser.

If it's sandbox you don't need to do the admin deploy. The sandbox must be enabled for the URL where you are publishing though. Make sure that is the case and just try to publish as a form library.

Are you trying to use qRules SaveToSharePoint command (converting imanges and attachments to links) or are you trying to use SubmitToSharePointList? We have documents for both that describe the specific steps to browser enable - I'm assuming you have read these docs. If not, we should make sure you have those first.

More later,

Sandbox mode was successful.  I am able to publish directly to the form library and see an updated form when I attempt to fill out a new form.  The new issue is that when I do this the form now opens in InfoPath Filler and not in the browser.   The odd thing is that if I were to publish this form to the server and then add it to the library as a content type then it would open in the browser. 

  I'll attach a screen shot of the settings for browser based forms for confirmation.  I may have to reply a couple of times with each attachement as this Forum doesn't let me attach more than one.  I've read through both the qrules user guide and the SubmitToSharePointList guide.  I'll take another look at the latter in the meantime. 

Second attachment.

This attachment is of the publishing settings.  Publishing directly to the form library.

And lastly.  Attached is a screen shot of the Form Library settings, which should indicate that the form should be opened in the browser.

Okay ... the form is once again browser-based.  I found a posting in the forums from years ago where someone simply opened their form in design view, selected all, changed the font to something else, then changed the font back and republished and now the form is opening in a browser once again.

Now I was able to test the form and upon hitting the button with the action to set the Command field with a value of:  SubmitToSharePointList /submit=IntGroupSubmit /mapping=IntGroup

Nothing happens.

I even checked the postback settings to ensure that it was set to "always"

Result <null>

Success:  <null>

Error:  <null>

And you have tried other InfoPath web method calls? I continue to think this is not a qRules issue, but an issue with your environment -- after all, in this thread we tested using CheckOutFile in your enviro and it failed in a browser form.

Oh, and by the way, you should be at least getting Success = false, and an error if one was available. You'll want to make sure you have postback set to always on those controls as well.