| Author |
Message
|
| harishre |
 Posted: Tue Jun 24, 2008 12:13 am Post subject: Peculiar behaviour of ESQL code |
 |
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
Hi All,
I have a new problem today 
As per our business requirement I have made code changes to the ESQL in such a way that, the new two tags which are added in the XML file(buss reqt) are mapped to the fields of oracle database tables.
However changes for one tag is getting reflected and other is not getting reflected. interestingly code for both the tags is same in every aspect.
Dont know why code for one tag is working and not for the second....
any inputs please...  |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Tue Jun 24, 2008 12:17 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
is it possible for you to show us the code snippet.
it could be a small mistake in your data mapping
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 12:18 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
FYI here is the code for both the tags...
| Quote: |
working code:
SET Environment.Variables.Messages.XMLMESSAGE[M].MSGBODY.AP_INVOICES_INTERFACE.HEADER_GENERAL.INVOICE_NUM = InputRoot.XML.(XML.Element)XMLMESSAGE.MSGBODY.HOTEL_PAYMENT[I].INVOICE_NUM; |
| Quote: |
not working code:
SET Environment.Variables.Messages.XMLMESSAGE[M].MSGBODY.AP_INVOICES_INTERFACE.HEADER_GENERAL.DESCRIPTION = InputRoot.XML.(XML.Element)XMLMESSAGE.MSGBODY.HOTEL_PAYMENT[I].REMARKS; |
and more over I am not getting any errors anywhere.. |
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 12:26 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
even if I interchange the mappings.i.e.,
| Quote: |
earlier
invoice_num = invoice_num;
description = remarks
after interchange
invoice_num = remarks
description = invoice_num |
invoice_num is taking invoice_num only and description is not taking any value...... ( I am sure that deployment was successful after interchanging, cuz I could see successful logs in Event log Editor)
any idea pleaseeeeeeee |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jun 24, 2008 12:27 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
1. Hope REMARKS is the exact field name in the XML.
if it is in lower case please reflect in that way. Verify the spelling too in the XML sheet.
2. I assume REMARKS is an XML Element not an XML attribute.
if its an XML attribute you have to call it in (XML.Attribute)REMARKS like wise.
3. Last but not least, hope there is an element called REMARKS
in HOTEL_PAYMENT node of XML Sheet
[/b]
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 12:40 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
| Gaya3 wrote: |
1. Hope REMARKS is the exact field name in the XML.
if it is in lower case please reflect in that way. Verify the spelling too in the XML sheet. |
REMARKS is in upper case and the code is also written in uppercase only..
| Gaya3 wrote: |
2. I assume REMARKS is an XML Element not an XML attribute.
if its an XML attribute you have to call it in (XML.Attribute)REMARKS like wise. |
REMARKS is an element not an attribute
| Gaya3 wrote: |
3. Last but not least, hope there is an element called REMARKS
in HOTEL_PAYMENT node of XML Sheet. |
Sorry didnt get this point.. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jun 24, 2008 12:45 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
does the REMARKS element comes under the node HOTEL_PAYMENT
is it possible for you to show us the input XML message to us.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 1:13 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
yes REMARKS element comes under the node HOTEL_PAYMENT
here is the xml file..
| Quote: |
<XMLMESSAGE>
<CMH>
<ORIGAD>TOLCICS1</ORIGAD>
<DESTAD>ORA.AP</DESTAD>
<TRANCOD>ADDPAYREQT</TRANCOD>
<REVNO>001</REVNO>
<ENV>D</ENV>
</CMH>
<MSGBODY>
<HOTEL_PAYMENT>
<INVOICE_NUM>...</INVOICE_NUM>
<INVOICE_DATE>...</INVOICE_DATE>
<HOTEL_RESORT>...</HOTEL_RESORT>
<AMOUNT>....</AMOUNT>
<CURRENCY_CODE>...</CURRENCY_CODE>
<PRODUCT_CODE>..</PRODUCT_CODE>
<SUBPRODUCT_CODE>...</SUBPRODUCT_CODE>
<SEASON_CODE>....</SEASON_CODE>
<INV_RECORD_TYPE>...</INV_RECORD_TYPE>
<INV_REASON_CODE>....</INV_REASON_CODE>
<EXCHANGE_RATE>.....</EXCHANGE_RATE>
<RECORD_TYPE>...</RECORD_TYPE>
<REMARKS>.....</REMARKS>
</HOTEL_PAYMENT>
</MSGBODY>
</XMLMESSAGE> |
|
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 1:44 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
is there a possibility that, though the event log editor shows suucessful deployment, the deployment was not successful...
if so what could be the solution for that |
|
| Back to top |
|
|
| fschofer |
| Posted: Tue Jun 24, 2008 2:47 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
run a message flow trace with debug level to see whats happening in you flow.
Greetings
Frank |
|
| Back to top |
|
|
| harishre |
| Posted: Tue Jun 24, 2008 2:51 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
fschofer,
could you please tell me how to run a message flow trace with debug level ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jun 24, 2008 3:11 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you tried:
| Quote: |
| SET Environment.Variables.Messages.XMLMESSAGE[M].MSGBODY.AP_INVOICES_INTERFACE.HEADER_GENERAL.DESCRIPTION VALUE = InputRoot.XML.(XML.Element)XMLMESSAGE.MSGBODY.HOTEL_PAYMENT[I].REMARKS; |
This would allow for the field to have a null value (there is no comment / description).
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| fschofer |
| Posted: Tue Jun 24, 2008 3:25 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
|
| Back to top |
|
|
| nagarjun_vv |
| Posted: Tue Jun 24, 2008 10:38 pm Post subject: |
|
|
Apprentice
Joined: 24 Jun 2008
Posts: 33
|
Hi i have tried your code it is working fine but i removed the [M] which is used for array.
So ur code is right but may be some problem with the incrementing [M].
Can you give the entire code or the trace here.
Regards,
Nagarjun |
|
| Back to top |
|
|
| harishre |
| Posted: Wed Jun 25, 2008 7:51 am Post subject: |
|
|
Apprentice
Joined: 29 May 2008
Posts: 27
|
| Quote: |
Hi i have tried your code it is working fine but i removed the [M] which is used for array.
So ur code is right but may be some problem with the incrementing [M].
Can you give the entire code or the trace here. |
If I am not wrong I think incrementing the value [M] may not be the error since it is the same code which is used for both the elements INVOICE_NUM and REMARKS
my doubt is if the code is working for INVOICE_NUM why cant be for REMARKS...
I think I am at deadend now.... |
|
| Back to top |
|
|
|
|
