Stelex
IS-IT--Management
- Dec 25, 2006
- 15
Arggh!
OK - what person in their right mind truncates the audit trail entries. We found that when we migrated our audit trail from 9.2 SP1 to 9.5 SP1 that the conversion script built into the system takes the (I believe 128 or 255 character) Event field in DAudit is and truncates it to 32 characters in DAuditNew.
This led us to the problem of having entries actually cut off at 32 characters - which in a regulated Pharma is a big No No.
The only way we could fix the issue was to replace the entries in DAuditNew with the un-truncated entries from DAudit (SQL magic being performed here).
How have other companies been solving this issue?
OK - what person in their right mind truncates the audit trail entries. We found that when we migrated our audit trail from 9.2 SP1 to 9.5 SP1 that the conversion script built into the system takes the (I believe 128 or 255 character) Event field in DAudit is and truncates it to 32 characters in DAuditNew.
This led us to the problem of having entries actually cut off at 32 characters - which in a regulated Pharma is a big No No.
The only way we could fix the issue was to replace the entries in DAuditNew with the un-truncated entries from DAudit (SQL magic being performed here).
How have other companies been solving this issue?