CODEWITHSUNDEEP
pentahocda
ftuomey
ftuomey

Reputation: 33

Community Data Access CDA &#26 character invalid

I have created a number of queries in CDA for use with Pentaho Report Designer. I can link to my CDA queries on the server but when I try to preview some of the queries I get the following error:

Character reference "&#26" is an invalid XML character.

The queries run without a problem on the CDA previewer.

Thanks in advance, Fergus

Upvotes: 0

Views: 125

Answers (1)

bitlamas
bitlamas

Reputation: 742

&#26 is indeed an invalid XML character in XML version 1.0. In this case, more specifically, we're talking about the character &. The quick explanation as to why control characters are illegal:

[...] a markup language should not have any need to support transmission and flow control characters and including them would create a problem for any editors and parsers in binary conversion.

Pentaho Report Designer parser won't handle these control characters. Therefore, my suggestion is to change these values in your XML to & which is one of the five predefined entities in the XML specification, responsible to render the character &.

Upvotes: 1

Related Questions