Having encountered serious problems with VA version 7.1 regarding the size of the audit tables reloading parallel with regular tables (several days of unstable VA environment) , tech supported mentioned a workaround by weekly archiving data from audit and audit_entry tables to a set of archive tables. This seemed to work properly. After upgrading to version 7.3 this process was repeated (new configuration) , but the auto-archiving feature does not seems to work properly. (audit tables not populated, regular tables not purged)
We then decided to build our own small DI Studio job to read the appropriate tables (6 in total) from the EVM repository (it's a postgreSQL DB hidden on the VA server) and use the output of the Job to populate the existing VA audit table. The Job is remarkably simple , just some joins, denormalizing data and appending archived / non-archived data. 3-4 million audit records are processed within 10 minutes and we run the job weekly . EVM autoload is disabled , so VA restarts are no longer a risk with multiple autoloading processes getting in each other's way.
The job was build with DI Studio 4.6 requiring PostgreSQL drivers installed, a DSN configured, ODBC library defined and using the proper account to access the data. The job package I can share 🙂
Cheers!
... View more