We’re experiencing issues with audit trail exports from our compliance module in ETQ Reliance 2021. When we export audit logs for regulatory reviews, we’re noticing that certain user actions are completely missing from the exported data, particularly document approvals and status changes made by specific user roles.
I’ve checked the audit trail logging configuration and confirmed that all event types are enabled for capture. The database transaction logs show these actions are being recorded initially, but they don’t appear in the export files. Our export filter settings seem correct - we’re selecting all action types and the full date range.
Here’s the query we’re using to verify the data exists:
SELECT action_type, user_id, timestamp
FROM compliance_audit_log
WHERE action_type IN ('APPROVE', 'STATUS_CHANGE')
The query returns the missing records, but the ETQ export utility doesn’t include them. This is creating gaps in our compliance documentation for upcoming FDA audits. Has anyone encountered similar audit trail export inconsistencies? We need to ensure complete traceability for all user actions in the compliance module.
Thanks for the suggestions. I checked the materialized views and they’re refreshing correctly every 30 minutes. The service account has SELECT permissions on all audit tables. However, I did find something interesting - when I look at the export filter settings in detail, there’s a “User Role Filter” option that was set to exclude certain administrative roles by default. This was likely configured during initial setup to reduce log volume, but it’s now filtering out the exact approval actions we need. Is there a way to override this at export time without changing the global filter configuration?
Adding to the permissions angle - we had a similar issue where the export filters were configured at the module level but not properly cascaded to the sub-module audit logs. In ETQ 2021, compliance module has separate audit streams for different compliance types (regulatory, internal, supplier).
Go to Admin > Compliance Configuration > Audit Settings and verify that “Include Sub-Module Actions” is enabled. Also check if your export template is configured to pull from all audit log sources, not just the primary compliance_audit_log table.
Yes, you can override role filters at export time, but it requires modifying the export template. In the ETQ export utility, when you select your audit trail export template, click “Advanced Options” and look for “Role-Based Filtering Override”. You’ll need to explicitly list the role IDs that should be included despite the global filter.
Alternatively, create a dedicated export template specifically for regulatory audits that ignores the role filters completely. This is actually the recommended approach for compliance scenarios where you need complete audit trails regardless of user roles.