Audit Stream Not Capturing Changes for Some Opportunity Records

[Ashif Malayil]

Hi Team,

I’m facing an issue in the Opportunity module where audit tracking behaves inconsistently across records.

I have enabled auditing for multiple enum fields such as Status, Priority, etc. The expected behaviour is that any change in these fields should be captured in the audit stream.

However:

• For some Opportunity records, the audit logs are working perfectly and capturing all changes.
• For other records, no audit history is being recorded at all, even though the same fields are updated.
• Auditing is enabled at the field level.
• This issue is limited to specific records only.
• There have been system upgrades/migrations performed earlier, and I suspect this might have impacted the audit behaviour.

Tracking the history of these changes is critical for our business process, and missing audit logs for certain records is causing a data traceability issue.

Questions:

1. What could cause audit logs to work only for certain records and not others?
2. Any recommended steps to debug or validate audit functionality at the record level?

[lazovic]

Hi Ashif Malayil,

It makes sense to compare two records: where change auditing works correctly, and where it doesn't. It's also worth checking for formula scripts or business processes that could affect auditable fields.

Please check now: is auditing still not working for the problematic records? In other words, you're changing field values, and the history isn't saved in the stream?

[Ashif Malayil]

Hi,

Yes, the issue is still reproducible.

For the affected Opportunity records, even now when I update audited fields such as Status or Priority, the changes are not being captured in the audit stream. In contrast, for other records, the audit logs are working as expected and recording all changes.

This confirms that the issue is not limited to historical data, but is still occurring at the record level.

Additionally, I can confirm that these same records are not triggering workflows. I cannot see logs for these records in workflows.

Confused what exactly is causing because it's happening to some random records.

[lazovic]

Ashif Malayil,

There's always a pattern to these things.

I'd kindly suggest you contact EspoCRM technical support to resolve this issue, after which we can highlight the cause of the problem on the forum. Please note that technical support may need access to your custom directory and at least two different records to reproduce the issue.