web stats
database reader to file writer - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2006, 08:13 AM
vlj@ohsjd.es vlj@ohsjd.es is offline
Mirth Newb
 
Join Date: Oct 2006
Posts: 6
vlj@ohsjd.es
Default database reader to file writer

I'm testing de mirth and i'm trying to create a ORM^O01 message, I've made some diferents cases, and the result is ever the same: The last time I've download the example on the web but the result without tranformations is the same:
************************************************** ******************************

ERROR 2006-10-17 17:52:34,561 [14.2] org.mule.impl.DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 14: org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:193)
at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)
Caused by: org.mule.umo.transformer.TransformerException: Failed to parse result map
at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
at org.mule.impl.MuleEventContext.getTransformedMessa ge(MuleEventContext.java:100)
at com.webreach.mirth.server.mule.components.Outbound Channel.onCall(OutboundChannel.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mule.model.DynamicEntryPoint.invokeCurrent(Dyn amicEntryPoint.java:168)
at org.mule.model.DynamicEntryPoint.invoke(DynamicEnt ryPoint.java:90)
at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:177)
... 7 more
DEBUG 2006-10-17 17:52:39,531 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:52:44,532 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:52:49,532 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:52:54,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:52:59,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:04,533 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:09,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:14,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:19,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:24,534 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:29,535 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:29,535 [14_source._jdbcEndpoint#305920046.receiver.1] org.mule.providers.jdbc.JdbcMessageReceiver: Received Message: {obr16=null, obr44=^^^ , msh2=^~\& , obr24=CR , msh5=DocuMed HL7 Server , obr46=^^^ , msh1=|, msh7=200610171023 , obr36=200606171115 , obr366=200606171115 , orc7=R , orc2=null, obr45=^^^ , obr19=null, msh9=ORM^001 , orc3=null, obr363=200606171115 , obr361=200606171115 , pid7=191501010000 , obr4=10^EXTREMIDADES INFERIORES^1012^RODILLAS AP+LAT , pid8=F , pid5=BARCELO^FERNANDEZ^FRANCISCA , obr364=200606171115 , obr365=200606171115 , obr43=^^^ , pv18=null, orc1=NW , obr20=null, obr31=null, msh10= 38, obr42=^^^ , obr362=200606171115 , obr41=10^CINTURÓN ESCAPULAR^1012^HOMBRO AP + AX , msh3=WEBHOSPITAL , obr15=null, msh12=2.3.1 , pid2=1019656 , obr34=null}
DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcConnector: Retrieving new connection from data source: jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7 (net.sourceforge.jtds.jdbc.Driver)
DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: Message Received from: jdbc://query
DEBUG 2006-10-17 17:53:29,550 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: MuleMessage{id=[uniqueId not supported], payload=org.apache.commons.dbutils.BasicRowProcess or$CaseInsensitiveHashMap, correlationId=null, correlationGroup=-1, correlationSeq=-1, exceptionPayload=null, properties={}}
DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.providers.jdbc.JdbcMessageReceiver: Message Payload:
{obr16=null, obr44=^^^ , msh2=^~\& , obr24=CR , msh5=DocuMed HL7 Server , obr46=^^^ , msh1=|, msh7=200610171023 , obr36=200606171115 , obr366=200606171115 , orc7=R , orc2=null, obr45=^^^ , obr19=null, msh9=ORM^001 , orc3=null, obr363=200606171115 , obr361=200606171115 , pid7=191501010000 , obr4=10^EXTREMIDADES INFERIORES^1012^RODILLAS AP+LAT , pid8=F , pid5=BARCELO^FERNANDEZ^FRANCISCA , obr364=200606171115 , obr365=200606171115 , obr43=^^^ , pv18=null, orc1=NW , obr20=null, obr31=null, msh10= 38, obr42=^^^ , obr362=200606171115 , obr41=10^CINTURÓN ESCAPULAR^1012^HOMBRO AP + AX , msh3=WEBHOSPITAL , obr15=null, msh12=2.3.1 , pid2=1019656 , obr34=null}
DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.MuleSession: dispatching event to component: 14 event is: Event: a21cc0d0-5df7-11db-8b5f-bfeb6dbcc61b, sync=false, stop processing=false, ImmutableMuleEndpoint{connector=org.mule.providers .jdbc.JdbcConnector@1931579, endpointUri=jdbc://query, transformer=Transformer{name='ResultMapToXML', returnClass=false, returnClass=false, sourceTypes=[class java.util.HashMap]}, name='_jdbcEndpoint#305920046', type='receiver', properties={}, transactionConfig=org.mule.impl.MuleTransactionCon fig@a4ed99, filter=null, deleteUnacceptedMessages=false, initialised=true, securityFilter=null, synchronous=null, initialState=started, createConnector=0}
DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Component: 14 has received asynchronous event on: jdbc://query
DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Component: 14 has received asynchronous event on: jdbc://query
DEBUG 2006-10-17 17:53:29,566 [14_source._jdbcEndpoint#305920046.receiver.3] org.mule.impl.model.seda.SedaComponent: Event added to queue for: 14
DEBUG 2006-10-17 17:53:29,566 [14.1] org.mule.impl.model.seda.SedaComponent: Component: 14 dequeued event on: jdbc://query
DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.impl.model.DefaultMuleProxy: MuleProxy: async onEvent for Mule UMO 14
DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.model.DynamicEntryPoint: Invoking com.webreach.mirth.server.mule.components.Outbound Channel.onCall(org.mule.impl.MuleEventContext)
DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.transformer.TransformerException ' is: http://mule.codehaus.org/docs/apidoc...Exception.html
DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.transformer.TransformerException ' is: null
DEBUG 2006-10-17 17:53:29,566 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.MessagingException' is: http://mule.codehaus.org/docs/apidoc...Exception.html
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: doc. Url for package 'org.mule.umo.MessagingException' is: null
DEBUG 2006-10-17 17:53:29,582 [14.3] org.mule.config.ExceptionHelper: javadoc. Url for package 'org.mule.umo.transformer.TransformerException ' is: http://mule.codehaus.org/docs/apidoc...Exception.html
ERROR 2006-10-17 17:53:29,582 [14.3] org.mule.impl.DefaultComponentExceptionStrategy:
************************************************** ******************************
Message : Failed to parse result map
Type : org.mule.umo.transformer.TransformerException
Code : 64999
Transformer : Transformer{name='ResultMapToXML', returnClass=false, returnClass=false, sourceTypes=[class java.util.HashMap]}
JavaDoc : http://mule.codehaus.org/docs/apidoc...Exception.html
************************************************** ******************************
Exception stack is:
1. Failed to parse result map (org.mule.umo.transformer.TransformerException)
com.webreach.mirth.server.mule.transformers.Result MapToXML:70 (http://mule.codehaus.org/docs/apidoc...Exception.html)
************************************************** ******************************
Root Exception stack trace:
org.mule.umo.transformer.TransformerException: Failed to parse result map
at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
at org.mule.impl.MuleEventContext.getTransformedMessa ge(MuleEventContext.java:100)
at com.webreach.mirth.server.mule.components.Outbound Channel.onCall(OutboundChannel.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mule.model.DynamicEntryPoint.invokeCurrent(Dyn amicEntryPoint.java:168)
at org.mule.model.DynamicEntryPoint.invoke(DynamicEnt ryPoint.java:90)
at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:177)
at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)

************************************************** ******************************

ERROR 2006-10-17 17:53:29,582 [14.3] org.mule.impl.DefaultComponentExceptionStrategy: Caught exception in Exception Strategy for: 14: org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
org.mule.umo.MessagingException: Failed to invoke UMO Component: 14. Message payload is of type: org.apache.commons.dbutils.BasicRowProcessor$CaseI nsensitiveHashMap
at org.mule.impl.DefaultLifecycleAdapter.onCall(Defau ltLifecycleAdapter.java:193)
at org.mule.impl.DefaultLifecycleAdapter.intercept(De faultLifecycleAdapter.java:232)
at org.mule.impl.InterceptorsInvoker.execute(Intercep torsInvoker.java:53)
at org.mule.impl.model.DefaultMuleProxy.run(DefaultMu leProxy.java:388)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)
Caused by: org.mule.umo.transformer.TransformerException: Failed to parse result map
at com.webreach.mirth.server.mule.transformers.Result MapToXML.doTransform(ResultMapToXML.java:70)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)



this is chanel:
[blue]
<?xml version="1.0" encoding="UTF-8" ?>
- <mule-configuration id="MirthConfiguration" version="1.0">
<mule-environment-properties embedded="false" />
- <agents>
<agent className="org.mule.management.agents.RmiRegistryA gent" name="RMI" />
- <agent className="org.mule.management.agents.JmxAgent" name="JMX">
- <properties>
<property name="connectorServerUrl" value="service:jmx:rmi:///jndi/rmi://localhost:1099/server" />
- <map name="connectorServerProperties">
<property name="jmx.remote.jndi.rebind" value="true" />
</map>
</properties>
</agent>
</agents>
- <connector className="org.mule.providers.jdbc.JdbcConnector" name="14_source">
- <properties>
<property name="pollingFrequency" value="5000" />
<property name="username" value="sa" />
<property name="useAck" value="1" />
<property name="URL" value="jdbc:jtds:sqlserver://HSJD05ts02:1433/hl7" />
<property name="password" value="hsjd05" />
<property name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
- <map name="queries">
<property name="query" value="SELECT MSH1,MSH2,MSH3,MSH5,MSH7,MSH9,MSH10,MSH12,PID2,pid 5,PID7,PID8,PV18,ORC1,ORC2,ORC3,ORC7,OBR24,OBR16,O BR4,OBR15,OBR19,OBR20,OBR34,OBR36,OBR31,OBR41,OBR3 61,OBR42,OBR362,OBR43,OBR363,OBR44,OBR364,OBR45,OB R365,OBR46,OBR366 FROM mensaje WHERE ESTADO IS NULL" />
<property name="ack" value="UPDATE mensaje SET estado='OK'" />
</map>
</properties>
</connector>
- <connector className="org.mule.providers.file.FileConnector" name="14_destination_1">
- <properties>
<property name="outputAppend" value="0" />
<property name="outputPattern" value="${DATE:yy-MM-dd}" />
<property name="template" value="${HL7 ER7}" />
</properties>
</connector>
- <transformers>
<transformer className="org.mule.transformers.simple.ByteArrayT oString" name="ByteArrayToString" />
<transformer className="org.mule.transformers.simple.StringToBy teArray" name="StringToByteArray" />
<transformer className="com.webreach.mirth.server.mule.transfor mers.ER7toXML" name="ER7toXML" />
<transformer className="com.webreach.mirth.server.mule.transfor mers.XMLtoER7" name="XMLtoER7" />
<transformer className="com.webreach.mirth.server.mule.transfor mers.ResultMapToXML" name="ResultMapToXML" />
<transformer className="com.webreach.mirth.server.mule.transfor mers.VariableHashMapToER7String" name="VariableHashMapToER7String" />
- <transformer className="com.webreach.mirth.server.mule.transfor mers.JavaScriptTransformer" name="14_destination_1">
- <properties>
<property name="script" value="var hl7_xml = new XML('<?xml version="1.0"?><ORM_O01 xmlns="urn:hl7-org:v2xml"> <MSH> <MSH.1>|</MSH.1> <MSH.2>^~\&</MSH.2> <MSH.3>LAB</MSH.3> <MSH.4>CCF</MSH.4> <MSH.7>20040920080937</MSH.7> <MSH.9> <CM_MSG.1>ORM</CM_MSG.1> <CM_MSG.2>O01</CM_MSG.2> </MSH.9> <MSH.10>42640000009</MSH.10> <MSH.11>P</MSH.11> <MSH.12>2.1</MSH.12> </MSH> <NTE/> <ORM_O01.PATIENT> <PID> <PID.3> <CK.1>56797971</CK.1> </PID.3> <PID.5> <PN.1>RESULTSREVIEW</PN.1> <PN.2>TESTPATIENT</PN.2> </PID.5> <PID.7>19650525</PID.7> <PID.8>M</PID.8> <PID.18> <CK.1>56797971</CK.1> </PID.18> </PID> <NTE/> <PV1> <PV1.2>O</PV1.2> <PV1.3>UNKO</PV1.3> </PV1> </ORM_O01.PATIENT> <ORM_O01.ORDER> <ORC> <ORC.1>CA</ORC.1> <ORC.2> <CM.1>30725991</CM.1> <CM.2>EPIC_EC</CM.2> </ORC.2> <ORC.16> <UNKNOWN.2>Duplicate</UNKNOWN.2> </ORC.16> </ORC> <ORM_O01.ORDER_DETAIL> <OBR> <OBR.2> <CM.1>30725991</CM.1> <CM.2>EPIC_EC</CM.2> </OBR.2> <OBR.4> <CE.1>CBCDIF</CE.1> <CE.2>CBC and Differential</CE.2> </OBR.4> <OBR.7>200409200805</OBR.7> <OBR.14>L</OBR.14> <OBR.16> <CN.1>00593</CN.1> </OBR.16> <OBR.20>M10274</OBR.20> <OBR.21>UNKO</OBR.21> <OBR.25>X</OBR.25> <OBR.27> <CM.2>ONCE</CM.2> <CM.4>200409200805</CM.4> </OBR.27> </OBR> </ORM_O01.ORDER_DETAIL> </ORM_O01.ORDER></ORM_O01>');var hl7_er7 = 'MSH|^~\&|LAB|CCF|||20040920080937||ORM^O01|426400 00009|P|2.1|\rPID|||56797971||RESULTSREVIEW^TESTPA TIENT^||19650525|M||||||||||56797971|\rPV1||O|UNKO ^|||||\rORC|CA|30725991^EPIC_EC||||||||||||||^Dupl icate|\rOBR||30725991^EPIC_EC||CBCDIF^CBC and Differential|||200409200805|||||||L|^|00593^||||M1 0274|UNKO||||X||^ONCE^^200409200805^^|^^|\r';chann elid = '14';localMap.put("HL7 XML", hl7_xml);localMap.put("HL7 ER7", hl7_er7);" />
</properties>
</transformer>
</transformers>
- <interceptor-stack name="default">
<interceptor className="org.mule.interceptors.LoggingIntercepto r" />
<interceptor className="org.mule.interceptors.TimerInterceptor" />
</interceptor-stack>
- <model name="Mirth">
- <!-- new descriptors will be added here
-->
- <mule-descriptor implementation="com.webreach.mirth.server.mule.com ponents.OutboundChannel" initialState="stopped" name="14">
- <inbound-router>
<endpoint address="jdbc://query" connector="14_source" transformers="ResultMapToXML" />
</inbound-router>
- <outbound-router>
- <router className="org.mule.routing.outbound.FilteringMult icastingRouter">
- <endpoint address="file://C:/MENSAJES/SALIDA" connector="14_destination_1" transformers="14_destination_1">
- <filter className="com.webreach.mirth.server.mule.filters. JavaScriptFilter">
- <properties>
<property name="script" value="return true;" />
</properties>
</filter>
</endpoint>
</router>
</outbound-router>
</mule-descriptor>
</model>
</mule-configuration>[/blue]

thanks
Reply With Quote
  #2  
Old 10-17-2006, 12:10 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: database reader to file writer

Can you email me the channel export (chrisl [at] webreachinc.com) and possibly a database schema dump/sample data?

Thanks,
-Chris
__________________
Chris Lang
Reply With Quote
  #3  
Old 10-18-2006, 03:02 AM
vlj@ohsjd.es vlj@ohsjd.es is offline
Mirth Newb
 
Join Date: Oct 2006
Posts: 6
vlj@ohsjd.es
Default Re: database reader to file writer

Now, if I only select the fields of the bd that I want to transform, The destination file is writed, but the hl7 variable that I've mapped it's appears like 'UNDEFINED' in the text destination file.

Is the type of the field in the database? All of them are defined like char or varchar

why?

thanks
Reply With Quote
  #4  
Old 10-18-2006, 07:04 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: database reader to file writer

To prevent 'undefined', put .toString() on all of your mappings. Undefined is the default JS value when a variable does not exist (equivalent to null).

-CHris
__________________
Chris Lang
Reply With Quote
  #5  
Old 10-19-2006, 12:43 AM
vlj@ohsjd.es vlj@ohsjd.es is offline
Mirth Newb
 
Join Date: Oct 2006
Posts: 6
vlj@ohsjd.es
Default Re: database reader to file writer

Now, the error is:

"cannot find the function text"

Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Writer / Database Reader problem tadigiri Support 3 03-26-2012 11:26 AM
Database Reader to File Writer with column aliases arumpke Support 4 02-27-2009 12:53 PM
1.7.1 file reader/file writer channel steverhusker Support 2 08-12-2008 08:53 AM
Database reader and database writer Vgupta Development 0 12-03-2007 10:41 AM
Channel as Database reader and Database writer Alexander Development 0 10-24-2007 07:24 PM


All times are GMT -8. The time now is 07:26 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation