How to clear dead letter queue azure service bus by azure logic app

Question

How to clear dead letter queue azure service bus by azure logic app

Emran Hossain 170

Hi folk

I have question regarding delete "dead letter queue azure service bus" by Azure Logic App . I have no idea, how to start . Someone here give me idea, simply with good structure.

Thanks

MayankBargali-MSFT 63,511 Reputation points

2023-11-15T11:01:39.53+00:00

Hi @Emran Hossain

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

MayankBargali-MSFT 63,511 Reputation points

2023-11-15T11:01:39.53+00:00

Hi @Emran Hossain

Following up to see if my answer helps. Feel free to get back to me if you need any assistance.

Please 'Accept Answer' if it helped so that it can help others in the community looking for help on similar topics.

Answer 1

MayankBargali-MSFT 63,511

@Emran Hossain Thanks for reaching out.

If your entity is queue and want to read the messages from dead letter queue then you can leverage the When a message is received in a queue (auto-complete) which will read and complete all the message once the message is landed in dead letter queue depending on what configuration you have specified in the 'How often do you want to check for items?' property. Make sure you have select the Queue type 'DeadLetter' as in the below configuration.

User's image

Similarly if you have topic subscription as the entity then you need to leverage the as the When a message is received in a topic subscription (auto-complete) trigger.

In case if you want to manually run your logic and not when the message land in dead letter queue then you can leverage the Get messages from a queue (peek-lock) and then call the complete action. Similarly you can do the same for topic subscription. For more details on the different available action you can refer to this document.

To get started with logic app service bus trigger/action you can refer to this document.

Feel free to get back to me if you need any assistance.

Emran Hossain 170 Reputation points

2023-11-16T07:19:48.4233333+00:00
Hi MayankBargali-MSFT ,

Thanks for your reply ,

I want to describe my task briefly :

I want to create a Logic app for Clear/delete Dead Letter Queue

Create a trigger for weekly basic that's automate logic app by Recurrences

Every week azure app search , if any dead letter in a query (messages like not deliver or timeout somehow not not deliver .

message already seen not take action

after one week , azure app notify specific group

if specific group not take action within one week , it will notify tenant owner .

Can you create graph like this

Thanks in advance
MayankBargali-MSFT 63,511 Reputation points

2023-11-16T10:17:34.5466667+00:00

@Emran Hossain Can you confirm what do you mean by message already seen not take action? and what do you mean by azure app notify specific group?

Please confirm if my under is correct. You want to monitor the service bus entity (queue/subscription) and check if there is any dead letter message available. You want to check when the message was moved to the dead letter queue and if the dead letter message is not consumed more than one week of moving it to dead letter queue then you want to send email to the respective owner (you already have the list of entity along with the respective owners).
Emran Hossain 170 Reputation points

2023-11-16T10:22:37.35+00:00

Yes You are right , when i meant in my previous massage .
MayankBargali-MSFT 63,511 Reputation points

2023-11-16T11:07:40.64+00:00

@Emran Hossain Thanks for the confirmation. When the messages is moved to the dead letter queue then unfortunately there is no way to find when the message was moved to the dead letter queue as there is no property that can help you with your use case. Service bus has the property enqueue time in UTC that tells when the message was send to the service bus but you cannot find when the message was moved to the deader letter queue.

Further if you want to monitor different entities or different services bus then you cannot use logic app service bus connector trigger as you need to pass the value dynamically with identity rather than service bus connection string.

But you can integrate the service bus with event grid so whenever there are any message moved to the dead letter queue with no active lister then those events are raised. For more details please refer to this document. Now based on this event for which service bus entity it was trigger you can store this value in some DB or storage table which you can take as the reference to validate if there are still dead letter message available from today's date (by comparing the last date of event) and further build your logic. There is no way to find if the message was moved to dead letter queue one week back.

Service bus Event Grid events --> Logic App event grid Trigger --> store the information in some table/DB

Logic App reoccurrence trigger --> Read the table data --> pass the entity details to service bus action (dynamically based on event grid event that was store) if it is week old --> validate if the dead letter message are still there --> if yes then send email --> Delete the DB entry

Alternatively you can leverage the alert metrics for service bus in case if you just need to alert if the message are moved to dead letter queue. For more details you can refer to previous discussion here.

Feel free to get back to me if you need any assistance.

How to clear dead letter queue azure service bus by azure logic app

0 additional answers

Activity