Having issue with our Importer utility for Zephyr for Jira Cloud.Please click here for the steps to resolve the issue. If you are not able to access Capture Cloud and seeing a message, it means your Capture cloud instance is not migrated as part of our GDPR and Atlassian privacy policy. Please click here for the steps to Migrate your Capture Cloud instance to use Capture.
Support | Zephyr



My itcc.audit Table is Very Large. Why?

Created on

Problem

You've determined that the audit table in the itcc database is incredibly large, beyond comfort.

Cause

This isn't actually a problem and is the result of normal operation over a long period of time. The audit table contains every instance where a user has logged into Zephyr, logged out of Zephyr, and deleted data from within Zephyr. This includes every time an external service or application completes these actions via the API.

Resolution

If your external applications are consistently interacting with Zephyr, it's good practice to make sure these tools are staying persistently logged in over a longer period of time. If your tools are logging in to complete a single action then logging out, the audit logs can build up and become quite large.

If you're OK with not having this data from time to time, you can truncate the itcc.audit table by logging into the Zephyr database and using the TRUNCATE TABLE [tablename] command where [tablename] is itcc.audit. Afterwards, make sure to OPTIMIZE the table as the database engine will need to reclaim some space on the system. 

If you're curious as to the exact contents of this table, you can view it in a friendly format at http://[yourzephyrserver]/flex/assets/html/auditlog.html.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk