I am the form designer and am currently testing a new form I have created, however there is an error with my submit button which Saves the form to SharePoint, I receive the following error message:
InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The form cannot be submitted to the following location: http://servername/siteA/siteB/siteC/FormLibrary/FormName.xml
The file: http://servername/siteA/siteB/siteC/FormLibrary/FormName.xml" is checked out for editing by DOMAIN\MyUserName.
The operation completed successfully.
The form is not checked out to me, or open by anybody else, also check out functionality is not forced on this SharePoint library.
On searching forums I have read about using friendly server names and I am using the server's name in the URL, i.e. http://servername instead of the alias http://intranet - this had solved the problem in other forms, but not this one.
Looking closely at the rules on my submit button, the following actions occur:
- 1st rule checks the selection of certain fields, if the conditions are right it will set the values of 3 different fields.
- The 2nd rule saves to SharePoint using a data connection (please note this data connection works fine on different submit buttons in different views). The second rule also closes the form.
To test where the error occurs I added a series of actions to display messages, and the problem is definitely on the data connection rule.
The data connection is to save to a Sharepoint library, using a field called "filename" as the file name. The data connection allows overwrites. The file name is set the first time a file is saved (it has a condition which checks a field which gets set upon any save event - if this field is set to 0 filename gets set and this field gets set to 1 - because this field is now equal to 1, the filename field will nwever get set again).
I have 2 views on the form, one named phase 1, the other named phase 2. When the custom submit button is pressed on the phase 1 view, my data connection works, but on the save 2 view, the exact same data connection fails with the error message above.
I am using Windows 7, InfoPath 2010, SharePoint 2010, InfoPath filler form).
In Windows XP, for a different user, the error messaeg is a little different, and the form does actually save:
InfoPath cannot submit the form
An error occurred while the form was being submitted
The form cannot be submitted to the following location: http://servername/siteA/siteB/siteC/FormLibrary/FormName.xml
The file is in use by another application or user.
As I said the form does actually save its changes but still throws up this error message which will be very confusing to end users.
I've exhausted all avenues that I know of to find the cause of the error messages and I'm at a loss, please help!
Thanks,
Ben