After upgrading Confluence 5.9.12 chart macro with Bob Swift SQL-Query macro started failing

After upgrading confluence server from version 5.8.4 to version 5.9.12 we've started receiving the following error message:

Error rendering macro 'chart' : org.dom4j.DocumentException: Error on line 1 of document : The entity "ecirc" was referenced, but not declared. Nested exception: The entity "ecirc" was referenced, but not declared.

Charts that worked fine now are not displayed with the error mentioned above, every time the column name has special characters in it, for example "Mês" (month in portuguese).

Another thing I've noticed is that the chart is rendered in the preview mode of editing a page but it fails to render when saved / published.

This stopped working in Confluence 5.9.7.

It is possible to reproduce this issue in Confluence without SQL macro by doing the following:

1. Add the Chart macro to a page
2. Add an HTML macro inside the Chart macro
3. Add the following table inside the body of the HTML macro:

<table id="TBL1467937544868" class="confluenceTable"><tbody><tr><th class="confluenceTh" title="Mês">M&ecirc;s</th><th class="confluenceTh" title="Vâlor">V&acirc;lor</th></tr><tr><td class="confluenceTd">1</td><td class="confluenceTd">63</td></tr><tr><td class="confluenceTd">2</td><td class="confluenceTd">86</td></tr><tr><td class="confluenceTd">3</td><td class="confluenceTd">95</td></tr><tr><td class="confluenceTd">4</td><td class="confluenceTd">98</td></tr></tbody></table>

Save the page