Skip to main content

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?

@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


Terms & ConditionsCookie settings