Web Services

Re: .xsf file has invalid mapping from the document to the submit web service

Hilary Stoupa — Tue, 07 Aug 2012 21:08:14 GMT

Hey - sorry no one was able to help you before you figured this out yourself, but thanks so much for posting the results here.

Re: .xsf file has invalid mapping from the document to the submit web service

pamjustice — Tue, 07 Aug 2012 20:59:45 GMT

My issue was not the comment field at all. It was the fact that there were columns with NULL values in the SQL row I was testing on. InfoPath doesn't like dealing with NULL columns in the form. I tested the comment field on a record that had all other columns set to some value other than NULL and the update worked fine.

.xsf file has invalid mapping from the document to the submit web service

pamjustice — Tue, 07 Aug 2012 17:45:56 GMT

I have created a form that submits to a SQL endpoint web service and all went well until I added a comment column to my SQL table defined as Stncomment nvarchar(255). After adding this column I can no longer submit and save a record back to SQL through the web service. I have tried resetting the data connection in InfoPath (2007) and even tried deleting and recreating the entire form with the new SQL data connection that includes the comment column but it still will not work and I get the same error message. The form is an InfoPath 2007 filler (not a web form). I am not using any managed code. All processing is done through the web service and SQL (2008) stored procedures. Can you help me find out what the problem is? I am new to using web services and SOAP. I don't know how to find out what the SOAP return messages are.

Thanks in advance

Pam J.