Active Administrator Audit Reporting Failure for Large Data Sets (4383273)

Active Administrator audit reporting may fail when attempting to retrieve detailed data for events older than 10 days. This issue impacts the ability to access extended historical audit information within the specified timeframe.

SQL queries executed during report generation exceed the allowed execution time and time out, resulting in audit report failures when processing large or long-range data sets.

This can be configured by editing the InstanceConfiguration.xml file located at:
C:\ProgramData\Quest\Active Administrator

 

Within the file, locate the <DatabaseConfiguration> section and modify the <CommandTimeout> value. The default is 30 seconds—this should be increased to 60–120 seconds to improve report execution reliability.

After making the change:

• Restart the AFS and ADS services
• Re-run the audit reports to validate the fix

Optionally, consider increasing the <ConnectionTimeout> value as well to prevent connection-related timeouts when handling larger datasets.