Debugging an invalid XML character error

Situation:

When processing files, you may encounter the following error:

Error in execution for activity DataMapping:Mapping_test:12700000000
1122343220020[Error in execution : An invalid XML character (Unicode: 0x5) was found in the CDATA section.]

Cause:

Within the source file, there's an invalid XML character. In this example, the character is '0x5'.

Solution:

To resolve this issue, you have to identify what Unicode character 0x5 would be. A good website to reference is http://www.asciitable.com/.

From the chart below, we can see that '0x5' is equal to the 'ENQ' ANSII character.

If you're unable to identify this character visually, then you can use a text editor such as TextPad to view your source file.  Within the application, use the Find function and select "hex" and search for the character mentioned.

Removing these characters from your source file resolve the invalid XML character issue.