Abend : XML output stage to MQ plug in
Posted: Tue Sep 11, 2007 10:32 am
Hi,
I have a need to implement the following process:
Read XML from MQ( MQ Plug in) --> XML Transformer stage -->XML input stage -->Couple of look up stages --> XML Output stage --> write to MQ(MQ Plug in)
The issue I am having is when give MQ plug-in as Output from XML output stage I get the errors ( mentioned below). I get the same error when I use the output link ( draw a link ) from 'XML output stage ' and write to a file. This error DOES NOT happen if I write to a file by specifying file name in 'Stage- Options' tab of 'XML output stage' ( I do not specify the O/p structure nor have the option to specify in this case).
1. It seems that I can not use output link in 'XML output stage' is that true?
2. How do I write the XML from XML output stage to MQ directly, rather that writing to file first and writing the file to MQ ?
3. I have my Xpath in description fileld in 'input - columns' tab and I am defining single field of Varchar(99999) of 'data element' 'XML' when I have a output link. Is this how I have to define the output link structure ?
The error I am getting are:
Warnings:
XML_Output_117,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/@MessageId" is invalid. Message = "The input rule does not map to any output rule "
....
< repeated same for all the xpaths in 'XML output' stge. >
XML_Transformer_131,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/ListOfPhOrderIntegrationBo-IntObj/OrderEntry-Orders/ListOfOrderEntry-LineItems/OrderEntry-LineItems/Status/text()" is invalid. Message = "The input rule does not map to any output rule "
Create_Order_From_Siebel,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/ListOfPhOrderIntegrationBo-IntObj/OrderEntry-Orders/ListOfOrderEntry-LineItems/OrderEntry-LineItems/Status/text()" is invalid. Message = "The input rule does not map to any output rule "
XML_Output_117,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
Create_Order_From_Siebel,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
XML_Transformer_131,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
XML_Output_117,0: Error: None of the output link columns could be selected as target for the XML output.
Convert_to_Flat,0: Error: None of the output link columns could be selected as target for the XML output.
XML_Transformer_131,0: Error: None of the output link columns could be selected as target for the XML output.
Create_Order_From_Siebel,0: Error: None of the output link columns could be selected as target for the XML output.
Errors:
XML_Output_117,0: The runLocally() of the operator failed.
XML_Output_117,0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: Operator terminated abnormally: runLocally did not return APT_StatusOk
Thank you,
Joffi Joy.
I have a need to implement the following process:
Read XML from MQ( MQ Plug in) --> XML Transformer stage -->XML input stage -->Couple of look up stages --> XML Output stage --> write to MQ(MQ Plug in)
The issue I am having is when give MQ plug-in as Output from XML output stage I get the errors ( mentioned below). I get the same error when I use the output link ( draw a link ) from 'XML output stage ' and write to a file. This error DOES NOT happen if I write to a file by specifying file name in 'Stage- Options' tab of 'XML output stage' ( I do not specify the O/p structure nor have the option to specify in this case).
1. It seems that I can not use output link in 'XML output stage' is that true?
2. How do I write the XML from XML output stage to MQ directly, rather that writing to file first and writing the file to MQ ?
3. I have my Xpath in description fileld in 'input - columns' tab and I am defining single field of Varchar(99999) of 'data element' 'XML' when I have a output link. Is this how I have to define the output link structure ?
The error I am getting are:
Warnings:
XML_Output_117,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/@MessageId" is invalid. Message = "The input rule does not map to any output rule "
....
< repeated same for all the xpaths in 'XML output' stge. >
XML_Transformer_131,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/ListOfPhOrderIntegrationBo-IntObj/OrderEntry-Orders/ListOfOrderEntry-LineItems/OrderEntry-LineItems/Status/text()" is invalid. Message = "The input rule does not map to any output rule "
Create_Order_From_Siebel,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Derivation rule "/SiebelMessage/ListOfPhOrderIntegrationBo-IntObj/OrderEntry-Orders/ListOfOrderEntry-LineItems/OrderEntry-LineItems/Status/text()" is invalid. Message = "The input rule does not map to any output rule "
XML_Output_117,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
Create_Order_From_Siebel,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
XML_Transformer_131,0: Warning: Yantra_to_Siebel_Order_Status_G.XML_Output_117: Column "XML_OP" is neither a pass-through column nor an XML data source.
XML_Output_117,0: Error: None of the output link columns could be selected as target for the XML output.
Convert_to_Flat,0: Error: None of the output link columns could be selected as target for the XML output.
XML_Transformer_131,0: Error: None of the output link columns could be selected as target for the XML output.
Create_Order_From_Siebel,0: Error: None of the output link columns could be selected as target for the XML output.
Errors:
XML_Output_117,0: The runLocally() of the operator failed.
XML_Output_117,0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: The runLocally() of the operator failed.
APT_CombinedOperatorController(0),0: Operator terminated abnormally: runLocally did not return APT_StatusOk
Thank you,
Joffi Joy.