XML Format in E1

Jaise James

Reputable Poster
Hello Is it possible to control XML format in E1. We are on 9.1 and sending message to transaction server using RTE. When we recive the message in MSMQ, it looks like message is not formated correctly

Its starting like this
Event-Id: NJRDBKESA1_178014321_6016_8176_091720121310412 Category: RTE Type: RTABOUT Environment: JDV910 Sequence-number: 2007, Xml-payload: <?xml version = '1.0' encoding = 'UTF-8'?>

instead of starting like
<?xml version = '1.0' encoding = 'UTF-8'?>

Any suggestions
 
Please provide the full row message, I have a couple of integration using rte and soa with no issue.

Regards.

Bruno Condemi
 
Event-Id: NJRDBKESA1_178014321_6016_8176_091720121310412 Category: RTE Type: RTABOUT Environment: JDV910 Sequence-number: 2007, Xml-payload: <?xml version = '1.0' encoding = 'UTF-8'?>
<jdeResponse category="RTE" environment="JDV910" pwd="" responseCreator="XAPI" role="*ALL" session="720c360" token="" type="realTimeEvent" user="JDE"><event><header><eventVersion>1.0</eventVersion><type>RTABOUT</type><user>JDE</user><role>*ALL</role><application>P01012</application><version>ZJDE0001</version><sessionID>720c360</sessionID><environment>JDV910</environment><host>NJRDBKESA1</host><sequenceID>2007</sequenceID><date>09172012</date><time>132516</time><scope/><codepage>1252</codepage><instanceInfo><host>NJRDBKESA1</host><port>6016</port><type>JDENET</type></instanceInfo></header><body elementCount="3"><detail DSTMPL="D0100085B" date="09172012" executionOrder="0" name="AddressBookMasterRealTimeWrapper" parameterCount="7" time="13:25:16" type="RTABPHOUT"><szPhoneAreaCode1 type="String"/><mnAddressNumber type="Double">0</mnAddressNumber><szPhoneNumber type="String">858 676-0918 </szPhoneNumber><mnContactPersonalID type="Double">0</mnContactPersonalID><mnSequenceNumber70 type="Double">1</mnSequenceNumber70><szPhoneNumberType type="String">HOM </szPhoneNumberType><mnLineNumberID type="Double">0</mnLineNumberID></detail><detail DSTMPL="D0100085B" date="09172012" executionOrder="1" name="AddressBookMasterRealTimeWrapper" parameterCount="7" time="13:25:16" type="RTABPHOUT"><szPhoneAreaCode1 type="String"/><mnAddressNumber type="Double">0</mnAddressNumber><szPhoneNumber type="String">732 3832569 </szPhoneNumber><mnContactPersonalID type="Double">0</mnContactPersonalID><mnSequenceNumber70 type="Double">2</mnSequenceNumber70><szPhoneNumberType type="String">CELL</szPhoneNumberType><mnLineNumberID type="Double">0</mnLineNumberID></detail><detail DSTMPL="D0100085A" date="09172012" executionOrder="2" name="AddressBookMasterRealTimeWrapper" parameterCount="112" time="13:25:16" type="RTABHDR"><szPhoneNumberTyp2 type="String"/><szTransactionOriginator type="String"/><cAddressType5 type="Character"/><szPhoneNumberTyp1 type="String"/><cAddressType4 type="Character"/><cAddressType3 type="Character"/><cAddressType2 type="Character"/><szCategoryCodeAddressBook2 type="String"> </szCategoryCodeAddressBook2><szTaxId type="String">XXX-XX-XXXX </szTaxId><szEdiTranslationFormat type="String"/><szTypeTransaction type="String"/><cActionMessageControl type="Character"/><szPhoneNumber1 type="String"/><szCategoryCodeAddressBk29 type="String"> </szCategoryCodeAddressBk29><mnEdiDetailLinesProcess type="Double">0</mnEdiDetailLinesProcess><szCategoryCodeAddressBk28 type="String"> </szCategoryCodeAddressBk28><szCategoryCodeAddressBk27 type="String"> </szCategoryCodeAddressBk27><szProgramId type="String">EP01012 </szProgramId><cPersonCorporationCode type="Character"/><szCategoryCodeAddressBk26 type="String"> </szCategoryCodeAddressBk26><szCategoryCodeAddressBk25 type="String"> </szCategoryCodeAddressBk25><szGlBankAccount type="String"/><szCategoryCodeAddressBk24 type="String"> </szCategoryCodeAddressBk24><szCategoryCodeAddressBk23 type="String"> </szCategoryCodeAddressBk23><szCategoryCodeAddressBk22 type="String"> </szCategoryCodeAddressBk22><szTaxId2 type="String"/><mnAddressNumber type="Double">103910</mnAddressNumber><mnTimeOfDay type="Double">0</mnTimeOfDay><szTransactionAction type="String"/><cAddressTypeEmployee type="Character"/><szCreditMessage type="String"/><szCountry type="String"> </szCountry><szUserId type="String"/><szReportCodeAddBook020 type="String"> </szReportCodeAddBook020><jdDateBeginningEffective type="Date"/><cDirectionIndicator type="Character"/><szKanjialpha type="String"> . </szKanjialpha><cAddTypeCode4Purch type="Character"/><szCountyAddress type="String"> </szCountyAddress><szAddressLine4 type="String"> </szAddressLine4><szAddressLine3 type="String"> </szAddressLine3><szAddressLine2 type="String"> </szAddressLine2><szAddressLine1 type="String">15070 Cross Stone Dr </szAddressLine1><szSearchType type="String">C </szSearchType><szReportCodeAddBook019 type="String"> </szReportCodeAddBook019><szWorkStationId type="String"/><mnTimeScheduledIn type="Double">0</mnTimeScheduledIn><szReportCodeAddBook018 type="String"> </szReportCodeAddBook018><szReportCodeAddBook017 type="String"> </szReportCodeAddBook017><szReportCodeAddBook016 type="String"> </szReportCodeAddBook016><jdEdiTransmissionDate type="Date"/><szReportCodeAddBook015 type="String"> </szReportCodeAddBook015><cActionCode type="Character">2</cActionCode><szReportCodeAddBook014 type="String"> </szReportCodeAddBook014><szReportCodeAddBook013 type="String"> </szReportCodeAddBook013><szReportCodeAddBook012 type="String"> </szReportCodeAddBook012><szReportCodeAddBook011 type="String"> </szReportCodeAddBook011><szReportCodeAddBook010 type="String"> </szReportCodeAddBook010><mnAddressNumber6th type="Double">0</mnAddressNumber6th><szContactTitle type="String"> </szContactTitle><szState type="String">CA </szState><szZipCodePostal type="String">92127 </szZipCodePostal><szEdiUserId type="String"/><cAddressTypeReceivables type="Character"/><mnAddressNumber5th type="Double">0</mnAddressNumber5th><szSecondaryMailingName type="String"/><mnUserReservedNumber type="Double">0</mnUserReservedNumber><mnAddressNumber4th type="Double">0</mnAddressNumber4th><szTradingPartnerId type="String"/><cSubledgerInactiveCode type="Character"/><jdUserReservedDate type="Date"/><szReportCodeAddBook009 type="String"> </szReportCodeAddBook009><szReportCodeAddBook008 type="String"> </szReportCodeAddBook008><szReportCodeAddBook007 type="String"> </szReportCodeAddBook007><szCertificateTaxExempt type="String"/><mnAddressNumber2nd type="Double">0</mnAddressNumber2nd><szReportCodeAddBook006 type="String"> </szReportCodeAddBook006><jdDateScheduledIn type="Date"/><szReportCodeAddBook005 type="String"> </szReportCodeAddBook005><szUserReservedCode type="String"/><szReportCodeAddBook004 type="String"> </szReportCodeAddBook004><szAlternateAddressKey type="String"/><szReportCodeAddBook003 type="String"> </szReportCodeAddBook003><szReportCodeAddBook002 type="String"> </szReportCodeAddBook002><szLanguagePreference type="String"/><szReportCodeAddBook001 type="String"> </szReportCodeAddBook001><szPhoneNumber type="String"/><szEmailAddressow type="String"/><szNameAlpha type="String">Hu, Chenggang (Cheng) </szNameAlpha><mnAddressNumber1st type="Double">0</mnAddressNumber1st><mnEdiLineNumber type="Double">0</mnEdiLineNumber><szPhoneAreaCode2 type="String"/><szPhoneAreaCode1 type="String"/><szEdiBatchNumber type="String"/><szNameRemark type="String"> </szNameRemark><szEdiTransactNumber type="String"/><szDescripCompressed type="String"/><szBusinessUnit type="String"> 110</szBusinessUnit><szStandardIndustryCode type="String"> </szStandardIndustryCode><szEdiDocumentType type="String"/><cMiscCode3 type="Character"/><szMailingName type="String">Hu, Chenggang (Cheng) </szMailingName><mnParentNumber type="Double">0</mnParentNumber><szUserReservedReference type="String"/><mnAddressNumber3rd type="Double">0</mnAddressNumber3rd><jdDateUpdated type="Date"/><mnUserReservedAmount type="Double">0</mnUserReservedAmount><cEdiSuccessfullyProcess type="Character"/><szCity type="String">San Diego </szCity><cAddressTypePayables type="Character"/><szCategoryCodeAddressBk30 type="String"> </szCategoryCodeAddressBk30><mnTimeLastUpdated type="Double">0</mnTimeLastUpdated></detail></body></event></jdeResponse>
 
The message format is absolutely correct.
A header must be present in every JMS message, the properties are optional and the payload is the JMS message itself.

Not sure to understand your problem.
 
Bruno
If its an xml message shouldn't the header


Event-Id: NJRDBKESA1_178014321_6016_8176_091720121310412 Category: RTE Type: RTABOUT Environment: JDV910 Sequence-number: 2007, Xml-payload:

be also wrapped in a XML tag.
 
You are wrong.
JMS is system to exchange information, not "xml information".
The JMS specifications do not include "xml" as message itself. The body can be StreamMessage,MapMessage,TextMessage (and then xml message), etc...

I don't' know how you need to consume this message but be sure it's correct an conform to the JMS specification.

If you have any doubt,please let me know.
 
Bruno

This is new..In 8.10 we had an msmqadapter that produced the xml message only

Now it goes to transaction server ( JMS queue) then JDEcommconnector pick the message from here and deleiver it to MSMQ. We then process from MSMQ using Biztalk. My understanding is that when the com connector deleiver the messsage to MSMQ, it would be in proper XML format. I understnad the payload at transaction server is in the format you mentioned. However, In MSMQ I expected it to be just XML.
Do you have a way to get the message from JMSqueue to a file system
 
I'm sorry, I was missing the MSMQ part, I never used MSMQ integration. Try to search for was jms queue browser, you will find some informations.
 

Similar threads

E9.2 XRCS_getMathNumericFromElement gives error when Mathnumeric value is ZERO in XML being read
Replies
3
Views
1K
BOster
BOster
N/A xmlinterop.dll (64 bit) error code 14
Replies
1
Views
2K
WorldClassInfo
JohnDanter2
E9.2 BSVW left outer join behaviour
Replies
7
Views
1K
JohnDanter2
JohnDanter2
E9.2 Could not start/find web server. Failed to Launch E1 menu on HTML Engine - 9.2
Replies
1
Views
3K
FosterD
RTE - JMS vs MSMQ Messages
Replies
1
Views
3K
Chan Rana
Chan Rana
Back
Top