| Author |
Message
|
| MQ_LEO |
 Posted: Thu Aug 17, 2006 5:53 am Post subject: Regarding file extender nodes |
 |
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi everybody,
I want some help how to use file extender nodes to write a flat file in WBIMBV6.0.
At prasent my message flow is MQinput---> Mapping node---> MQoutput.
My input format is CSV.
My out format is CWF(COBOL).
I have to write my out put in a flat file on server.
Please help me what is my new message flow should look like.
and what are the necessary changes i have to do on file extender nodes. or any other nodes. please it is very urgent and important for me.
thanks a lot,
MQ_LEO |
|
| Back to top |
|
 |
| sebastianhirt |
| Posted: Thu Aug 17, 2006 6:04 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
Are you using file extender or is what you want to achieve this all in another way?
Assuming File Extender (and assuming functionality as in V5 of it):
In a Message 2 File Flow you will need a file proxy node and a file output node. In the file output node you can work with MRM definitions. For this you need to set Root\Properties accordingly.
Is this what you wanted to know?
cheers
Sebastian |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 6:16 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi Sebastianhirt,
Iam tusing file poxy and file out put node in my flow like.
MQinput---> fileproxy---> mapping---> file output.
But my message is not passing through file proxynode it bouncing back to MQinputnode.
should i change any configaration values in file proxynode. can you elobarate this (In the file output node you can work with MRM definitions. For this you need to set Root\Properties accordingly.) .
Thabks alot,
MQ_LEO |
|
| Back to top |
|
|
| sebastianhirt |
| Posted: Thu Aug 17, 2006 6:22 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
| MQ_LEO wrote: |
MQinput---> fileproxy---> mapping---> file output.
|
Looks good
| Quote: |
But my message is not passing through file proxynode it bouncing back to MQinputnode.
should i change any configaration values in file proxynode. |
You might use the debugger or switch on tracing to figure out what the exception is. Usually the File Proxy node is quiet straight forward to use.
| Quote: |
can you elobarate this (In the file output node you can work with MRM definitions. For this you need to set Root\Properties accordingly.) .
Thabks alot,
MQ_LEO |
in your mapping you need to set Message Set, Message Message Format and Message Type, in order that the Output node can set the format accordingly. And you do that in the Message tree at Root\Properties. This is pretty much comparable with that what you set in the MQMD or RFH2 on a MQ Output node[/quote] |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 6:48 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi sebastianhirt,
I am able to parse my csv fromat input to CWF output without file extender nodes.
but my reqirement needs to write that out in aflat file on server.
Here iam providing my ExceptionList. please help me to figureout the problem.
ExceptionList
Message
Properties
MQMD
MRM
ssn_vrf_inp_type
LocalEnvironment
Environment
ExceptionList
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp
INTEGER Line = 616
CHARACTER Function = ImbDataFlowNode::createExceptionList
CHARACTER Type = ComIbmMQInputNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_1
CHARACTER Label = SSN_VERF_Msg_Flow.MQInput
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2230
CHARACTER Text = Node throwing exception
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/ImbJniNode.cpp
INTEGER Line = 932
CHARACTER Function = ImbJniNode::evaluate
CHARACTER Type = ComIbmJniNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_6
CHARACTER Label = SSN_VERF_Msg_Flow.FileProxyNode
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2230
CHARACTER Text = Caught exception and rethrowing
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp
INTEGER Line = 1467
CHARACTER Function = ImbJavaExceptionUtils::userMbExceptionToNativeException
CHARACTER Type =
CHARACTER Name =
CHARACTER Label =
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 4367
CHARACTER Text = Unhandled exception in plugin method
Insert
Insert
Insert
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp
INTEGER Line = 1486
CHARACTER Function = ImbJavaExceptionUtils::userMbExceptionToNativeException
CHARACTER Type =
CHARACTER Name =
CHARACTER Label =
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 4394
CHARACTER Text = Unhandled exception in plugin method
Insert
Insert
Insert
Insert
Insert
Insert
INTEGER Type = 5
CHARACTER Text = [com.ibm.mbfe.messages.Messages:MBFE_00024]The terminal 'synch' has to be attached if the transaction is required.: No synch terminal attached.
Insert
INTEGER Type = 5
CHARACTER Text = com.ibm.mbfe.messages.Messages
Insert
Insert
INTEGER Type = 5
CHARACTER Text = <com.ibm.broker.plugin.MbRecoverableException class:com.ibm.mbfe.ProxyNode method:initTransaction source:com.ibm.mbfe.messages.Messages key:MBFE_00024 >
Thanks a lot
MQ_LEO |
|
| Back to top |
|
|
| sebastianhirt |
| Posted: Thu Aug 17, 2006 6:56 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
| Quote: |
CHARACTER Text = [com.ibm.mbfe.messages.Messages:MBFE_00024]The terminal 'synch' has to be attached if the transaction is required.: No synch terminal attached.
|
Here you go...
This is what the piece of documentation I have in front of me, tells me about the synch terminal.
| Quote: |
An optionally used terminal that should be connected to an MQReply node (with all properties left at default values) when you wish your transaction to be synchronized with the transaction involving other broker resources such as WebSphere MQ and/or the database.
|
Have you connected the synch terminal of the File Proxy node? |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 7:12 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi sebastianhirt,
Shall i connect the synch terminal of the File Proxy node to input of mapping node or any other node.please clear me.
Thanks alot,
MQ_LEO |
|
| Back to top |
|
|
| sebastianhirt |
| Posted: Thu Aug 17, 2006 7:15 am Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
What does your manual say?
As I said, I am only having a piece of documentation not the complete one. This suggests a MQReply node. |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 8:17 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi sebastianhirt.
I connected the synch terminal of the File Proxy node to input of mapping node. now my massage able to parse to infront of file out node. but then it jumping to failure node.here iam givving exception error.
please suggest what is the problem.
Message
Properties
MQMD
MRM
ssn_vrf_inp_type
LocalEnvironment
Environment
ExceptionList
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp
INTEGER Line = 616
CHARACTER Function = ImbDataFlowNode::createExceptionList
CHARACTER Type = ComIbmComputeNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_5.ComIbmMapping#FCMComposite_1_1
CHARACTER Label = SSN_VERF_Msg_Flow.Mapping.ComIbmCompute
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2230
CHARACTER Text = Node throwing exception
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
INTEGER Line = 589
CHARACTER Function = SqlStatementGroup::execute
CHARACTER Type = ComIbmComputeNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_5.ComIbmMapping#FCMComposite_1_1
CHARACTER Label = SSN_VERF_Msg_Flow.Mapping.ComIbmCompute
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2488
CHARACTER Text = Error detected, rethrowing
Insert
Insert
Insert
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlRoutine.cpp
INTEGER Line = 548
CHARACTER Function = SqlRoutine::invoke
CHARACTER Type = ComIbmComputeNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_5.ComIbmMapping#FCMComposite_1_1
CHARACTER Label = SSN_VERF_Msg_Flow.Mapping.ComIbmCompute
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2934
CHARACTER Text = Error occured in procedure
Insert
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
INTEGER Line = 589
CHARACTER Function = SqlStatementGroup::execute
CHARACTER Type = ComIbmComputeNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_5.ComIbmMapping#FCMComposite_1_1
CHARACTER Label = SSN_VERF_Msg_Flow.Mapping.ComIbmCompute
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2488
CHARACTER Text = Error detected, rethrowing
Insert
Insert
Insert
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/ImbJniNode.cpp
INTEGER Line = 932
CHARACTER Function = ImbJniNode::evaluate
CHARACTER Type = ComIbmJniNode
CHARACTER Name = SSN_VERF_Msg_Flow#FCMComposite_1_4
CHARACTER Label = SSN_VERF_Msg_Flow.FileOutputNode
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 2230
CHARACTER Text = Caught exception and rethrowing
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp
INTEGER Line = 1467
CHARACTER Function = ImbJavaExceptionUtils::userMbExceptionToNativeException
CHARACTER Type =
CHARACTER Name =
CHARACTER Label =
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 4367
CHARACTER Text = Unhandled exception in plugin method
Insert
Insert
Insert
RecoverableException
CHARACTER File = /build/S600_P/src/DataFlowEngine/PluginInterface/com_ibm_broker_plugin_CMbService.cpp
INTEGER Line = 1486
CHARACTER Function = ImbJavaExceptionUtils::userMbExceptionToNativeException
CHARACTER Type =
CHARACTER Name =
CHARACTER Label =
CHARACTER Catalog = BIPv600
INTEGER Severity = 3
INTEGER Number = 4394
CHARACTER Text = Unhandled exception in plugin method
Insert
Insert
Insert
Insert
Insert
INTEGER Type = 2
CHARACTER Text = 543
Insert
INTEGER Type = 5CHARACTER Text = Invalid output path '/home/chatlapallim/BRIDGESTrace/ssnout.txt' for file output node. Not in file system.
Insert
INTEGER Type = 5
CHARACTER Text = com.ibm.mbfe.messages.Messages
Insert
INTEGER Type = 5
CHARACTER Text = 4361
Here iam providing my file out put tab properties.
Basic--> output directory--- /home/chatlapallim/BRIDGESTrace/ssnout.txt
Format-->datatype---Text
RecordType----VariableRecords
End of file-----Native(the platform EOR).
ididnt change remaining tabs.
Thanks
MQ_LEO |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 11:40 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi,
Please any body help me regarding this issue.
it is very urgent for me
thanks alot
MQ_LEO |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Aug 17, 2006 11:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| MQ_LEO wrote: |
Text = Invalid output path '/home/chatlapallim/BRIDGESTrace/ssnout.txt' for file output node. Not in file system.
|
The more urgent it is for you, the more of your time you need to spend reading and thinking about all the information you have in front of you - most particularly the actual error messages that are produced.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Thu Aug 17, 2006 1:04 pm Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
Hi jefflowrey,
Please can you provide information regarding how can i create file system
for my out put file.
My broker running on solarisV10.
Thanks alot,
MQ_LEO |
|
| Back to top |
|
|
| sebastianhirt |
| Posted: Thu Aug 17, 2006 11:24 pm Post subject: |
|
|
Yatiri
Joined: 07 Jun 2004
Posts: 620
Location: Germany
|
| Best thing to do here is to ask your Solaris guy. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Aug 18, 2006 2:41 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| sebastianhirt wrote: |
| Best thing to do here is to ask your Solaris guy. |
And make sure the broker user has permissions to access it!
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| MQ_LEO |
| Posted: Fri Aug 18, 2006 4:56 am Post subject: |
|
|
Apprentice
Joined: 06 Jul 2006
Posts: 29
|
I am able to access this directory '/home/chatlapallim/BRIDGESTrace'.
before i used to write my trace logs in this directory successfully. Is there any special way to define fileoutput node path.
MQ_LEO |
|
| Back to top |
|
|
|
|
