| Author |
Message
|
| DELLIPIZ |
 Posted: Wed Mar 02, 2005 2:37 pm Post subject: CDATA problem |
 |
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
I am doing an MRM to XML conversion.
My output right now looks like this:
<m:performSearch xmlns:m="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
<SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd igfElsSearch.xsd">
<ClientName>IGFELS</ClientName>
<SearchInput>
<QueryName>SEARCH</QueryName>
<InputList>
<cMRLegSysCtry>866</cMRLegSysCtry>
<legCMRCusNum>90809898</legCMRCusNum>
<logicalDeleteFlag>N</logicalDeleteFlag>
<mppIdAcctGrp>ZS01</mppIdAcctGrp>
</InputList>
</SearchInput>
<ExtendedHeader>wmq</ExtendedHeader>
</SearchXML>
</m:performSearch>
But I need it to look like this:
<m:performSearch xmlns:m="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
<m:text><![CDATA[<SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd igfElsSearch.xsd">
<ClientName>IGFELS</ClientName>
<SearchInput>
<QueryName>SEARCH</QueryName>
<InputList>
<cMRLegSysCtry>866</cMRLegSysCtry>
<legCMRCusNum>90809898</legCMRCusNum>
<logicalDeleteFlag>N</logicalDeleteFlag>
<mppIdAcctGrp>ZS01</mppIdAcctGrp>
</InputList>
</SearchInput>
<ExtendedHeader>wmq:c3e2d840d5d7c4f04040404040404040bca5ce86f0df4c27|jms:/queue?destination=jms/ICFS/IGFELSSearchResponseIT1I|2005-02-18-09.58.46.711295</ExtendedHeader>
</SearchXML>]]>
</m:text>
</m:performSearch>
In other words, I need to put all the XML between <SearchXML> and </SearchXML> between
<m:text><![CDATA and >]]>
</m:text>
Any suggestions?????
Thanks!
-Lori[/b] |
|
| Back to top |
|
 |
| JT |
| Posted: Wed Mar 02, 2005 5:06 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Wed Mar 02, 2005 6:26 pm Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
Thanks for the reply, but I'm not sure how to apply that to what I have. Can you please help me out. This is how I am creating the XML. The data between the ******* needs to be put within the <m:text><![CDATA
AND >]]> </m:text> tags.
The first part of the code creates the soapenv:Header.
Then....
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch".(XML.Attribute)"xmlns:m" value = 'http://bsi.web.rdc.ibm.com/SRServiceBSI/';
******************************************
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch".."SearchXML".(XML.Attribute)"xmlns" = 'http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd';
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch".."SearchXML".(XML.Attribute)"xmlns:xsi" = 'http://www.w3.org/2001/XMLSchema-instance';
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch".."SearchXML".(XML.Attribute)"xsi:schemaLocation" = 'http://web.rdc.ibm.com/SRServices/IGF/igfElsSearch.xsd igfElsSearch.xsd';
CREATE FIELD OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch"."SearchXML";
DECLARE ResultHdr REFERENCE TO OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch"."SearchXML";
SET ResultHdr."ClientName" = InputRoot.MRM.CLIENT_NAME;
SET ResultHdr."SearchInput"."QueryName" = InputRoot.MRM.QUERY_NAME;
SET ResultHdr."SearchInput"."InputList"."cMRLegSysCtry" = InputRoot.MRM.COUNTRY_CODE;
SET ResultHdr."SearchInput"."InputList"."legCMRCusNum" = InputRoot.MRM.LEGACY_CUST_NUM;
SET ResultHdr."SearchInput"."InputList"."logicalDeleteFlag" = InputRoot.MRM.LOGICAL_DEL_FLAG;
SET ResultHdr."SearchInput"."InputList"."mppIdAcctGrp" = InputRoot.MRM.ACC_GROUP;
***************************************************
Thanks for your help!
-Lori |
|
| Back to top |
|
|
| JT |
| Posted: Wed Mar 02, 2005 7:56 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
You can try this un-tested piece of ESQL code. Add the following lines after settting the last XML element:
| Code: |
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch"."m:text".(XML.CDataSection) =
CAST(ASBITSTREAM(OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch"."SearchXML" OPTIONS FolderBitStream) AS CHARACTER CCSID InputRoot.MQMD.CodedCharSetId ENCODING InputRoot.MQMD.Encoding);
SET OutputRoot.XML."soapenv:Envelope"."soapenv:Body"."m:performSearch"."SearchXML" = NULL; |
|
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Thu Mar 03, 2005 6:02 am Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Thank was perfect!!!! Thank you so much!!!!
And I'm sure you could send this coming from a mile away, but if I was receiving the XML below and needed to process it, how would I get the value in <legCMRCusNum>, for example.
Thanks again!!!
-Lori |
|
| Back to top |
|
|
| JT |
| Posted: Thu Mar 03, 2005 10:36 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
There may be a more elegant solution (perhaps using the ASBITSTREAM function on the PARSE), but here's how I would do it:
| Code: |
DECLARE tempBlobString BLOB CAST(InputRoot.XML."m:performSearch"."m:text" AS BLOB CCSID InputRoot.MQMD.CodedCharSetId);
CREATE FIRSTCHILD OF Environment.Variables Domain('XML') PARSE(tempBlobString);
DECLARE legCMRCusNum INTEGER CAST(Environment.Variables.XML.SearchXML.SearchInput.InputList.legCMRCusNum AS INTEGER); |
|
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Tue Mar 08, 2005 1:28 pm Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
It's me again....
We are trying to extract one of the CDATA fields from the XML below:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<performSearchResponse xmlns="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
<performSearchReturn xsi:type="xsd:string" xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?> <SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd igfElsSearchResponse.xsd"><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><ExtendedHeader>wmq:c3e2d840d5d7c4f04040404040404040bca71486ece47f27|jms:/queue?destination=jms/ICFS/IGFELSSearchResponseIT1I|2005-02-18-09.58.46.711295</ExtendedHeader></SearchXML>]]></performSearchReturn>
</performSearchResponse>
</soapenv:Body>
</soapenv:Envelope>
This is the ESQL we are using:
DECLARE tempBlobString BLOB CAST(InputRoot.XML."soapenv:Envelope"."soapenv:Body"."performSearchResponse"."performSearchReturn" AS BLOB CCSID InputRoot.MQMD.CodedCharSetId);
CREATE FIRSTCHILD OF Environment.Variables Domain('XML') PARSE(tempBlobString);
DECLARE cMRLegSysCtry CHAR CAST(Environment.Variables.XML.SearchXML.SearchOutput.OutputList.cMRLegSysCtry AS CHAR);
However, it is going to our error queue with the following message:
<PREFIX>BIP</PREFIX><REASONCODE>5004</REASONCODE><SEVERITY>E</SEVERITY><DESCRIPTN>An error has been reported by the BIPXML4C component.</DESCRIPTN><DETAIL><INSERTS>1=121, 2=, 3=2, 4=7, 5=The XML or Text declaration must start at line/column 1/1, 6=XML</INSERTS>
Thanks again!!!!
-Lori |
|
| Back to top |
|
|
| JT |
| Posted: Wed Mar 09, 2005 7:04 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
I just successfully tested your ESQL code to extract the 'cMRLegSysCtry' element, although you may want to identify which occurrence of SearchOutput (there are 6 of them) you want.
The BIP5004E error is not related to the ESQL code you posted, it's usually caused by a badly-formed XML message being written to the output queue.
Add a trace node prior to the MQOutput node with the pattern ${Root}. Then post the results here. Also, post the ESQL code that creates the outbound XML message. |
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Wed Mar 09, 2005 9:54 am Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hi,
When I run the following Input XML against ESQL1, it works and I get OUTPUT1, but when I run it against ESQL2, I get ERROR2. I put a trace before MQOutput, but it never gets to that point, so my trace file is empty.
ESQL1:
---------
SET OutputRoot = InputRoot;
SET OutputRoot.XML."soapenv:Envelope"."test" = 'hi';
ESQL2:
--------
DECLARE tempBlobString BLOB CAST(InputRoot.XML."soapenv:Envelope"."soapenv:Body"."performSearchResponse"."performSearchReturn" AS BLOB CCSID InputRoot.MQMD.CodedCharSetId);
CREATE FIRSTCHILD OF Environment.Variables Domain('XML') PARSE(tempBlobString);
DECLARE cMRLegSysCtry CHAR CAST(Environment.Variables.XML.SearchXML.SearchOutput.OutputList.cMRLegSysCtry AS CHAR);
SET OutputRoot = InputRoot;
SET OutputRoot.XML."soapenv:Envelope"."test" = 'hi';
SET OutputRoot.XML."soapenv:Envelope"."test2" = cMRLegSysCtry;
Input XML:
-------------
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<performSearchResponse xmlns="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
<performSearchReturn xsi:type="xsd:string" xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?> <SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd igfElsSearchResponse.xsd"><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><ExtendedHeader>wmq:c3e2d840d5d7c4f04040404040404040bca71486ece47f27|jms:/queue?destination=jms/ICFS/IGFELSSearchResponseIT1I|2005-02-18-09.58.46.711295</ExtendedHeader></SearchXML>]]></performSearchReturn>
</performSearchResponse>
</soapenv:Body>
</soapenv:Envelope>
OUTPUT1:
-----------
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<performSearchResponse xmlns="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
<performSearchReturn xsi:type="xsd:string" xmlns=""><![CDATA[<?xml version="1.0" encoding="UTF-8"?> <SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd igfElsSearchResponse.xsd"><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><ExtendedHeader>wmq:c3e2d840d5d7c4f04040404040404040bca71486ece47f27|jms:/queue?destination=jms/ICFS/IGFELSSearchResponseIT1I|2005-02-18-09.58.46.711295</ExtendedHeader></SearchXML>]]></performSearchReturn>
</performSearchResponse>
</soapenv:Body>
<test>hi</test>
</soapenv:Envelope>
ERROR2:
----------
5004</REASONCODE><SEVERITY>E</SEVERITY><DESCRIPTN>An error has been reported by the BIPXML4C component.</DESCRIPTN><DETAIL><INSERTS>1=22, 2=, 3=1, 4=1, 5=Invalid document structure, 6=XML</INSERTS> |
|
| Back to top |
|
|
| JT |
| Posted: Wed Mar 09, 2005 10:24 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Lori,
I took your ESQL2 code, as is, and pasted into a simple flow. No BIP5004E error. The message on the output queue is:
| Code: |
<?xml version="1.0" encoding="UTF-8" ?>
- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <soapenv:Body soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
- <performSearchResponse xmlns="http://bsi.web.rdc.ibm.com/SRServiceBSI/">
- <performSearchReturn xsi:type="xsd:string" xmlns="">
- <![CDATA[ <?xml version="1.0" encoding="UTF-8"?> <SearchXML xmlns="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://web.rdc.ibm.com/SRServices/IGF/igfElsSearchResponse.xsd igfElsSearchResponse.xsd"><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><SearchOutput><OutputList><cMRLegSysCtry>897</cMRLegSysCtry><centralOrderBlock></centralOrderBlock><customerName>IBM CORP</customerName><customerName2></customerName2><dPLInd>N</dPLInd><legCMRCusNum>5825290</legCMRCusNum><logicalDeleteFlag>N</logicalDeleteFlag><mppId>0011456635</mppId></OutputList><ResultCount>1</ResultCount></SearchOutput><ExtendedHeader>wmq:c3e2d840d5d7c4f04040404040404040bca71486ece47f27|jms:/queue?destination=jms/ICFS/IGFELSSearchResponseIT1I|2005-02-18-09.58.46.711295</ExtendedHeader></SearchXML>
]]>
</performSearchReturn>
</performSearchResponse>
</soapenv:Body>
<test>hi</test>
<test2>897</test2>
</soapenv:Envelope> |
I would recommend you activate the debug trace to gain insight into why and where your flow is failing. |
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Wed Mar 09, 2005 12:20 pm Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
| Do you think I need to be at a certain CSD level???? |
|
| Back to top |
|
|
| JT |
| Posted: Wed Mar 09, 2005 3:52 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
I'm at v5.0.4, but I don't believe your error is related to the maintenance level.
Did you post all of the ESQL code from the Compute node? |
|
| Back to top |
|
|
| DELLIPIZ |
| Posted: Wed Mar 09, 2005 8:37 pm Post subject: |
|
|
Acolyte
Joined: 08 Oct 2003
Posts: 70
|
Hey there,
Yes, that is my whole ESQL.
-Lori |
|
| Back to top |
|
|
|
|
