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

Announcements

No record found.

News and Announcements icon
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 10
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
 
 
 
event viewer appl...
Categories:
Dynamics 365 Customer Service
Dynamics 365 Field Service
I have the same question (0)
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar Microsoft Employee on at
    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 10 on at
    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 3,084 Super User 2026 Season 1 on at
    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 10 on at
    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 3,084 Super User 2026 Season 1 on at
     
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
11manish Profile Picture

11manish 36

#2
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 32

#3
ManoVerse Profile Picture

ManoVerse 30 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans