I have a drop down list that uses a secondary data connection (SQL DB) to provide "customer names" for my infopath form user. If they select a simple name like "AAA Signs" the form submits to SPList with no error. If they select a customer name with the character "&" in the name (i.e. "Father & Son Plumbing") it throughs this error.
An unexpected error occurred executing the rule. Action: SubmitToSharePointList
Arguments:
submit: ShPSubmit
mapping: mapping
id: my:IDN
Details: An error occurred while parsing EntityName. Line 1, position 409.
Stack: at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.Throw(String res)
at System.Xml.XmlTextReaderImpl.ParseEntityName()
at System.Xml.XmlTextReaderImpl.ParseEntityReference()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.ParsePartialContent(XmlNode parentNode, String innerxmltext, XmlNodeType nt)
at System.Xml.XmlLoader.LoadInnerXmlElement(XmlElement node, String innerxmltext)
at System.Xml.XmlElement.set_InnerXml(String value)
at Qdabra.GenerateBatch.GenerateBatchElement(List`1 docs, XmlDocument mapping, String qRulesListId)
at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList(String submitDs, String mappingDs, String id)
at Qdabra.Tools.RulesLibrary.Commands.SubmitToSharePointList()
at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()
What could this be? Have I configured something wrong?