Audit trail is providing incorrect repetitive create dates
search cancel

Audit trail is providing incorrect repetitive create dates

book

Article ID: 230968

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

During a search of why a certain resource was able to perform a specific task, per the group rights, we made changes to a resource attribute to see how the audit trail was behaving.

We noticed that in the change to computer # value, all the 7 changes showed the same create date. 

AND, the time shown in the clarity audit tab was 11/2/21 3:11 AM. Though a query to the database showed 2021-11-02 12:11:17.

Our time zones (mine and the functional's are in the EST.) We are assuming the time shown in the database is West Coast.

The changes to the attribute were made thru out mid-day EST.

 

Environment

Release : 15.9.3

Component : CLARITY STUDIO

Cause

The custom process which was updating custom attribute was doing it via direct database update.

Resolution

To correct the issue customer redesigned the process to update attribute via XOG and not use direct database update script.