| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL type UNKNOW error message. Unable to determine cause |
« View previous topic :: View next topic » |
| Author |
Message
|
| smeunier |
 Posted: Mon Nov 22, 2004 1:16 pm Post subject: SQL type UNKNOW error message. Unable to determine cause |
 |
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
I'm getting the following error when creating an output message. There are no warning or errors durning message creation time that I can tell. This error message indicated other message will follow to pinpoint the problem, but none do: Any idea on what to look for?
| Code: |
The value of SQL datatype UNKNOWN was encountered, but a value of SQL datatype CHARACTER was expected.
This message will be accompanied with others which will give the higher level context for this error. Look at these other messages to determine the root source of the problem. |
Any help appreciated |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Nov 23, 2004 12:19 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can you sahre other messages with us? Also, it seems you are trying to create your output message from a resultset? Can you post your ESQL code?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| smeunier |
| Posted: Tue Nov 23, 2004 10:05 am Post subject: Reply |
|
|
Partisan
Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont
|
Kiran,
Here is the ESQL. I commented out a large section, to try to weed out the possible error. The inbound message comes from a WBI mySAP.com adapter, which is a Business Object XML formatted message. I have listed the error messages from the trace below the XML
| Code: |
DECLARE C INTEGER;
SET C = CARDINALITY(InputRoot.*[]);
DECLARE I INTEGER;
SET I = 1;
WHILE I < C DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I=I+1;
END WHILE;
-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.
DECLARE EventMsg CHARACTER;
DECLARE IDOC_Name CHARACTER;
DECLARE RefToCtrl REFERENCE TO InputBody.Control_record."MD_SAP_BO_sap_idoccontrol:MD_SAP_BO_sap_idoccontrol";
DECLARE RefToLvl1 REFERENCE TO InputBody.Data_record."MD_SAP_BO_zcpaor01_cwdata:MD_SAP_BO_zcpaor01_cwdata"."MD_SAP_BO_zcpaor01_cwdata:MD_SAP_BO_zcpaor01_z2cokor"."MD_SAP_BO_zcpaor01_z2cokor:MD_SAP_BO_zcpaor01_z2cokor";
DECLARE RefToLvl2 REFERENCE TO InputBody.Data_record."MD_SAP_BO_zcpaor01_cwdata:MD_SAP_BO_zcpaor01_cwdata"."MD_SAP_BO_zcpaor01_cwdata:MD_SAP_BO_zcpaor01_z2cokor"."MD_SAP_BO_zcpaor01_z2cokor:MD_SAP_BO_zcpaor01_z2cokor"."MD_SAP_BO_zcpaor01_z2cokor:MD_SAP_BO_zcpaor01_z2copor"."MD_SAP_BO_zcpaor01_z2copor:MD_SAP_BO_zcpaor01_z2copor";
DECLARE Level1_CTR INTEGER;
DECLARE Level2_CTR INTEGER;
DECLARE Level2_CNT INTEGER;
DECLARE Total_Segment_CTR INTEGER;
SET IDOC_Name = 'ZCPAOR01';
SET Total_Segment_CTR = 0;
SET Level1_CTR = 1;
SET Level2_CTR = 1;
SET Level2_CNT = CARDINALITY(RefToLvl2);
-- Create transformed WBIA IDOC BO to Z_SAP_ACTIVITY_REPORT XML
--SET OutputRoot.Properties = InputRoot.Properties;
--SET OutputRoot.Properties.MessageFormat='XML';
SET OutputRoot.MQMD = InputRoot.MQMD;
SET OutputRoot.MQMD.Format = 'MQSTR ';
-- Remove MQRFH2 Header as it is not needed
SET OutputRoot.MQRFH2 = NULL;
/*
-- Create IDOC Control Record
SET OutputRoot.IDOC.DC.tabnam = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Name_of_table_structure";
SET OutputRoot.IDOC.DC.mandt = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Client";
SET OutputRoot.IDOC.DC.docnum = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_number";
SET OutputRoot.IDOC.DC.docrel = RefToCtrl."MD_SAP_BO_sap_idoccontrol:SAP_Release_for_IDoc";
SET OutputRoot.IDOC.DC.status = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Status_of_IDoc";
SET OutputRoot.IDOC.DC.direct = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Direction_for_IDoc_transmission";
SET OutputRoot.IDOC.DC.outmod = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Output_mode";
SET OutputRoot.IDOC.DC.exprss = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Overriding_in_inbound_processing";
SET OutputRoot.IDOC.DC.test = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Test_flag";
SET OutputRoot.IDOC.DC.idoctyp = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Name_of_basic_type";
SET OutputRoot.IDOC.DC.clmtyp = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Extension";
SET OutputRoot.IDOC.DC.mestyp = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Logical_message_type";
SET OutputRoot.IDOC.DC.mescod = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Logical_message_code";
SET OutputRoot.IDOC.DC.mesfct = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Logical_message_function";
SET OutputRoot.IDOC.DC.std = RefToCtrl."MD_SAP_BO_sap_idoccontrol:EDI_standard";
SET OutputRoot.IDOC.DC.stdvrs = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Version_of_EDI_standard";
SET OutputRoot.IDOC.DC.stdmes = RefToCtrl."MD_SAP_BO_sap_idoccontrol:EDI_message_type";
SET OutputRoot.IDOC.DC.sndpor = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Sender_port";
SET OutputRoot.IDOC.DC.sndprt = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_type_of_sender";
SET OutputRoot.IDOC.DC.sndpfc = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_function_of_sender";
SET OutputRoot.IDOC.DC.sndprn = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_number_of_sender";
SET OutputRoot.IDOC.DC.sndsad = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_SADR_fields_in_total_Sender";
SET OutputRoot.IDOC.DC.sndlad = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Logical_address_of_sender";
SET OutputRoot.IDOC.DC.rcvpor = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Receiver_port";
SET OutputRoot.IDOC.DC.rcvprt = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_type_of_recipient";
SET OutputRoot.IDOC.DC.rcvpfc = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_function_of_recipient";
SET OutputRoot.IDOC.DC.rcvprn = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Partner_number_of_recipient";
SET OutputRoot.IDOC.DC.rcvsad = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_SADR_fields_in_total";
SET OutputRoot.IDOC.DC.rcvlad = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Logical_address_of_recipient";
SET OutputRoot.IDOC.DC.credat = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_creation_date";
SET OutputRoot.IDOC.DC.cretim = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_creation_time";
SET OutputRoot.IDOC.DC.refint = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Reference_to_interchange_file";
SET OutputRoot.IDOC.DC.refgrp = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Reference_to_message_group";
SET OutputRoot.IDOC.DC.refmes = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Reference_to_message";
SET OutputRoot.IDOC.DC.arckey = RefToCtrl."MD_SAP_BO_sap_idoccontrol:EDI_archive_key";
SET OutputRoot.IDOC.DC.serial = RefToCtrl."MD_SAP_BO_sap_idoccontrol:EDI_ALE_Serialization_field";
SET Total_Segment_CTR = Total_Segment_CTR + 1;
-- Build Control RecordHeader XML Node
SET OutputRoot.IDOC.DD[Total_Segment_CTR].segnam = 'Z2COKOR';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].mandt = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Client";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].docnum = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_number";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].segnum = '000001';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].psgnum = '000000';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].hlevel = '01';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.aufnr = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:AUFNR";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.ordertype = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:ORDERTYPE";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.plant = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PLANT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.productid = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PRODCUTID";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.ec = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:EC";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.lotlabel = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LOTLABEL";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.other_lot_label1 = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:OTHER_LOT_LABEL1";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.orderqty = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:ORDERQTY";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.customercd = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:CUSTOMERCD";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.srcevendor = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:SRCVENDOR";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.waferid = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:WAFERID";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.lotowner = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LOTOWNER";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.lottype = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LOTTYPE";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.prty = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PRTY";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.planstart = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PLANSTART";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.planfinish = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PLANFINISH";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.linecodejc = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LINECODEJC";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.qualitycod = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:QUALITYCOD";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.poi = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:POI";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.poi_text = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:POI_TEXT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.cot = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:COT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.cot_text = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:COT_TEXT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.lotprodtyp = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LOTPRODTYP";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.productcd = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:PRODUCTCD";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.familycd = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:FAMILYCD";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.lot_cmmnt = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:LOT_CMMNT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.devassem = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:DEVASSEM";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.devassemtx = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:DEVASSMTX";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.numdevices = RefToLvl1."MD_SAP_BO_zcpaor01_z2cokor:NUMDEVICES";
-- Build Detail XML Node
WHILE Level2_CTR <= Level2_CNT DO
SET Total_Segment_CTR = Total_Segment_CTR + 1;
SET OutputRoot.IDOC.DD[Total_Segment_CTR].segnam = 'Z2COPOR';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].mandt = RefToCtrl."MD_SAP_BO_sap_idoccontrol:Client";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].docnum = RefToCtrl."MD_SAP_BO_sap_idoccontrol:IDoc_number";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].segnum = '000001';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].psgnum = '000000';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].hlevel = '01';
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.SOURCELOT = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:SOURCELOT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.SRCEPRODID = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:SRCEPRODID";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.ec = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:EC";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.qty = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:QTY";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.srcevendor = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:SRCEVENDOR";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.waferid = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:WAFERID";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.linecodejc = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:LINECODEJC";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.qualitycod = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:QUALITYCOD";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.devpoi = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:DEVPOI";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.devpoitxt = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:DEVPOITXT";
SET OutputRoot.IDOC.DD[Total_Segment_CTR].sdatatag.MRM.date_of_mfg = RefToLvl2."MD_SAP_BO_zcpaor01_z2copor:DATE_OF_MFG";
SET Level2_CTR = Level2_CTR + 1;
END WHILE;
-- Send message to ASMView for processing via label node
SET OutputLocalEnvironment.Destination.RouterList.DestinationData[1].labelname = IDOC_Name;
PROPAGATE;
*/
-- Create new MQ message for logging purposes
SET OutputRoot.Properties = InputRoot.Properties;
SET OutputRoot.Properties.MessageFormat='XML';
SET OutputRoot.MQMD = InputRoot.MQMD;
SET OutputRoot.MQMD.Format = 'MQSTR ';
-- Remove MQRFH2 Header as it is not needed
SET OutputRoot.MQRFH2 = NULL;
-- Copy only Control Record for message logging
SET OutputLocalEnvironment.Variables.Event.Log = IDOC_Name;
SET OutputLocalEnvironment.Variables.Event.MsgLevel = 'I';
SET OutputLocalEnvironment.Variables.Event.Msg =
IDOC_Name||'( '
|| RefToCtrl.IDoc_number
|| ' ) received on '
||InputRoot.MQMD.SourceQueue
||' queue with '
|| CAST(Total_Segment_CTR as CHARACTER)
||' segments. Transformation to simplified XML is complete';
-- Identify label for message routing
SET OutputLocalEnvironment.Destination.RouterList.DestinationData[1].labelname = 'MD_SAP_EVENTS';
PROPAGATE;
RETURN FALSE;
|
| Code: |
The MQCC was 0 and the MQRC was 0.
2004-11-22 16:40:34.715000 3300 UserTrace BIP2622I: Message successfully output by MQ output node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.MD_SAP.EVENTS Queue' to queue 'MD_SAP.EVENTS' on queue manager ''.
2004-11-22 16:40:34.715000 3300 UserTrace BIP4101I: Exception thrown by throw node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback'.
The throw node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback' has received a message and will throw an exception as this is its normal behavior.
No user action required.
2004-11-22 16:40:34.715000 3300 Error BIP2232E: Error detected whilst handling a previous error in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback'.
The message broker has detected an error in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback' whilst handling a previous error.
See the following messages for details of the exception list associated with the original error. Thereafter messages will be associated with the new error.
2004-11-22 16:40:34.715000 3300 RecoverableException BIP2230E: Error detected whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.BO To XML Transformer'.
The message broker detected an error whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.BO To XML Transformer'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2004-11-22 16:40:34.715000 3300 RecoverableException BIP2230E: Error detected whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH_OUT Queue'.
The message broker detected an error whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH_OUT Queue'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2004-11-22 16:40:34.715000 3300 RecoverableException BIP2328E: A value of SQL datatype 'UNKNOWN' encountered when datatype 'CHARACTER' expected.
The value of SQL datatype UNKNOWN was encountered, but a value of SQL datatype CHARACTER was expected.
This message will be accompanied with others which will give the higher level context for this error. Look at these other messages to determine the root source of the problem.
2004-11-22 16:40:34.715000 3300 Error BIP2628E: Exception condition detected on input node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH Queue'.
The input node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH Queue' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Check the error messages which follow to determine why the exception was generated, and take action as described by those messages.
2004-11-22 16:40:34.715000 3300 RecoverableException BIP2230E: Error detected whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.MD_SAP.EVENTS Queue'.
The message broker detected an error whilst processing a message in node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.MD_SAP.EVENTS Queue'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2004-11-22 16:40:34.715000 3300 UserException BIP3001I: Exception thrown by throw node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback'; text is ''.
The throw node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.Exception Handler.Throw to complete rollback' has received a message and thus has thrown an exception as this is its normal behavior. The message text associated with this exception is ''.
Since this is application generated (by message flow behavior), the user action is determined by the message flow and the type of exception generated.
2004-11-22 16:40:35.715999 3300 UserTrace BIP2631I: Backed out message being propagated to failure terminal; node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH Queue'.
Node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.RUBBISH Queue' has received a message which has previously been backed out because of a processing error in the message flow. The MQMD 'backoutCount' of the message exceeds (or equals) the 'backoutThreshold' defined for the MQSeries input queue. The message broker is propagating the message to the failure terminal of the node.
Examine the other messages and the message flow to determine why the message is being backed out. Correct this situation if possible. Perform any local error recovery processing required.
2004-11-22 16:40:35.945999 3300 UserTrace BIP2638I: The MQ output node 'MD_SAP MessageFlow ZCPAOR01 BO To IDOC Transformer.MD_SAP.WBIMB.BTVASM.DLQ Queue' attempted to write a message to the specified queue 'MD_SAP.WBIMB.BTVASM.DLQ' connected to queue manager ''. The MQCC was 0 and the MQRC was 0.
|
|
|
| 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
|
|
|
|
