How to delete RIB messages where IN_QUEUE=1 in RIB_MESSAGE table and ATTEMPT_COUNT is not increasing

Hello All

Requesting assistance on a RIB 14.0.1 issue.

For performance testing, we loaded over 30K messages in RIB, in the etReceiving queue.

These had several data errors. We have a request to purge all of these messages as erroneous messages are getting processed again and again.

However, some of the messages are not getting re-attempted and are staying in the queue.

The status of the messages is as follows:

Topic_Name     Attempt_count     Max_attempts     IN_QUEUE     COUNT(1)

etReceiving                   5               5                              0          34694

etReceiving                   1               5                              1              1

etReceiving                   3               5                              1              1

The ones from the 2nd an 3rd are stuck in the same status and attemp_count is not increasing for them.