I am new to this HL7 standard, but have worked on the NCPDP standard before. Now I'm trying to learn the open source tool Mirth Connect. When I try to configure in accordance with the documentation (User Guide), which is provided at http://www.mirthcorp.com/community/wiki/display/mirthuserguidev1r8p0/Message+Builder
URL, but this documentation mentions the HL7 template. I can not find these patterns. Could you help me.
I searched the Internet and some where the forums were found, which I found in the following example template
MSH | ^ ~ \ & | MIRTH_1.7 | DOMAIN | LABTEST || $ {date.get ('YYYYMMDDHHmm')} || ADT ^ A08 | $ {UUID} | P | 1.7 ||| AL | NE | EVN | A08 | $ {date.get ('YYYYMMDDHHmm')} |||| $ {Patno} || PID ||| $ {family_name} ^ $ {first_name} ^ {$ middle_name} ^^^^ || $ {d_o_b} | $ {sex} ||| $ {address1} ^ {$ address2} ^ {$ address3} ^^^^ || $ {phone} | {$ emp_phone} || $ {marital_status} | {$} religion ||||||||||| PV1 | |
When I used this and tried to start a channel, I get the following exception in Events
java.sql.SQLException: ORA-00911: invalid character
Query: SELECT PATIENTINFO.PATIENTID AS PATIENTINFO_PATIENTID,
PATIENTINFO.FIRSTNAME AS PATIENTINFO_FIRSTNAME,
PATIENTINFO.LASTNAME AS PATIENTINFO_LASTNAME
FROM PATIENTINFO;
Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:240)
at com.webreach.mirth.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:255)
at org.mule.providers.TransactedPollingMessageReceiver$1.doInTransaction(TransactedPollingMessageReceiver.java:91)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:104)
at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:90)
at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Unknown Source)
{}
and in server logs
[2010-07-28 19:02:52,515] FATAL (org.mule.impl.DefaultComponentExceptionStrategy:83): The Default Component Exception Strategy has been invoked but there is no current event on the context
[2010-07-28 19:02:52,515] FATAL (org.mule.impl.DefaultComponentExceptionStrategy:84): The error is: ORA-00911: invalid character
Query: SELECT PATIENTINFO.PATIENTID AS PATIENTINFO_PATIENTID,
PATIENTINFO.FIRSTNAME AS PATIENTINFO_FIRSTNAME,
PATIENTINFO.LASTNAME AS PATIENTINFO_LASTNAME
FROM PATIENTINFO;
Parameters: []
java.sql.SQLException: ORA-00911: invalid character
Query: SELECT PATIENTINFO.PATIENTID AS PATIENTINFO_PATIENTID,
PATIENTINFO.FIRSTNAME AS PATIENTINFO_FIRSTNAME,
PATIENTINFO.LASTNAME AS PATIENTINFO_LASTNAME
FROM PATIENTINFO;
Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:359)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:240)
at com.webreach.mirth.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:255)
at org.mule.providers.TransactedPollingMessageReceiver$1.doInTransaction(TransactedPollingMessageReceiver.java:91)
at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:72)
at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:104)
at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:90)
at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Unknown Source)
Please help me in solving this problem.
Thank. Student
source
share