|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
"Output Message Contains no Data" Exception |
« View previous topic :: View next topic » |
Author |
Message
|
Meow |
Posted: Sun Dec 21, 2003 4:32 pm Post subject: "Output Message Contains no Data" Exception |
|
|
 Voyager
Joined: 25 Jun 2003 Posts: 95
|
Hi Folks,
I am getting "Output Message Contains no Data Exception" Please help me out.
Here is the EXception List:
-- Exception List
(
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbMqOutputNode.cpp'
(0x3000000)Line = 715
(0x3000000)Function = 'ImbMqOutputNode::evaluate'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = 'dafad458-f900-0000-0080-ea3993443c2a'
(0x3000000)Label = 'CCP_Request.Response'
(0x3000000)Text = 'Caught exception and rethrowing'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S210_P\src\DataFlowEngine\ImbMqOutputNode.cpp'
(0x3000000)Line = 576
(0x3000000)Function = 'ImbMqOutputNode::evaluate'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = 'dafad458-f900-0000-0080-ea3993443c2a'
(0x3000000)Label = 'CCP_Request.Response'
(0x3000000)Text = 'Message contains no data'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2617
)
)
)
Here is the ESQL Code
DECLARE Stmt CHAR;
DECLARE CARD INTEGER;
SET Stmt = Environment.Variables.Query.Statement;
--SET Environment.Variables.Statement = Stmt;
IF ((Stmt IS NOT NULL)) THEN
EVAL ('SET Environment.Variables.Query.Response[] =
(SELECT T.* FROM Database.T1 AS T '||' '||Stmt||')');
SET CARD = CARDINALITY(Environment.Variables.Query.Response[]);
DECLARE Pnumber CHAR;
SET Pnumber = CAST (Environment.Variables.Query.Response[1]."OMCH_CLM_NB" AS CHAR);
SET OutputRoot.XML.Query.Response = Environment.Variables.Query.Response[1]."OMCH_CLM_NB";
END IF;
Here is the Text from the User Trace...
2003-12-21 19:22:12.194999 319 UserTrace BIP2537I: Node 'CCP_Request.Compute1': Executing statement 'DECLARE Pnumber CHARACTER;' at (21, 1).
2003-12-21 19:22:12.194999 319 UserTrace BIP2537I: Node 'CCP_Request.Compute1': Executing statement 'SET Pnumber = CAST(Environment.Variables.Query.Response[1].OMCH_CLM_NB AS CHARACTER);' at (22, 1).
2003-12-21 19:22:12.194999 319 UserTrace BIP2538I: Node 'CCP_Request.Compute1': Evaluating expression 'CAST(Environment.Variables.Query.Response[1].OMCH_CLM_NB AS CHARACTER)' at (22, 15).
2003-12-21 19:22:12.194999 319 UserTrace BIP2538I: Node 'CCP_Request.Compute1': Evaluating expression 'Environment.Variables.Query.Response[1].OMCH_CLM_NB' at (22, 21).
2003-12-21 19:22:12.194999 319 UserTrace BIP2539I: Node 'CCP_Request.Compute1': Finished evaluating expression 'CAST(Environment.Variables.Query.Response[1].OMCH_CLM_NB AS CHARACTER)' at (22, 15). This resolved to 'CAST('B12501 ' AS CHARACTER )'. The result was ''B12501 ''.
2003-12-21 19:22:12.194999 319 UserTrace BIP2537I: Node 'CCP_Request.Compute1': Executing statement 'SET OutputRoot.XML.Query.Response = Environment.Variables.Query.Response[1].OMCH_CLM_NB;' at (23, 1).
2003-12-21 19:22:12.194999 319 UserTrace BIP2538I: Node 'CCP_Request.Compute1': Evaluating expression 'Environment.Variables.Query.Response[1].OMCH_CLM_NB' at (23, 37).
2003-12-21 19:22:12.194999 319 UserTrace BIP2568I: Node 'CCP_Request.Compute1': Performing tree copy of '' to 'OutputRoot.XML.Query.Response'.
2003-12-21 19:22:12.194999 319 UserTrace BIP4124I: Message propagated to 'out' terminal of compute node 'CCP_Request.Compute1'.
2003-12-21 19:22:12.194999 319 UserTrace BIP2231E: Error detected whilst processing a message 'CCP_Request.Request'.
The message broker detected an error whilst processing a message in node 'CCP_Request.Request'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.
2003-12-21 19:22:12.194999 319 RecoverableException BIP2230E: Error detected whilst processing a message in node 'CCP_Request.Response'.
The message broker detected an error whilst processing a message in node 'CCP_Request.Response'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.
2003-12-21 19:22:12.194999 319 RecoverableException BIP2617E: Output message is empty; output node 'CCP_Request.Response'.
The MQSeries output node 'CCP_Request.Response' has received a message to write to an MQSeries output queue, but the message appears to be empty. This error may be generated when 1) there is no MQMD and no message content in the output bitstream (there really is no data) or 2) there is no MQMD and the size of the message content is less that the size of the MQMD (it appears there is no content). This situation can occur when a output message is built incorrectly using the Compute node.
Check the message flow to determine whether the message is being built correctly. If not, correct the problem and redeploy the broker.
I checked it and could not find the problem . Please help me out.
Thanks,
Paruvan |
|
Back to top |
|
 |
EddieA |
Posted: Sun Dec 21, 2003 5:52 pm Post subject: |
|
|
 Jedi
Joined: 28 Jun 2001 Posts: 2453 Location: Los Angeles
|
Please do NOT post multiple times for the same question. If you wish to add more information, add it to the same thread.
Are you copying the Message Headers. Have you 'trimmed' the ESQL and Trace to show only what you put in the Compute node, and removed the 'generated' code.
Cheers, _________________ Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
Back to top |
|
 |
Meow |
Posted: Sun Dec 21, 2003 6:22 pm Post subject: |
|
|
 Voyager
Joined: 25 Jun 2003 Posts: 95
|
Hi ,
Sorry for posting multiple times.
Eddie:
Here is the context in the Trace file after the compute node:
Root : (
(0x1000000)Properties = (
(0x3000000)MessageSet = ''
(0x3000000)MessageType = ''
(0x3000000)MessageFormat = ''
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2003-12-22 02:06:36.280'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000010)XML = (
(0x1000000)Query = (
(0x1000000)Response = (
(0x2000000) = 'B12501 '
)
)
)
)
ExceptionList :
Environment Variables : (
(0x1000000)Values = (
(0x3000000)fields = 'Contract Number'
)
(0x1000000)Query = (
(0x3000000)Statement = 'WHERE T.OMCH_MBR_CTC_NB = 'A12345701' '
(0x1000000)Response = (
(0x3000000)OMCH_MBR_CTC_NB = 'A12345701 '
(0x3000000)OMCH_CLM_NB = 'B12501 '
(0x3000000)OMCH_CLM_OGN_CD = '4'
(0x3000000)OMCH_CNBR_CD = '09'
(0x3000000)OMCH_PCSD_DT = DATE '1995-01-01'
(0x3000000)OMCH_SVC_BGN_DT = DATE '1994-01-01'
(0x3000000)OMCH_SVC_END_DT = DATE '1997-01-01'
(0x3000000)OMCH_SOFO_ID = 'A00001'
(0x3000000)OMCH_ENTD_PGST_CD = 'CRY'
(0x3000000)OMCH_ENTD_PYTT_CD = 'PTA'
(0x3000000)OMCH_ENTD_HSRN_CD = 'PNMUI'
(0x3000000)OMCH_ENTD_REJ_CD = 'EEEEE'
(0x3000000)OMCH_REJ_CD = 'FFFFF'
(0x3000000)OMCH_ODS_CMTP_CD = 'P'
(0x3000000)OMCH_PVAN_NB = 'ABCDEFGHIJKLMNO'
(0x3000000)OMCH_PVDR_IDNN_NB = 1234567
(0x3000000)OMCH_PVDR_NM = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'
(0x3000000)OMCH_LOB_CD = 'HMO '
(0x3000000)OMCH_PTNT_SXR_CD = 'CC'
(0x3000000)OMCH_PTNT_LAST_NM = 'DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD'
(0x3000000)OMCH_P1ST_NM = 'EEEEEEEEEEEEEEEEEEEEEEEEEEEEEE'
(0x3000000)OMCH_PTNT_MIIN_NM = 'FFFFFFFFFFFFFFFFFFFFFFFFF'
(0x3000000)OMCH_PTBT_DT = DATE '1998-01-01'
(0x3000000)OMCH_PTGD_CD = '4'
(0x3000000)OMCH_TOT_DEDB_1_AM = 100.00
(0x3000000)OMCH_TOT_PYMT_AM = 200.00
(0x3000000)OMCH_TOT_CGE_AM = 300.00
(0x3000000)OMCH_TOT_ALWD_AM = 400.00
(0x3000000)OMCH_MBRY_AM = 500.00
(0x3000000)OMCH_TOT_CPAY_AM = 600.00
(0x3000000)OMCH_RCI_DT = DATE '1999-12-31'
(0x3000000)OMCH_GP_IDNN_NB = 'AAAAAAAAAAAAAAAAA'
(0x3000000)OMCH_WHCL_RVRL_IN = 'B'
(0x3000000)OMCH_POSTED_ID = 'CCCCCCCC'
(0x3000000)OMCH_RBMS_MBR_NB = '01'
(0x3000000)OMCH_MHS_PRS_NB = '22'
(0x3000000)OMCH_DMND_RLTS_CD = 'FF'
(0x3000000)OMCH_MLRC_NB = 'GGGGGGGGGGGGGGGGG'
(0x3000000)OMCH_BLPV_1ST_NM = 'HHHHHHHHHHHHHHHHHHHHHHHHH'
(0x3000000)OMCH_BLPV_MIDL_NM = 'IIIIIIIIIIIIIIIIIIIIIIIII'
(0x3000000)OMCH_BLPV_LAST_NM = 'JJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJ'
(0x3000000)OMCH_SUBR_SRCT_NB = '* please do not use *'
(0x3000000)OMCH_SUBR_BTH_DT = DATE '2003-12-23'
(0x3000000)OMCH_SUBR_GNDR_CD = '4'
(0x3000000)OMCH_SUBR_1ST_NM = 'P '
(0x3000000)OMCH_SUBR_MIDL_NM = 'K '
(0x3000000)OMCH_SUBR_LAST_NM = 'T '
(0x3000000)OMCH_LOS_1_CD = 'AAAAA'
(0x3000000)OMCH_PAID_DT = DATE '2005-12-31'
(0x3000000)OMCH_CHK_NB = 'P '
(0x3000000)OMCH_ALPP_CD = '* please do not use *'
(0x3000000)OMCH_CLM_BLTY_CD = 'LLL'
(0x3000000)OMCH_BLPV_IDNN_NB = 'MMMMMMMMMMMMMMM'
(0x3000000)OMCH_ACTL_CLM_NB = 'NNNNNNNNNNNNNNNN'
(0x3000000)OMCH_HOST_PVDR_NB = 'OOOOOOOOOOOOO'
(0x3000000)OMCH_HOST_PLN_CD = 'ZZZZ'
(0x3000000)OMCH_HOPL_CLM_NB = 'WWWWWWWWWWWWWWWWW'
(0x3000000)OMCH_FED_TXID_NB = 'XXXXXXXXXXXXXXX'
(0x3000000)OMCH_ITS_SRL_NB = 'RRRRRRRRRRRRRRRRR'
)
)
)
Also it shows the same message as i have posted above in the user trace.
I did not get what you meant by "Trimmed". and i am copying my message headers.
Thanks
Paruvan |
|
Back to top |
|
 |
fitzcaraldo |
Posted: Sun Dec 21, 2003 6:36 pm Post subject: |
|
|
Voyager
Joined: 05 May 2003 Posts: 98
|
The output message has no MQMD by the look of it. This can happen if the incoming message has no body and you click on "Copy Message Headers".
If you look at the Copy Message Headers code snippet you will see it copies all but the last child of InputRoot. If the input message has no body, then the last child is the MQMD.
Ensure that the input message actually has a payload. |
|
Back to top |
|
 |
Meow |
Posted: Sun Dec 21, 2003 8:32 pm Post subject: |
|
|
 Voyager
Joined: 25 Jun 2003 Posts: 95
|
It worked.
Thanks alot. Here is what i did
subflow Compute node : copy entire message
Mainflow Compute node : Copy only the headers.
It worked fine.
Special Thanks to Fitzcaraldo & Eddie. thank you so much for being so helpful.. |
|
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
|
|
|
|