| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Working with Repeating Elements in Mapping Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| TonyD |
 Posted: Wed Oct 22, 2003 12:10 am Post subject: Working with Repeating Elements in Mapping Node |
 |
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
I am attempting to use the Mapping Node to map from XML to CWF (Cobol copybook). So far I have encountered several difficulties, possibly bugs, in working with this function, but the most immediate problem is in connection with mapping a repeating element. I have tried to decipher the Help material but it is not entirely helpful.
At present I have the situation where the flow fails to deploy with a syntax error. The ESQL generated by the Mapping node is displayed in the Event Log, the last portion of which is shown below:
| Quote: |
SET t_msg_BKCUCLG1.MNT_REQ_IN_AREA.BUS_REQ_MESSAGE.BUS_REQ_MSG.RQ_PHONE_LIST[1].SP_TE_DETAILS.SP_TE_EFFECTIVE_FROM = COALESCE(s_Message.MessageRequestBody.Customer.ArrayOfCustomerContact.CustomerContact[1].EffectiveFromDate, ' '); SET t_msg_BKCUCLG1.MNT_REQ_IN_AREA.BUS_REQ_MESSAGE.BUS_REQ_MSG.RQ_PHONE_LIST[1].SP_TE_DETAILS.SP_TE_EFFECTIVE_FROM = COALESCE(s_Message.MessageRequestBody.Customer.ArrayOfCustomerContact.CustomerContact[1].EffectiveFromDate, ' '); SET t_msg_BKCUCLG1.MNT_REQ_IN_AREA.BUS_REQ_MESSAGE.BUS_REQ_MSG.RQ_PHONE_LIST[1].SP_TE_DETAILS.SP_TE_EF'.
The next error message will give specific details of where the error occurred in the statement text. Check the correct syntax for compute node SQL statements in the WebSphere MQ Integrator publications. Correct the statements configuring the node and redeploy the configuration.
|
Two problems are apparent:
1. The ESQL has been truncated (at 'TE_EF'.), which should continue with a number of additional 'SET' statements. This is probably the cause of the syntax error. It is as if there is a limit for the size of the ESQL code.
2. The elements in the repeating element .....[1] have been repeated. '.._EFFECTIVE_FROM' above has been mapped twice, although only once in the original Mapping node.
I don't wish to bore people with this, but would be very interested to know if other people have worked with the Mapping node and run into problems of this type.
Also, is there any way one can see this ESQL before trying to deploy. Initially the Development Task log reported that there was a syntax error, and the flow could therefore not be added to the .bar file. There appears to be no way to locate such an error; rebuilding the mapping was the only way I could get around the error. |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
