For some reason we have some messages for a durable subscription that I have not been able to receive. I was in a tight time frame (month end) and chose to read the blobs directly, create a new message and send it to a queue where they were processed correctly.
I need to remove those processed messages to prevent double processing. I still cant get them to receive using normal subscribers. We have a 24/7 operation and I am not able to restart the production server until the weekend. Can I simply remove the processed messages from jms_message_log and jms_reference_log using SQL or will that cause the messaging system to crash. New messages are being recieved all the time.