| Author |
Message
|
| drajib |
 Posted: Tue Mar 25, 2003 6:16 am Post subject: Help needed with MQSI 2.0.2 and NEON |
 |
|
Apprentice
Joined: 25 Mar 2003
Posts: 42
Location: India
|
It would be greatly appreciated if any of you could throw light onto the following -
Input message structure
- 1 Header record
- n (variable) Detail records
- 1 Footer record
Output message structure is essentially the same with some logical transformations
We have defined structures for both input and output messages in NEON Formatter
The input message is getting parsed properly
Compute node is connected to the MQOutput node via a Trace node. The trace is showing the message in the required output format
However, the MQOutput node is throwing the following exception -
***********ExceptionList
(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:/build/S202_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 538
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmMQInputNode'
(0x3000000)Name = 'a7408ffb-f300-0000-0080-fe9a15626bfb'
(0x3000000)Label = 'ITS.SAM.SSR.COLT.MF.TMS To AMR'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'MQSIv202'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:/build/S202_P/src/DataFlowEngine/ImbMqOutputNode.cpp'
(0x3000000)Line = 1239
(0x3000000)Function = 'ImbMqOutputNode::evaluate'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = 'f84a8ffb-f300-0000-0080-fe9a15626bfb'
(0x3000000)Label = 'ITS.SAM.SSR.COLT.MF.AMR To SSR'
(0x3000000)Text = 'Caught exception and rethrowing'
(0x3000000)Catalog = 'MQSIv202'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)ParserException = (
(0x3000000)File = 'NeonParser.cpp'
(0x3000000)Line = 55
(0x3000000)Function = 'Reformat'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = ''
(0x3000000)Catalog = 'MQSIv2NeonPlugins'
(0x3000000)Severity = 3
(0x3000000)Number = 111
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'ITS.SAM.SSR.OC.COLT'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = '1066'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Output Mandatory format ITS.SAM.SSR.OF.COLT.SETSEC contains no fields'
)
)
)
)
)
Eagerly waiting for your help ... |
|
| Back to top |
|
 |
| vmcgloin |
| Posted: Tue Mar 25, 2003 6:34 am Post subject: |
|
|
Knight
Joined: 04 Apr 2002
Posts: 560
Location: Scotland
|
It could be as simple as forgetting to setup the input field name for that part of the output message. Also, if n could be 0 then you should make the sub-format optional.
Have you found the error descriptions in the NEON Formatter Programming Reference pdf?
1066 | Output mandatory format <format> contains no fields. | Check output format definition and input data fields used in output format.
Vicky |
|
| Back to top |
|
|
| drajib |
| Posted: Tue Mar 25, 2003 7:02 am Post subject: |
|
|
Apprentice
Joined: 25 Mar 2003
Posts: 42
Location: India
|
Thanks for your reply Vick.
Mappings are done by eSQL and as stated earlier the trace as well as the debugger is showing the message in the required output format
Also the cardinality of Detail record is 1-n
The error is thrown from the MQOutput node. Still searching the cause ... |
|
| Back to top |
|
|
| wmqiguy |
| Posted: Tue Mar 25, 2003 7:49 am Post subject: |
|
|
Centurion
Joined: 09 Oct 2002
Posts: 145
Location: Florida
|
Couple of things to consider.
1. If you are using ESQL for all the mappings, make sure that the structure has been completely populated. Otherwise, make sure that the output format has a default value in the output control.
2. Is your ESQL mapping directly from NNSY to NNSY? I have found that it is better to map from NNSY to an XML tree that resembles the NNSY tree and then use an RCD node before the MQOutput node.
Hope that helps. 
Regards,
Todd |
|
| Back to top |
|
|
| drajib |
| Posted: Sun Mar 30, 2003 3:42 am Post subject: |
|
|
Apprentice
Joined: 25 Mar 2003
Posts: 42
Location: India
|
| Thanks for your reply Todd. We actually missed a default value |
|
| Back to top |
|
|
|
|
