2 Replies Latest reply on Nov 7, 2019 2:31 AM by Andrew Waters

    special characters at Custom reports show clausule

    Juan Jose Algar Ortega
      Share This:

      We are trying to define some Custom Reports that it contains some "special Characters" like "<" or ">" or "Ñ" at show clausule and although at "Query windows"  the query is executed correctly at "Custom reports" we obtain and error during appserver start like,


      Does anybody obtain similar error using "special Characters"?


      140252869666560: 2019-11-06 19:41:44,699: ui.web.services.reports_config: ERROR: Error parsing /usr/tideway/data/custom/reports/Informes.xml, line 131, column 97

      Traceback (most recent call last):

        File "./reports_config.py", line 216, in load

        File "./xmlhandler.py", line 166, in parseFile

        File "./xmlhandler.py", line 154, in parseChunk

        File "/usr/tideway/lib/python2.7/site-packages/_xmlplus/sax/expatreader.py", line 220, in feed


        File "/usr/tideway/lib/python2.7/site-packages/_xmlplus/sax/handler.py", line 38, in fatalError

          raise exception

      SAXParseException: <unknown>:131:97: not well-formed (invalid token)


      The line is similar to this one with "Ñ" character


         extract(replace(replace(replace(#:::Host.#OwnedItem:Ownership:Owner:OrganisationalUnit.name, 'Ñ', 'N'), ',', ''),'-', ' ') , regex '\w*_(\S*)' , raw '\1') as Tipo_Entorno,


      and with > or < the line is used to write different value depend on the value of some functions defined at with section.


         ( (@ClusterMember > 0 and @ClusterMember >= @NumHosts) and @ClusterMember

          or ( @HostOfCluster > 0 and @HostOfCluster < 4 ) and @HostOfCluster

          or @NumHosts > 0 and @NumHosts) as 'Num Cluster Instances',