The Compliance Audit Report is getting stuck at 5 Percent.

Document ID : KB000100875
Last Modified Date : 24/08/2018
Show Technical Document Details
The CA Data Protection iConsole Report "Compliance Audit Report" (CAR) can get stuck at 5% and eventually times out.
CA Data Protection 15.2 Reports running on MS SQL
This issue is only encountered in high volume environments.  The search/report is pulling back many more rows from the MS SQL Database than expected (Millions rather than thousands).
CA has carried out the best tuning possible for this report and released FIX:SO05149 (incorporating Reports_15.20_HF0189.msp)

This hotfix resolves the performance issue with this reports and displays the results faster. However, it should be noted that it can still take 5 minutes to run the report, however it does complete.  For further performance improvement when there is a huge database, we recommend database partitioning.

This fix is available to download from the CA Support Portal (
Additional Information:
Please note that this fix supersedes FIX:SO03842 (Incorporating Reports_15.20_HF0181.)

CA DLP, CA DataMinder, Orchestria, Orchestria APM, Orchestria EPM are brand names for the product now known as CA Data Protection.