Legal Processing job hangs and no more documents are found in Legal Review. The following error is found in the Legal Review Standalone log. Legal Review Indexer actions may have failed with an error suggesting "Value of field <FIELD_NAME> is too long, it is <#_OF_CHARACTERS> but max is <MAX_#_OF_CHARACTERS> with field <FIELD_NAME>, value <VALUE>".
ERROR|[<THREAD_#>]|<HOSTNAME>|ZyLAB.EDiscovery.Common.Tools.RetryOperationHelper|Unexpected exception occurred during RetryOperation|System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.
This issue can occur when the root Parent of a family has metadata that is too large to fit the Legal Review database as declared in the Legal Review Standalone.
It is possible to either change Legal Review Standalone configuration to allow truncation of the large metadata values, or to change the database definition in the Legal Review Standalone template so to accommodate larger values. The latter may require re-processing of the data in a new Matter created with the updated Legal Review Standalone template, unless design changes can be applied to the existing Legal Review database tables.
The following steps can be followed to change Legal Review Standalone configuration to allow truncation of the large metadata values:
- Open the Legal Review Standalone configuration file "Program Files (x86)\ZyLAB\EDiscovery\LegalReview\Review_Standalone\ZyLAB.EDiscovery.Review.Standalone.WinService.exe.config" in a text editor, Notepad.
- Find the <appSettings> section and add the TruncateFieldValueBySize key to it set to True. For instance:
- Restart Legal Review Standalone service.
NOTE: These actions should be taken during an administrative time frame where restarting the Legal Review Standalone service will not affect processing of other matters.
3.6; 3.7; 3.7 Service Pack 1