Administration tasks tab slow to open and Audit Events does not populate
We have identified a stored procedure and custom function that executes more than is required. While this store procedure and function are not new to 7.1.1, it can cause a "tipping point" where, in busier environments, it will prevent the Administration tasks tab from loading in a timely manner.
Defect logged where we will make changes to the stored procedure which will make it significantly more efficient in future versions.
Defect 261659: Administration tasks tab slow to open and Audit Events does not populate
WORKAROUND:
1. Copy the attached "GetTotalRecordsInTable.sql" and "AdminSummary_Read.sql" files to the SQL server
2. Stop all CA Coordinators
3. Back up the ChangeAuditor database
4. In SQL Management studio, click "File | Open | File", and select the "GetTotalRecordsInTable.sql" file
5. Select the ChangeAuditor database from the Database drop-down box
6. Click execute
7. Repeat steps 4-6 for the "AdminSummary_Read.sql" file
8. Start the CA Coordinator
STATUS:
This issue has been resolved in the latest release of Change Auditor.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center