Sending string using JMS MQS protocol

[rafael_cermeno]

Sending string using MQS protocol

Hello, I need help. I'm trying to create an interface which receives from my R3 system a string and must send it to a server using JMS adapter. People from the server side tell me they expect a string (the same line my interface receives), however they are getting the string embedded in an XML format. Can anyone tell me how do I get it to send just the line, without the xml data?

Example:

My R/3 System sends:

FILON 01024 A1 P1 04O01140813185320100017620000000010 0120140910 20140804 00012556V.P. SECRETARIA GENE J003439940 1181LE 00000000000000100000001000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000 10020000000006210000000000000000010000000000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 VEF OK

The JMS server receives:

<?xml version="1.0" encoding="utf-8" ?>

  <nm:MT_EnvioSolped_P1_ERP xmlns:nm="urn:Solped:VE_SAP_ERP_ORACLE" xmlns:prx="urn:sap.com:proxy:RD1:/1SAI/TAS9A1CD85A69589AB5528E:731">FILON 01024 A1 P1 04O01140813185320100017620000000010 0120140910 20140804 00012556V.P. SECRETARIA GENE J003439940 1181LE 00000000000000100000001000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000 10020000000006210000000000000000010000000000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 0000 0000000000000000000 VEF OK</nm:MT_EnvioSolped_P1_ERP>

Best Regards

[Former Member · Accepted solution]

Hello,

How you are receiving data from SAP? Using proxy?

By looking ur XML seems that u are mapping input string coming from ECC to JMS structure? if yes, then u can use Message transform bean to convert (above) XML to Text.

Search SDN, u will find quite a few wikis on the same.

Thanks

Amit Srivastava

[rafael_cermeno · Accepted solution]

Hello, yes, I'm receiving data from SAP using proxy. And yes, it seems that I'm mapping the input string from ECC to JMS. I tried to perform the conversion as you said, but I think something is still missing because it still doesn't work. Can you hel me? Below is my configuration so far...

Best Regards.

[Former Member · Accepted solution]

Adding a module doesn't do much unless you add the conversion parameters.

Refer to section 3.3 in below wiki

How To...Content conversion module with J2EE JMS adapter - Process Integration - SCN Wiki

[rafael_cermeno · Accepted solution]

Hello, despite the ongoing configurations even sending the file to the XML format

Best Regards.

[Former Member · Accepted solution]

Hi

You dont need to add the parameter xml.recordSetStructure.

Also replace xml.P1.*** to xml.***

Check this config (You can ignore the endSeparator parameter in this)

Regards

Osman

Message was edited by: Osman Jabri

[Former Member · Accepted solution]

Hello,

You cannot view your converted text message using message monitoring. So check with JMS team and see what content they have received?

Secondly, there is something wrong with your target structure which u have created in PI. Can you paste the same?

IMO, u should alter ur target structure little bit like this

<MT_EnvioSolped_P1_ERP>

<Record>

<Data>ABC</Data>

</Record>

</MT_EnvioSolped_P1_ERP>

and use below parameters under module config

XML2Plain      Transform.Class                 com.sap.aii.messaging.adapter.Conversion

XML2Plain      Transform.ContentType      text/plain;charset=utf-8

XML2Plain       xml.addHeaderLine            0

XML2Plain       xml.conversionType           SimpleXML2Plain

XML2Plain       xml.endSeparator               'nl'

XML2Plain        xml.fieldSeparator               ;

Thanks

Amit Srivastava

[rafael_cermeno · Accepted solution]

Make the adjustment but still travels xml header in the message, and do not really encounter that may be the cause.

If you can send me details step by step, much appreciate you, I stopped with it ..

Best Regards...