Solved

Retry Application Message Count

  • 19 April 2024
  • 1 reply
  • 19 views

Userlevel 5
Badge +10

Hi,

I’m trying to find an way of outputting into a report the number of times an Application Message was retried in Apps10.

 

I can see the data on screen - but no way of debugging (that I can see) to get at the figure to extract.

 

Anyone got a suggestion?

icon

Best answer by Tracy Norwillo 22 April 2024, 21:58

View original

1 reply

Userlevel 4
Badge +14

@Matthew  

Here is the code for the Application Message retry count:

SELECT retried_count
, a1.*
FROM address_label a1
WHERE a1.application_message_id = &MessageID

Also of interest for the remainder of the Application Message data:

SELECT a1.*
, a2.*
FROM application_message a1
, message_queue a2
WHERE a1.queue = a2.queue_id (+)
AND a1.application_message_id = &MessageID

SELECT a1.*
FROM message_body a1
WHERE a1.application_message_id = &MessageID

The code is from the Server Trace tab of the Debug Console which I turned on just before I queried for a single Application Message.

Reply