NAS periodically runs an Administration task to delete older records from the NAS_TRANSACTION_LOG through NiS Bridge.
This is configured via the NiS Bridge section of the NAS config.
If the volume of data to be removed is too large then a SQL timeout may occur and the table therefore keeps growing.
You may see NAS_TRANSACTION_LOG table keep growing.
You may see SQL errors in nas.log
nas: COM Error [0x80040e31] IDispatch error #3121 - [Microsoft OLE DB Provider for SQL Server] Query timeout expired
nas: Nis-Bridge: Transaction-log administration, failed to remove transaction entries older than X days.
nas: Nis-Bridge: Transaction-log administration, failed to compress transaction entries older than X days.
Tech Tip - NAS_TRANSACTION_LOG table growing indefinitely
discusses a manual method to remove this data but if the problem has been undetected for a long time then these queries also fail.
In this instance it is necessary to remove the data in smaller chunks