Data Truncation Error: WrappedException

Hi

I'm really new to MIRTH - but have used other integration engines before to check for and resend HL7 messages.

We've recently had a system developed using MIRTH and I've been shown the the basics to check error messages, restart channels etc.



I have a Channel for ADT messages that are sent to a third party system for Orthopaedics. MIRTH keeps sending me alerts for the following error. Any idea how I tell where in the message the truncation error is? As its not obvious from the Raw message or the transformed message.

:confused:

Please feel free to point out any obvious answer as i'm very new to this.



ERROR-406: JDBC Connector error

ERROR MESSAGE: Error writing to database:

org.mozilla.javascript.WrappedException: Wrapped java.sql.DataTruncation: Data truncation (6fc3b139-650b-495e-b0f8-0b37a0d91872#262)

at org.mozilla.javascript.Context.throwAsScriptRuntim eEx(Context.java:1781)

at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:183)

at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:247)

at org.mozilla.javascript.Interpreter.interpretLoop(I nterpreter.java:1702)

at script.doDatabaseScript(6fc3b139-650b-495e-b0f8-0b37a0d91872:262)

at script(6fc3b139-650b-495e-b0f8-0b37a0d91872:270)

at org.mozilla.javascript.Interpreter.interpret(Inter preter.java:845)

at org.mozilla.javascript.InterpretedFunction.call(In terpretedFunction.java:164)

at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:426)

at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:3157)

at org.mozilla.javascript.InterpretedFunction.exec(In terpretedFunction.java:175)

at com.mirth.connect.connectors.jdbc.JdbcMessageDispa tcher.doDispatch(JdbcMessageDispatcher.java:96)

at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:263)

at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)

at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor.runWorker(ThreadPoolExecutor.java: 1061)

at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :575)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.sql.DataTruncation: Data truncation

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:379)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224)

at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:633)

at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:525)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:487)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeImp l(JtdsStatement.java:664)

at net.sourceforge.jtds.jdbc.JtdsStatement.execute(Jt dsStatement.java:1114)

at com.mirth.connect.server.util.DatabaseConnection.e xecuteUpdate(DatabaseConnection.java:107)

at sun.reflect.GeneratedMethodAccessor73.invoke(Unkno wn Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:161)

... 13 more

Data Truncation Error: WrappedException