MQSeries.net :: View topic - EXCEPTION : CATALOG - BIPv610 Number

nimisha.parihar · Posted: Sat Dec 04, 2010 12:03 am Post subject:

Hi,

I am creating a simple XML as follows in the compute Node

CREATE COMPUTE MODULE Learn_HTTP_MF_Compute1
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
CALL CopyMessageHeaders();
DECLARE recordCounter INTEGER;

SET Environment.Variables.Records[] = PASSTHRU( 'select * from tbl_abc where column1= ?',426 );
SET recordCounter = 1;

DECLARE myref REFERENCE TO Environment.Variables.Records[1];

WHILE LASTMOVE(myref)=TRUE DO

SET OutputRoot.XMLNSC.Row[recordCounter].(XMLNSC.Attribute)Item = recordCounter ;
SET OutputRoot.XMLNSC.Row[recordCounter].Col1= myref.Col1;
SET OutputRoot.XMLNSC.Row[recordCounter].Col2= myref.Col2;
SET OutputRoot.XMLNSC.Row[recordCounter].Col3= myref.Col3;
SET OutputRoot.XMLNSC.Row[recordCounter].Col4 = myref.Col4;

SET recordCounter = recordCounter +1;

MOVE myref NEXTSIBLING;
END WHILE;
RETURN TRUE;
END;

But as soon as control moves out of the Compute node i am getting the following error -

ExceptionList
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:957
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmWSInputNode
Name:CHARACTER:Learn_HTTP_MF#FCMComposite_1_1
Label:CHARACTER:Learn_HTTP_MF.HTTP Input
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbMqOutputNode.cpp
Line:INTEGER:910
Function:CHARACTER:ImbMqOutputNode::evaluate
Type:CHARACTER:ComIbmMQOutputNode
Name:CHARACTER:Learn_HTTP_MF#FCMComposite_1_12
Label:CHARACTER:Learn_HTTP_MF.MQOutput
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
ParserException
File:CHARACTER:F:\build\S610_P\src\MTI\MTIforBroker\GenXmlParser4\ImbXMLNSCParser.cpp
Line:INTEGER:737
Function:CHARACTER:ImbXMLNSCParser::refreshBitStreamFromElementsCommon
Type:CHARACTER:ComIbmWSInputNode
Name:CHARACTER:Learn_HTTP_MF#FCMComposite_1_1
Label:CHARACTER:Learn_HTTP_MF.HTTP Input
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:5010
Text:CHARACTER:XML Writing Errors have occurred
ParserException
File:CHARACTER:F:\build\S610_P\src\MTI\MTIforBroker\GenXmlParser4\ImbXMLNSCWriter.cpp
Line:INTEGER:880
Function:CHARACTER:ImbXMLNSCWriter::writeMisc
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:5016
Text:CHARACTER:Unexpected XML type at this point in document.
Insert
Type:INTEGER:5
Text:CHARACTER:Row
Insert
Type:INTEGER:5
Text:CHARACTER:folderType