Dynamics Community Forum Thread Details

Audit history showing some symbol instead of values

We are using Dynamcis CRM 365 on-premise version.

Auditing is enabled for an entity in all our CRM environments (DEV,QA,PROD).When we are moving a managed solutions along with a audit enabled enity from DEV to other CRM instance, the Auditing for the entity is stopped and started again. Due to this OOB weird functionality, the Audit log's New Values are masked with an weird symbol as below,

We have tried an unsupported way to turn audit history back.We ran the below query in MS CRM SQL DB.

To enable it on specific entities:

DELETE FROM auditbase

WHERE Action='102' And ObjectTypeCode= '<ObjectTypeCode>';

where objecttypecode = the entity from the metadataschema/entitytable.

The above method worked for us and it turned back the audit records.

As this is an unsupported way to return back the audit logs and we can't ran this query in DB level for every managed solution migration.

Kindly share the supported way of resolving this issue and also share the root cause of this issue.

Thanks!

Eliyas H.

Hi partner,

This cause of this icon is because auditing has been stopped and started again either for the entity or the fields.

The solution is to update the database.

delete from AuditBase where action= 102 or action = 104

SELECT AuditId, ObjectId, [Action], AttributeMask, ChangeData, ObjectTypeCode FROM AuditBase WHERE [Action] = 102 -- Audit Change at Entity Level AND ChangeData = 'TRUE' -- For Disabled Events AND ObjectTypeCode = 112 -- Case Entity Object Type Code ORDER BY CreatedOn DESC

Please refer to several blogs.

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics