Disabling or deleting history logs
Hi,
I have few scheduled events that by night are importing a lot of informations from a SQL table to every item’s page in Agile.
Every time a single data is imported a line in the History is being logged. Since I can create filtered views I thought it wasn’t a problem until our AGILE_DATA101AGILE9.ORA system file from apporadataagile9 directory reached 32gb of size giving us a lot of problems; we had to ask our system consultants and they created a second file which is now already 20gb.
Is there a way to avoid the recording of certain logs and consequently slow down the enlargement of that system file? Is it possible to delete the unwanted log history?
Thank you!
I believe it cannot be avoided to write history for the part update. You may want to work with Oracle for a SQL script to purge those history records on DB.
There is no way to *not* write history records in Agile, it is part of the basic functionality of the application. It may be possible to occasionally purge the history tables, but unless you only delete those records pertaining to those imports, you might lose information that is critical. Do you have to submit data to the FDA?? If so, then you cannot remove any history without letting the FDA know and approve of it.
It is possible to remove selected records, but I would make sure that they are far in the past (how long has this import processing been going on??) and that they pertain only to the import processing (which seems pretty innocuous). If you don’t already have a specific user account that is only used for this import processing, I would recommend doing so, as it would then be easy to identify which records are from that processing vs. what is being done by normal users.