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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / The Audit history of c...
Service | Customer Service, Contact Center, Fie...
Suggested answer

The Audit history of contacts cannot be displayed

(2) ShareShare
ReportReport
Posted on by SL-07110236-0 8
Hi all,
 
I need someone to help to troubleshoot the contacts' audit history problem, some of the records' audit history cannot be displayed, do you have any idea on it? thanks a lot
 
 
 
Categories:
Dynamics 365 Customer Service
Dynamics 365 Field Service
event viewer appl...
I have the same question (0)
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar Microsoft Employee on at
    The Audit history of contacts cannot be displayed
    Hey!
     
    This looks like D365 CRM OnPrem. It would be important to know the version of it.  However, the error message is quite simple:  when loading areas.aspx, the audit history in an iframe, there's an error converting a value:
     
        Exception type: CrmException 
        Exception message: Invalid AttributeType.Decimal with value 2009-02-20 00:00:00.
     
    Regards,
  • SL-07110236-0 Profile Picture
    SL-07110236-0 8 on at
    The Audit history of contacts cannot be displayed
    Hi Perez
     
    yes. our version is 9.1.0010.0102 OnPrem
     
    we know the exception message below:
     Exception message: Invalid AttributeType.Decimal with value 2009-02-20 00:00:00.
     
    Can help to illustrate how to fix it?  thanks again
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 2,641 Super User 2025 Season 2 on at
    The Audit history of contacts cannot be displayed
    It looks like you may have somehow gotten a date and time value into a decimal field. You would need to update the value to be a decimal, fix the field definition so it expects a date/time (I know this is not possible online but I'm guessing you can do it on-prem), or clear out the audit values in that field where the error occurs.
  • SL-07110236-0 Profile Picture
    SL-07110236-0 8 on at
    The Audit history of contacts cannot be displayed
    thanks Tom's reply and it is not only one record has problem, many records is facing the audit history problem.  Therefore, we hope to have complete solution instead of data patch for each one.  Thanks again.  Please advice
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 2,641 Super User 2025 Season 2 on at
    The Audit history of contacts cannot be displayed
     
    There is the developer information for the Audit table. You'll need to have someone pull values with the wrong format and clear it out (or replace it). I would think you could do a query for values in the decimal field that contain a dash or a colon to find those with a date, then delete them.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 73 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 52 Super User 2025 Season 2

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 45

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans