OD Messages Table

phanee

I am using Teamsite 6.5 Sp2 on Solaris Box with Opendeploy 6.0.2
Teamsite is configured to use DAS feature of opendeploy.

I m using oracle 9 as our database

Problem is that the Messages table gets filled up over weeks
and now stands at 90000 records.

I need a solution to some how rotate this table.

What is the messages table for?
What data is actually being populated in this table?
Can i just write a cron script to delete records that are older?
Do i need to stop Opendeploy or event subsystem to execute the script.

Migrateduser

I assume that you are looking at the TeamSite event subsystem database rather than the OD event subsystem database. That database is the message store for the instance of OpenJMS that is used as the event subsystem. The version that shipped with all versions of 6.5 and at least 6.7.0 had a couple of bugs in it. One is an SQL Server specific bug that causes table locking problems. The other, which you are likely running into, is that in some cases, messages with no consumers are not garbage collected. You'll probably want to call support and get yourself added for notification on that bug when it is closed. Unfortunately, I don't know the number.

If you are sure that all relevant messages have been consumed, you can truncate that table at any time. I've spoken to the product managers about this. They acknowledged the bug and said that a fix is coming. I'm not sure if the fix is in 6.7.1, 6.7.1SP1, or some future version yet to be delivered.

I'd recommend picking up Java Messaging by Bruno for more insight into how JMS works. Unfortunately, the authors used a different JMS provider than OpenJMS so the code examples are not 100% directly useful.