Announcement

Collapse
No announcement yet.

Database Reader Error

Collapse
X
 
  • 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.

    Code:
    [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. 3.0.0.6931) and it runs just fine. However, in version 3.0.1.7051 I get this error. Any thoughts???

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

    http://www.mirthcorp.com/community/f...d.php?t=215563

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

    Comment


    • #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!

      Comment


      • #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.

        Old:
        xyz.PatNo as "Patient Number"

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

        New:
        xyz.PatNo as PatientNumber

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

        Comment

        Working...
        X