| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| No Message found in the Queue |
« View previous topic :: View next topic » |
| Author |
Message
|
| santoshvgotur |
 Posted: Thu Jun 16, 2016 12:28 am Post subject: No Message found in the Queue |
 |
|
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 |
|
 |
| Vitor |
| Posted: Thu Jun 16, 2016 4:25 am Post subject: Re: No Message found in the Queue |
|
|
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 |
|
|
| hughson |
| Posted: Thu Jun 16, 2016 8:51 pm Post subject: Re: No Message found in the Queue |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
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 |
|
|
| santoshvgotur |
| Posted: Thu Jun 30, 2016 1:58 am Post subject: |
|
|
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 |
|
|
| hughson |
| Posted: Thu Jun 30, 2016 2:14 am Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
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 |
|
|
|
|
|
| |
|
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
|
|
|
|
