PI 7.5 - INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.

[former_member201275]

Hi,

In our PI 7.5 system I am getting the error message '

Error for incoming message com.sap.aii.af.lib.mp.module.ModuleException: org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified'.

My scenario is a REST to RFC object and I assume that one of the columns or fields coming from the RFC function module has an invalid character however I don't know where to go to see this. If anyone can tell me where I can see the XML output for this error it would be a great help, and in particular how to find which field it is causing this.

Currently i see this message in the communications channel monitor, however when i click on the message-id it doesn't give me any further information it simply takes me to the Message Monitor and here it shows no further information.

Thank you kindly in advance!

[Gerard]

Hi, 

I solved the error adding a "description name" to the colum. 

The scenario I had, I was checking the number of entries in a table with a simple query like

SELECT COUNT(*) FROM MY_TABLE

This is CPI error feedback: 

I managed to solve the problem just adding a column name to the COUNT(*) function. 

Like this: SELECT COUNT(*) AS "Count" FROM MY_TABLE. 

Seems like the error was in the "*" character when reading the payload's feedback.