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 IndexWebSphere Message Broker SupportMQGet Node

Post new topicReply to topic
MQGet Node View previous topic :: View next topic
Author Message
soudhanya
PostPosted: Tue Mar 13, 2018 11:49 am Post subject: MQGet Node Reply with quote

Novice

Joined: 27 Feb 2017
Posts: 15

I am trying to delete message from queue using MQGET node..

Here are the flow details

HttpInput->Compute->MQGET->HttpReply

In my first flow i am trying to retrieve msgid using browseonly option and in second flow im passing msgid to delete that particular message..

SET OutputRoot.MQMD.MsgId = '414d512045534251413031514d2020205aa22b9320abac76';

Did i miss any thing?.. it is throwing excpetion.. Any help??
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Tue Mar 13, 2018 12:04 pm Post subject: Re: MQGet Node Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25361
Location: Ohio, USA

soudhanya wrote:
In my first flow i am trying to retrieve msgid using browseonly option and in second flow im passing msgid to delete that particular message..


This sounds like a massively inefficient design.

soudhanya wrote:
it is throwing excpetion.. Any help??


Perhaps if you told us more about the exception. Like the error text. Or which node is throwing the exception. Or what the other flow looks like (you mention 2 and post details of 1).

If you want me to guess, one possible scenario is:

- User A makes HTTP call, obtains message
- User B makes HTTP call, obtains the same message because nothing's read it off.
- User A processes message, calls 2nd flow to delete message
- User B processes message (duplicating whatever results from the message processing), calls 2nd flow to delete message which throws an exception because User A has deleted it already.

Other scenarios from this very odd design are possible.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
soudhanya
PostPosted: Tue Mar 13, 2018 12:21 pm Post subject: Reply with quote

Novice

Joined: 27 Feb 2017
Posts: 15

So.. ok.. It was my bad.. i would be more clear of asking question..


I have 2 operations: Retrieve and Remove

User A makes HTTP call to retrieve the message.. i selected browse only option.
So its only read..in response i am also sending back msgid.

2.Once the first call was success.. User A makes HTTP call to remove the message..using the msgid

Here is the exception:

ExceptionList
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp
Line:INTEGER:1138
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQGetNode
Name:CHARACTER:Sample1#FCMComposite_1_6
Label:CHARACTER:Sample1.MQ Get
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
Insert
Type:INTEGER:14
Text:CHARACTER:Sample1.MQ Get
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/ImbMqGetNode.cpp
Line:INTEGER:1705
Function:CHARACTER:ImbMqGetNode::failureProcess
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:4633
Text:CHARACTER:MQGet node Exception
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/DataFlowEngine/ImbMqGetNode.cpp
Line:INTEGER:1964
Function:CHARACTER:ImbMqGetNode::writeMqmd
Type:CHARACTER:ComIbmMQGetNode
Name:CHARACTER:Sample1#FCMComposite_1_6
Label:CHARACTER:Sample1.MQ Get
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:2
Number:INTEGER:5912
Text:CHARACTER:Exception whilst writing field named
Insert
Type:INTEGER:5
Text:CHARACTER:MQMD
Insert
Type:INTEGER:5
Text:CHARACTER:MsgId
Insert
Type:INTEGER:5
Text:CHARACTER:414d512045534251413031514d2020205aa22b9320abac76
RecoverableException
File:CHARACTER:/build/slot1/S800_P/src/CommonServices/ImbValue.cpp
Line:INTEGER:983
Function:CHARACTER:ImbValue::typeError
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2328
Text:CHARACTER:Wrong type exception
Insert
Type:INTEGER:5
Text:CHARACTER:CHARACTER
Insert
Type:INTEGER:5
Text:CHARACTER:BLOB
Back to top
View user's profile Send private message Send e-mail
fjb_saper
PostPosted: Tue Mar 13, 2018 2:10 pm Post subject: Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19820
Location: LI,NY

This tells you all you need to know
Code:
Text:CHARACTER:Wrong type exception
Insert
Type:INTEGER:5
Text:CHARACTER:CHARACTER
Insert
Type:INTEGER:5
Text:CHARACTER:BLOB


And check your code. Looks like you forgot a 0x somewhere...

Have fun.
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
abhi_thri
PostPosted: Wed Mar 14, 2018 1:29 am Post subject: Reply with quote

Master

Joined: 17 Jul 2017
Posts: 236
Location: UK

Code:
SET OutputRoot.MQMD.MsgId = '414d512045534251413031514d2020205aa22b9320abac76';


Are you using the above statement in your code? If so that is assigning char value to MsgId which expects blob instead.

To assign blob use the below one

Code:
SET OutputRoot.MQMD.MsgId = X'414d512045534251413031514d2020205aa22b9320abac76';
Back to top
View user's profile Send private message
Vitor
PostPosted: Wed Mar 14, 2018 5:12 am Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 25361
Location: Ohio, USA

soudhanya wrote:

I have 2 operations: Retrieve and Remove

User A makes HTTP call to retrieve the message.. i selected browse only option.
So its only read..in response i am also sending back msgid.

2.Once the first call was success.. User A makes HTTP call to remove the message..using the msgid


And aside from the comment of my worthy associate, what prevents User B retrieving the same message between these 2 operations?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportMQGet Node
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.