ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » "Output Message Contains no Data" Exception

Post new topic  Reply to topic
 "Output Message Contains no Data" Exception « View previous topic :: View next topic » 
Author Message
Meow
PostPosted: Sun Dec 21, 2003 4:32 pm    Post subject: "Output Message Contains no Data" Exception Reply with quote

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
View user's profile Send private message
EddieA
PostPosted: Sun Dec 21, 2003 5:52 pm    Post subject: Reply with quote

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
View user's profile Send private message
Meow
PostPosted: Sun Dec 21, 2003 6:22 pm    Post subject: Reply with quote

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
View user's profile Send private message
fitzcaraldo
PostPosted: Sun Dec 21, 2003 6:36 pm    Post subject: Reply with quote

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
View user's profile Send private message
Meow
PostPosted: Sun Dec 21, 2003 8:32 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » "Output Message Contains no Data" Exception
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.