Error in groovy script - The entity "nbsp" was referenced, but not declared

[nidhi_srivastava22]

Hi Experts,

I have used a script which was running fine but suddenly there is an error seen as mentioned below-

Error Details

com.sap.xi.mapping.camel.XiMappingException: The entity "nbsp" was referenced, but not declared., cause: org.xml.sax.SAXParseException; lineNumber: 7; columnNumber: 200; The entity "nbsp" was referenced, but not declared.

On checking the payload I can see a &nbsp character seen in the input which is causing the error.

Input Payload

<?xml version="1.0" encoding="UTF-8"?>

<ServiceNowIncident>

    <Incident>

        <ADONumber>40000</ADONumber>

        <State></State>

        <AssignedTo></AssignedTo>

        <AdditionalComments>SRIVASTAVA Nidhi (External) Hello Laurent, thank you for sharing the examples. We are investigating and come back to you with the solution.&nbsp;Best regards, Val</AdditionalComments>

    </Incident>

</ServiceNowIncident>

The groovy used is mentioned in the below blog, bit different but more or less the same. 

Solved: Structure Formatting for Receiver in SAP CPI throu... - SAP Community

Please suggest if this can be achieved easily, as there are already many conditions checked in the script and adding more should not hamper the existing one as this is already running in production.

Thanks,

Nidhi Srivastava

[Andrzej_Filusz · Accepted solution]

Hello,

You can add the following lines to your code:

    // Get the body of the message as a String
    def body = message.getBody(String)

    // the below code solves the non-breaking space issue
    String nbspHTML = ' '
    String nbspXML = ' '
    body = ((String)body).replaceAll(nbspHTML, nbspXML)

BR,

Andrzej