
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
OR
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.