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 CRM (Archived)

Audit History not Working

(0) ShareShare
ReportReport
Posted on by

In our CRM the audit history brings back the error message 'SQL Server Error' with the only option of try again and cancel. This is happening for Leads, Contacts and opportunities. Not sure what to do at all.

*This post is locked for comments

I have the same question (0)
  • Nars Profile Picture
    65 on at

    We are also facing the same issue. Please suggest.

  • Michael Minnekeer Profile Picture
    on at

    I just checked which rollup is installed on our CRM server and it is rollup 5, would installing 11 be the first step in trying to fix this as itt should be done anyway?

  • Nars Profile Picture
    65 on at

    We have already installed rollup 11 but still have the issue.

  • Michael Minnekeer Profile Picture
    on at

    Our Audit history is still broken is there anything I can do?

  • peterbecerra Profile Picture
    5 on at

    We are receiving the same error message as it relates to Contacts.  Any updates?

  • Michael Minn Profile Picture
    1,214 on at

    Ours magically started working again about 2 weeks ago, we have no idea how it happened.

  • Mohammad Atif Profile Picture
    on at

    can you please enable the platform tracing and capture the detailed error message

    Thanks,

    Mohammad

  • Community Member Profile Picture
    on at

    We are encountering the same problem with Accounts.  Although some accounts will show the audit history, others do not.  The error message displayed is the same as the one mentioned above.  Any suggestions?  We are using CRM cloud-based with the 2013 update.

  • Thomas Lampert Profile Picture
    210 on at

    Have you looked in your audit history logs? One of our customers has the problem that the audit log serial numbers and the order of the dates does not fit. That means the audit logs are not in the correct order.

    Example:

    SN   From              To

    1      01/01/2013     04/01/2013

    2      01/01/2014     04/01/2014

    3      10/01/2013     01/01/2014

    ...

    In this case you're not able to delete an audit log because you have to delete the oldest first which is not possible because of the wrong order of the serial number.

  • Community Member Profile Picture
    on at

    Thank you for your response.  The dates seem to be in sync however, I did notice that the last log was from Dec.31/2013 until March 31/2014 but we are only in the month of February.  Would that be a problem?  What happens when you delete a log, does it delete the Audit History records as well?

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans