Error "Journal item (...) can't be saved to DB" occurs during Journal Synchronization

SYMPTOMS

The following message is logged at ERROR level in the ZyLAB Exchange Service log during Journal Synchronization. As a result, the offending item is moved to a Journal Inbox subfolder for further analysis.

ZyLAB.EDiscovery.Exchange.Standalone.ExchangeSync.ExchangeSyncHelper - Journal item (IMid: <InternetMessageID@domain.com>, subject "<EMAIL_SUBJECT_HERE>") can't be saved to DB
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at ZyLAB.EDiscovery.Exchange.Standalone.Database.MailboxSyncStateDbRepository.AddJournalItem(UnwrappedJournalItem journalItem)
   at ZyLAB.EDiscovery.Exchange.Standalone.ExchangeSync.ExchangeSyncHelper.<>c__DisplayClass13.<>c__DisplayClass21.<SynchronizeJournalItems>b__8()
ClientConnectionId:6f2cbb6c-1e69-4279-abb0-0ce90243f393

CAUSE

Attributes like Subject, Sender, or InternetMessageID of at least one item cannot be stored in the database due to its current design.

RESOLUTION

If ZyLAB Exchange Service runs into this issue during Journal Synchronization, the data in the Journal mailbox is of an unexpected format.
Please retrieve the offending item(s) from the 'ZyLAB' Journal Inbox subfolder, and review the existing Exchange Journal rule.

• If system mailboxes like Content Rule or AntiSpam Qurantines are being journaled, we recommend to change the Journal rule so that only user mailboxes are journaled. If it is required to synchronize system mailboxes also, special considerations should be made. Please contact ZyLAB Support referencing this knowledge base article.
• If only the intended user mailboxes are journaled, and the offending message is legitimate, please contact ZyLAB Support.

Please note that general database design recommendations take performance into account and are valid for most case use scenarios. If it is intended to synchronize system mailboxes, or if the Exchange configuration has been changed to allow for instance bigger subjects than what is recommended by RFC 2822 (Internet Message Format), then the ZyLAB Database design should be changed accordingly.

APPLIES TO

3.7 Service Pack 1