Submit Button error - Data Connection failing

bhben — Wed, 30 Jan 2013 10:18:40 GMT

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 (check out functionality in SharePoint library is not forced).

On searching foums for causes to the problem I have read about the use of friendly URL's/server name's (http://www.infopathdev.com/forums/t/14470.aspx) and I am using the correct server name. I am using http://servername instead of http://intranet - in a few other forms i created, this has solved the problem.

Looking closely at the rules on my submit button, the following actions should happen:

1st rule checks the selection of certain fields, if conditions are right it will set the values of 3 different fields.

The 2nd rule will save to SharePoint using a data connection (please note this data connection works fine on a different submit button). The 2nd rule will also close the form.

To test where the error occurs I added a series of display messages, and the problem is definitely on the save data connection.

The data connection is to save to a sharepoint form library, using a field called "filename" as the file name. The data connection allows overwrite's. The filename is set the first time a form is saved (it has a condition which checks a field which gets set upon any save event - if this field is 0 filename gets set, the first time the form is saved, this field becomes 1 so the filename field is never set again).

I have 2 views on the form, one named phase 1, the other named phase 2. When a 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've exhausted all avenues that I know of to find the cause of error message but am now at a loss, please help! (I am using InfoPath 2010, SharePoint 2010, Windows 7).

In Windows XP for a different user, a slightly different error message appears, and the form does actually save (fields get updated):

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.

Regards,

Ben

General

Submit Button error - Data Connection failing