We have configured Default JMS process in our project, from past few days JMS messages are not generating, then we investigated to find out the root cause of the issue and found out that MPI_ENTOQUEUE_ID table is accumulated with all the messages around 396 Million records where as we have around 10 million records in our system.
Table count is coming down every two minutes 500 records, with this process we will not be able to clear the data on this table.
We have handlers implemented to create composite view from the MDM and send JMS messages to the down stream applications.We were not able to reproduce this issue in lower enviroments.
My Questions :
Is there any Java API to clean this table with MDM process. I am against to run the DML which will create lot other issues since we are missing MDM flavor thru DML process.
Is there any other reasons for this table accumulated with these many records.
Any input would be appreciated.