Managing Document Activity Log

Hi,

Does anyone know if there's a way to limit what Document Activity is being logged? Or if there's a way to purge or archive some entries in the Document History? Overtime, with a large number of document, these logs information could become quite unmanagable. In our PRD environment, within over a year, the table: P_CON_DOCUMENT_ACTIVITY_LOG accumulates over 130000 rows.
Is there a way to maybe offload this or archive it somewhere? Is there a tool for similar maintenance purposes?

Any info would be helpful.
Thanks,
sphan_xell.

Find more posts tagged with

Comments

JTNeville

Where is this log stored? In SQL or MPserver? I did a quick look at my server but didn't see it. I have a few SQL queries for truncating old data and cleaning up the DB's and getting rid of empty space in the files, something SQL 2K is terrible at doing by itself.

There are a number of ways to limit the logging of each of the pieces of MP (tomcat, sql, mpserver) with some more info perhaps I can give you a pointer.

JTNeville

found it in the SQL tables. That's a good question. I can not answer it but I will ask my support engineer after I hash out some 4.1 issues.

dbguy

In 4.1, you can manage what gets logged. Evidently, this will have side effects on Document and Workspace histories: they will NOT contain the activity types you disable, and there will NOT be a way to determine if an activity that is not logged was ever performed. If you and your users can live with it, here is how you do it.

First, you'll need to set up Library Manager to display the log entries. In server/config/LibMgr.xml add:

<MetadataTable DisplayName="Activity Types" TableName="APP::ACTIVITY_TYPE">
<Column DisplayName="Description" ColumnName="APP: Smiley Very Happy

ESCRIPTION"/>
<Column DisplayName="Enabled" ColumnName="APP::IS_ENABLED"/>
</MetadataTable>

Open Library Manager, go to your_library_name->Metadata->Activity Types. All available activity types will be displayed. Double click on the ones you want to disable and edit them so IS_ENABLED is false.

That's it.

If you want to truncate the P_CON_DOCUMENT_ACTIVITY_LOG, select * from the range of time you want to get rid of, save the output to a file (in case you ever need to rebuild the log), and then delete the same rows you selected. Again, Document and Workspace histories will be empty for the range of time you delete.

sphan_xell

Thank you so much.
That's what I'm looking for.
sphan_xell.