Strange error on query

[wjasonstrutz]

I have an Infopath form designed from an SQL server data source. The purpose
of the form is to track trainings of instructors who use classroom A/V
equipment at a university. The data source includes tables for Instructor
(contact information mostly), and related to that are tables for Trainings,
Code Requests, Classes, and Events. An instructor is looked up by their
login or last name (enter the login or last name and press the Lookup button).

In some specific instances, querying the data source results in the
following error:

name: "Error"
number: -2147209166
description: "The query method on the Document object failed.

InfoPath cannot run the specified query.
The file is not a valid XML document.

A name was started with an invalid character.

Line 330, Position 3
</>
--^
"

I've checked all the extracted form files, and cannot find any instance of
"</>" anywhere.

And here's the really strange thing. There is one particular instructor,
that has 3 trainings, 17 code requests, 17 classes, and 0 events. When
looking up this instructor, Infopath generates the above error. If I add or
remove a single training, code request, class, or event, however, the lookup
succeeds!

Can anyone suggest what might be causing this, or at least provide a hint of
how to view the XML source that's creating the offence?

Thanks,
jason.

 

[SkydiveOne]

The error makes me think either something is inserting a / into the
user name, you didn't mention any additional scripts, so I would look
through the data source you're pulling from or the method you're
pulling the data from. The other thing I would do is search for "/"
(yes it's going to be a pain) and look for any strange occurances of /
throughout the xml form. Are you able to save any of the forms that
are causing the error? If so that's where I would look for strange
occurances of / since they're the ones coming up with a problem. That
won't fix the problem but hopefully it will lead to it.

-Kevin