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 » General Discussion » No Message found in the Queue

Post new topic  Reply to topic
 No Message found in the Queue « View previous topic :: View next topic » 
Author Message
santoshvgotur
PostPosted: Thu Jun 16, 2016 12:28 am    Post subject: No Message found in the Queue Reply with quote

Newbie

Joined: 16 Jun 2016
Posts: 2

Hi All,

We daily receive our data files from MQ series and load it t our Oracle Database 11g on window server 2008. But from last few weeks i m facing the error like No Message found in queue after loading a part of the file.And remaining part of the file will remain in the queue.

When we load the same file again , The file will gets load successfully . But Only once in week or so i am getting this error.

Can anyone help me with this.?

Thanks in advance.
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Jun 16, 2016 4:25 am    Post subject: Re: No Message found in the Queue Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

santoshvgotur wrote:
Can anyone help me with this.?


No.

We can't see your screen.

Your description:

santoshvgotur wrote:
We daily receive our data files from MQ series


is nonsensical. MQ contains messages not data files.

Assuming that something is converting the file records into messages, and you're reading the messages, then we come to the next nonsensical part of your post:

santoshvgotur wrote:
i m facing the error like No Message found in queue


So how much like that is the actual text? Is it very like that, exactly like that or just a bit like that?

Again with the assumptions, if you're getting a 2033 error code then whatever you're using to read the messages off the queue has a bug in it. Under some intermittent circumstances that occur once a week or so it's failing to clear out the message id, the correlation id or both from the MQMD before it does the next get. So rather than getting the next message, it's trying to get the message it just processed and obviously fails to do so.

By design, or because of a further bug, it then abends and stops processing, leaving the rest of the messages on the queue.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
hughson
PostPosted: Thu Jun 16, 2016 8:51 pm    Post subject: Re: No Message found in the Queue Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1914
Location: Bay of Plenty, New Zealand

santoshvgotur wrote:
When we load the same file again , The file will gets load successfully . But Only once in week or so i am getting this error.

Does this once a week coincide with a file that is bigger in size than one message and the application retrieving it has, as Vitor suggests, not cleared the MessageID or CorrelID before going back for the second half of the file perhaps?

Again, as Vitor says, to help you, you need to first give us rather more information, otherwise we'd just be guessing, as I have above. Most people on this forum prefer diagnostics to guessing

Cheers
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
santoshvgotur
PostPosted: Thu Jun 30, 2016 1:58 am    Post subject: Reply with quote

Newbie

Joined: 16 Jun 2016
Posts: 2

HI , Thanks for the reply.

I will get the following error messages.

MS2016063006331020160629060000002016063006000000
Error at RECEIVE: -8501
ORA-08501: Message 8501 not found; product=RDBMS; facility=ORA

PGM-08501: No message available on the queu
30.06.2016 00:38:55 [HLLOG_PROD|257419543] UNKNOWN: Error at RECEIVE: ORA-08501: Message 8501 not found; product=RDBMS; facility=ORA

PGM-08501: No message available on the queue

As you see after receiving the some part of the file it is throwing error like no more messages or data are available. But when we look into the queue still the remaining part we can see in the queue.
This issue wont sometimes not every time.

Please help with this.
Back to top
View user's profile Send private message
hughson
PostPosted: Thu Jun 30, 2016 2:14 am    Post subject: Reply with quote

Padawan

Joined: 09 May 2013
Posts: 1914
Location: Bay of Plenty, New Zealand

These are error messages that your application writes out, they are not MQ error messages. You will need to ask your application developer what they mean. Perhaps the application writes these errors as a result of an MQRC. That would something you should tell us.

If the application is complaining that it can't get the message off the queue and yet when you look in the queue you see the message that it is supposed to be getting then either the application is trying to retrieve a different message in error (e.g. it hasn't cleared it's MsgId and CorrelId fields) or the message is part of an uncommitted transaction in which case:

Code:
DISPLAY QSTATUS(q-name) UNCOM


would show you if there are uncommitted messages on the queue.

We're still guessing though.

Cheers
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General Discussion » No Message found in the Queue
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.