My system's BC:MSG_AUDIT table is continuously growing. At this moment, it has more than three millon records. Apparently, this table contains audit information of messages, ie, the different versions of each.
In Adapter Engine I can see a lot of messages in "system error" status. I've tried a lot of reports with the idea to cancel and delete these messages, but I have not succeeded so far. Some of the messages have been reprocessed more than 900 times, making it grow tremendously the number of entries in BC_MSG_AUDIT table.
I've activated the XML messages archiving and deleting in my PI 7.1.
Does anyone have any idea why this is happening? and, how could I fix it?
Thanks to all in advance and best regards,