web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Audit history showing some symbol instead of values

(0) ShareShare
ReportReport
Posted on by 10

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,

pastedimage1572262815676v1.png

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.

I have the same question (0)
  • LuHao Profile Picture
    40,892 on at

    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.

    1. https://arunpotti.wordpress.com/2019/04/21/audit-history-data-missing-in-dynamics-crm/
    2. https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/153919/weird-symbol-in-audit-history?pifragment-97030=1
    3. https://crmbusiness.wordpress.com/category/hosks-microsoft-dynamic-crm-development/page/3/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
iampranjal Profile Picture

iampranjal 61

#2
Martin Dráb Profile Picture

Martin Dráb 39 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 32 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans