| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| send XML file to mySAP adapter. help |
« View previous topic :: View next topic » |
| Author |
Message
|
| soni |
 Posted: Tue Nov 20, 2007 8:09 am Post subject: send XML file to mySAP adapter. help |
 |
|
Novice
Joined: 08 Oct 2007
Posts: 15
Location: Spain
|
Hi,
I have a problem with mysap adapter.
I want to put a xml file in the input queue, and the MQ flow transform this xml in a valid format for process in mysap adapter.
Now, I put the XML file in the input queue, but have a problem when mysap apdater read it.
my esql code is:
| Code: |
CREATE COMPUTE MODULE META4_SIGHNO_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
-- CALL CopyMessageHeaders();
--CALL CopyEntireMessage();
CALL AddHdrRfh2_Sincro();
CALL CopyMessage();
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
CREATE PROCEDURE CopyMessage() BEGIN
DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/BLOB_BO';
DECLARE datos_salida CHARACTER;
DECLARE datos_blob BLOB;
SET OutputRoot.Properties = InputRoot.Properties;
SET OutputRoot.MRM = InputRoot.MRM;
SET OutputRoot.Properties.MessageDomain = 'MRM';
END;
CREATE PROCEDURE AddHdrRfh2_Sincro() BEGIN
CREATE NEXTSIBLING of OutputRoot.MQMD DOMAIN 'MQRFH2' NAME 'MQRFH2';
SET OutputRoot.MQMD = InputRoot.MQMD;
SET OutputRoot.MQMD.Format = MQFMT_RF_HEADER_2;
SET OutputRoot.MQRFH2.(MQRFH2.Field)Version = 2;
SET OutputRoot.MQRFH2.(MQRFH2.Field)Format = 'MQSTR ';
-- SET OutputRoot.MQRFH2.(MQRFH2.Field)Format = MQFMT_STRING;
-- SET OutputRoot.MQRFH2.mcd.Msd = 'jms_text';
SET OutputRoot.MQRFH2.mcd.Msd = 'mrm';
-- SET OutputRoot.MQRFH2.mcd.Set = '7';
SET OutputRoot.MQRFH2.mcd.Type = 'sap_z_sighn_om';
SET OutputRoot.MQRFH2.mcd.Fmt = 'CwXML';
SET OutputRoot.MQRFH2.jms.Dst = 'queue:///QL.QMDESA01.JTEXTSIGHN01.DELIVERYQUEUE';
SET OutputRoot.MQRFH2.jms.Tms = '1191841210078';
SET OutputRoot.MQRFH2.jms.Dlv = '2';
SET OutputRoot.MQRFH2.usr.WSDLBinding = 'sap_z_sighn_omAgentDeliveryBinding';
SET OutputRoot.MQRFH2.usr.WSDLOperation = 'sap_z_sighn_omCreate';
SET OutputRoot.MQRFH2.usr.PrivacyLevel = null;
SET OutputRoot.MQRFH2.usr.MessageType = 'sap_z_sighn_om';
SET OutputRoot.MQRFH2.usr = null;
SET OutputRoot.MQRFH2.usr.COD_APPL_ORG = 'SAPSIGNH01';
SET OutputRoot.MQRFH2.usr.COD_APPL_DST = 'META4SIGNH01';
SET OutputRoot.MQRFH2.usr.COD_TIPO_MSG = 'SINCSAP';
SET OutputRoot.MQRFH2.usr.MOD_RTR = 'C';
SET OutputRoot.MQRFH2.usr.FMT_MSG = 'PR';
SET OutputRoot.MQRFH2.usr.TYP_MSG = 'PET';
END;
END MODULE;
|
if anybody have an example that how I can do this action, please, say me.
thanks !!!!! |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Nov 20, 2007 10:21 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think you need to be a lot more clear about what the actual problem with the adapter is.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Nov 20, 2007 10:14 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
This is an adapter issue, Moderator(s) please move this to Adapter section.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Nov 21, 2007 1:37 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
1. Hope the adapter/connector is running
2. Hope the BO created with out any problem
3. Hope you uploaded the BO as message set to MB
If the adapter is running, please check the connector logs too
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| 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
|
|
|
|
