I'd like to ask a question that may be a "dumb" one, but I want to be sure about something *before* an actual problem occurs
We're running a number of LiveCycle (ES U1) installations, both in test and productive environments, with quite some user-based processes. We noticed that the size of the LiveCycle database keeps on increasing over time. It's most noticeable on test systems which just use the turnkey MySQL, but it doesn't seem to be that much different with MSSQL.
What I'd like to know is this: What happens with data from processes that have been completed (especially instances of large document variables per step etc.)? Is there some kind of cleanup mechanism and if so, what triggers it? Is there any way to manually perform some maintenance tasks?
I guess every kind of information would be really helpful. Thanks a lot,
It's not a dumb question at all, it's a very good one.
There are two ways you can purge your LiveCycle database.
1. You can use the Adobe PurgeProcessTool. This tool completely deletes all trace of processes that meet a particular criteria (usually, they must be older than a certain date).
After you run the tool, that process and all its data will be gone - there is no record that it ever existed.
You can find a batch file (modify for Unix) at: C:\Adobe\LiveCycle8.2\LiveCycle_ES_SDK\misc\Foundation\ProcessPurgeTool
Note: We've heard one report of corruption that may (or may not) be related to the use of this tool. (This is not FUD, just letting you know.) In this case, the user used "*" to try to delete everything from all categories. We recommend you only purge process types that you have created.
2. You can use the Avoka purge tool. This tool takes a slightly different approach. It leaves the old processes intact, but removes a whole lot of superfluous information that is stored along with the process instance. It removes:
The bottom line is that it will dramatically reduce your database size, without removing your ability to search and track historical process instances.
You can find more information here: http://www.avoka.com/avoka/purge_util.shtml
If you have any questions, please email info-at-avoka.com
Thank you very much indeed Howard - this is the sort of answer that one dreams about, lots of useful information and then some. Great, thank you.
As our customers (at least at this time) are using own reporting systems which take care of storing statistical information we may actually be ok with the tool Adobe supplies with the SDK. However, having just had a look at your site I think that we may very well consider the enquiry tool for at least one of the affected customers.
Have a nice weekend,