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?
Best answer by Tracy Norwillo
Here is the code for the Application Message retry count:
SELECT retried_count
, a1.*
FROM address_label a1
WHERE a1.application_message_id = &MessageIDAlso 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 = &MessageIDThe code is from the Server Trace tab of the Debug Console which I turned on just before I queried for a single Application Message.
Here is the code for the Application Message retry count:
SELECT retried_count
, a1.*
FROM address_label a1
WHERE a1.application_message_id = &MessageIDAlso 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 = &MessageIDThe code is from the Server Trace tab of the Debug Console which I turned on just before I queried for a single Application Message.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.