Setting up the Aurion connector, sending as the query ID the query name and the XML_FILE_PATH. The import all fails with errorChange detection engine import all items for connector Test failed with reason Expecting '?', '*', or '+'. Line 4, position 77.. Duration: 00:02:02.5742785
in the log we get:
entities from connector failed.
Import all entities from connector AurionUser failed with reason Expecting '?', '*', or '+'. Line 4, position 77.. Duration: 00:02:00.8921187
System.Xml.XmlException: Expecting '?', '*', or '+'. Line 4, position 77.
That suggests to me that there is a problem with the XML, but since we are using the XML_FILE_PATH just referring to the xml file name and the query is just writing to the file with no directory, there is no physical file to look at (this is how the Aurion guys have configured it). They did export me a file to a directory. Line 4 is:
<!ELEMENT AQT_Output (First_Name, ... Preferred_Name_+_Surname, ...)>
and position 77 is just after the + in the middle of a composite full name field.
I can see no reason why "+" would cause issues as it is not one of the 5 XML reserved characters(<,>,&,",'), but I am asking the Aurion consultant to remove that field from the query.
Any ideas why it would be an issue?
Customer support service by UserEcho