A package which contains a Before\After value that exceeds 3500 characters cannot be processed and is sent to Quarantine on the central server (4379147)

Steps to reproduce the issue:

1. Start ApexSQL Audit and add a server and database for Before-after auditing
2. Connect to the audited database in SSMS and create a simple table:
   
   create table BeforeAfterLimitTest (
   ID int,
   ColumnString  varchar(max)
   )
   
   
3. Add the table to Before-after auditing
   Insert a value into the BeforeAfterLimitTest that exceeds the limitation:
   insert into dbo.BeforeAfterLimitTest
   values(2, '
   0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B0x00D335000245EF459336BBDB5C29B2E4020000007C3F9DCBFB85B30C381D632ED75F33E2311D2D9D91432263D980EE2B887D0A4B
   ')
   
   The central server throws an error:
   [CENTRAL]: An exception occurred
   String or binary data would be truncated.
   The statement has been terminated.

and the package is eventually sent to Quarantine

ERROR [CENTRAL]: Package 63dff5be-5abb-4c4c-ae35-eb6733a8104c.ApexSqlComplyPackage will be moved to quarantine folder due to following error: String or binary data would be truncated.
The statement has been terminated..

NOTE: The continuous attempt of processing the packages that exceed the Before-after limit causes accumulation of files in the ReceivedPackages folder

Expected result: The exception for exceeding the character limit is properly handled within the central process.

BUG 236792

WORKAROUND 1

Change columns from nvarchar(max) to nvarchar(3000)

WORKAROUND 2

Exclude columns with nvarchar(max) from the before/after audit

Note: There is not straight answer to convert document size to string value. That process entirely depends on the user application and use of the document upload + columns. 

STATUS

Waiting for for fix in a future release of ApexSQL Audit