Return
-
Title
ApexSQL Audit 2021.01 building up files in Quarantine folder -
Description
While troubleshooting the reasons ApexSQL Audit stopped, the quarantine folder takes large amount of drive space where the temporary folder is located.
The log file shows large number of errors displaying this message:
ERROR [CENTRAL]: Package loading failed. Package 019e4da6-15a6-49ab-b4a6-285aa44f8449.ApexSqlComplyPackage will be moved to quarantine folder due to following error: Unable to read beyond the end of the stream.
-
Cause
The query or the information captured goes over the default 512- character limit of the sql data captured and the information is truncated causing the issue. -
Resolution
Change the default 512-character limit to All SQL text data:
- Select Configure tab
- Select the server
- In the center panel, click on Additional
- in the SQL text data, change the option to All SQL text data.
- Click OK
After applying the configuration, move the files in the Quarantine folder back to the Packages folder to have them processed.