We’re experiencing timeout issues when trying to export audit trail data through the Qualio UI. The export works fine for small date ranges (1-2 weeks), but fails consistently when we try to pull 3+ months of data.
The error we get:
Request timeout after 120 seconds
Failed to generate audit export
Status: 504 Gateway Timeout
We need this for our quarterly compliance reports and the audit trail has grown significantly. The export batch size seems limited and we’re not sure how to configure the API timeout settings. Has anyone dealt with system resource constraints during large audit exports?
One thing to consider is the filter complexity too. If you’re filtering by multiple fields (user, action type, module) in addition to date range, that adds processing overhead. Try simplifying your filters first and see if that helps. We had a similar issue and it turned out our filter was causing full table scans instead of using indexes efficiently. System resource usage spikes dramatically when indexes aren’t leveraged properly.
Thanks for the suggestions. I checked and we’re definitely exceeding 10k records. The pagination approach makes sense but I’m not familiar with the API parameters. Where can I find documentation on the batch size configuration?
I’ve seen this before. The default timeout is usually 120 seconds for API calls in Qualio 2022.2. Try breaking your export into smaller chunks - maybe monthly instead of quarterly. You can also check if there’s a way to schedule the export during off-peak hours when system resources aren’t as constrained.