Index 31 of Array Error When Rebuilding SQL Triggers or Creating a New SQL Audit

Issue:

When rebuilding SQL triggers or creating a new SQL audit, you receive an index 31 of array error.

More Information:

There is a cap built into the Auditor product code on the amount of things being audited. The reason for this cap is to keep the use of memory to a minimum for optimal performance.

To resolve the error message you will want to review your existing audits. Most likely you have marked all or most fields in the audit. You will need to determine which fields you really want to track and unmark those that you do not need to audit. We do not recommend auditing everything as it will affect the memory and will cause the audit table to grow rapidly.

Related Content