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 » Handling a large message

Post new topic  Reply to topic
 Handling a large message « View previous topic :: View next topic » 
Author Message
SANTYP
PostPosted: Tue Sep 21, 2010 11:19 pm    Post subject: Handling a large message Reply with quote

Centurion

Joined: 27 Mar 2007
Posts: 142

Hi Gurus,

I have a problem while handling the message from a stored procedure...

my flow is simple..
mqinput node --> compute node ..> Mq Reply node

in the compute node I am calling an oracle storedprocedure.. which will result a largestring (typically 5mb message)
which is of simple xmlstring.
after calling the procedure... i am not getting any response...
(I am executing the procedure in toad it is talking 1-2mins to give the result so I am waiting min before doing step over in the broker)

I am forcefully killing the broker process.. the thread is getting hanged...

suggest me what would be possible issue..

Thanks in advance..
Back to top
View user's profile Send private message
francoisvdm
PostPosted: Sun Sep 26, 2010 8:53 pm    Post subject: Reply with quote

Partisan

Joined: 09 Aug 2001
Posts: 332

Try and return a smaller message from stored procedure, if that works, make the return message progressively bigger and see if you csn pick up a pattern....maybe you are just running out of time.....or, maybe the message is just too big. If size is the problem, you are lucky because you can control the stored procedure.... return a subset of the data. If time is the problem....just wait longer.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.

Francois van der Merwe
Back to top
View user's profile Send private message Send e-mail
kimbert
PostPosted: Mon Sep 27, 2010 12:52 am    Post subject: Reply with quote

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

The 5Mb of XML probably contains 1000s of repeats of the same structure. If so, you should consider using this technique
http://www-128.ibm.com/developerworks/websphere/library/techarticles/0505_storey/0505_storey.html

...to avoid building a single, huge message tree.
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 » Handling a large message
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.