Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: lynch80516 on February 29, 2020, 09:39:12 am

Title: Audit Records - Deleting a single record.
Post by: lynch80516 on February 29, 2020, 09:39:12 am

Does anyone have experience with deleting a single audit record. I have a model that has auditing enabled and I we found a problem with one of the elements text. We fixed the text, but the original text still is present in the audit record for that element.

What I would like to be able to do is delete that single audit record without completely eliminating all the record logs and starting over.

Any suggestions would be appreciated.

John

Title: Re: Audit Records - Deleting a single record.
Post by: qwerty on February 29, 2020, 10:30:56 am

You will probably need to locate the culprit in t_snapshot and delete it with SQL. Pretty much hacking a log which ought to keep changes. Raises the question why you create the audit in the first place. This way you can't trust is. Seems quite odd.

q.

Title: Re: Audit Records - Deleting a single record.
Post by: Geert Bellekens on February 29, 2020, 07:29:02 pm

I was thinking the same thing.
Why keep an audit log, if you are going to delete specific records from it.
Smells funny ???

Geert

Title: Re: Audit Records - Deleting a single record.
Post by: lynch80516 on March 01, 2020, 01:21:11 pm

Yes it is weird and unusual. But I'm faced with an issue that I can either delete a single audit record or roll the model back about a year and start over. It's complicated

Title: Re: Audit Records - Deleting a single record.
Post by: qwerty on March 02, 2020, 01:21:44 am

Well, I guess you have reasons. FWIW I would not remove the log entry but add a "rollback/undo" action to the log.

q.