No announcement yet.

Database Reader Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Reader Error

    I keep getting the following error when I try and execute SQL code from a database reader channel.

    [2016-02-17 10:12:11,479]  ERROR (com.mirth.connect.connectors.jdbc.DatabaseReceiver:212): Failed to process row retrieved from the database in channel "CMR_OP_referral_orders"
    org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified.
    I understand that it having an issue with some of my data I am trying to pull in, but is there a way to still pull the data in? The other strange thing is I can execute this exact code in a lower version of Mirth (i.e. and it runs just fine. However, in version I get this error. Any thoughts???

  • #2
    Check out this post. Explains how to remove/replace illegal XML characters before Mirth starts processing.

    -= Jack Haines : Founder/CEO of Healthcare Integrations, LLC
    -= [email protected]
    -= Mirth Connect (Advanced)-certified
    -= Gold member of
    -= Available for Mirth Connect channel development and consultation! Schedule a FREE call with me at


    • #3
      That's a neat trick! I couldn't get it to work for my problem, but it is good to know that exists. Thanks!


      • #4
        So I've applied the following method to a handful of SQL queries that presented this error and it has fixed them all so far.

        xyz.PatNo as "Patient Number"

        Removing ALL double quotes from the query and truncating the alias:

        xyz.PatNo as PatientNumber

        This is assuming you want to retain the alias. Hope this helps!