Nov 25 2015

T89-2015: Audit trail is linking the wrong entries in the audit trail tables

Experiment

Some issues with the audit trail have been identified:

The transaction_id is reset when the server is restarted.
In some configurations, the transaction id for audit trail events can get reset to zero when the database server is restarted. Since these transaction ids are required to be unique, this can cause audit trail events to include data from multiple events.

Audit events are being generated continuously.
The ETL process is causing audit events to be logged. The ETL process is not supposed to contribute to the audit trail.

High number of occurrences of EQUIPMENT_METHOD_RAW_DATA records.
There are a very large number of entries about EQUIPMENT_METHOD_RAW_DATA in the audit trail. These are sequences of records being "Deleted" and then "Added" in large blocks.
Resolution:
These defects have been addressed in Experiment Knowledge Base 4.3 SP1 HF1 as listed below. If you are affected by these issues and need access to EKB 4.3 SP1 HF1, please contact BIOVIA support.

EKB-8405 The transaction_id is reset when the server is restarted.
When the database service was restarted, audit transaction IDs were reset to zero. This issue has been fixed.

EKB-8406 Audit events are being generated continuously.
Internal ETL events no longer create audit log entries. Logging of these events was resulting in the audit trail being filled with data that was not useful.

EKB-8407 High number of occurrences of EQUIPMENT_METHOD_RAW_DATA records.
When the value of a parameter of the Recorded Equipment Output type is edited (either by form or by protocol), the audit trail now logs changes only for values that were actually changed. Previously, a change was logged for each value in the set.
Error Mesage:
N/A