Articles in this section

See more

Legal Processing job is hanging and no new documents are in Legal Review

Avatar
Eric Cremer
  • Updated
Follow

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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:
<add key="TruncateFieldValueBySize" value="true"/>
</appSettings>
  • Restart Legal Review Standalone service.
Once this configuration change is successfully applied, Legal Review Standalone will truncate the large values to fit the current database definition, and this event will be logged in the Legal Review Standalone log to allow tracking of the Document IDs where truncation has occurred.
 
INFO|[<THREAD_#>]|<HOSTNAME>|ZyLAB.EDiscovery.Review.Server.Standalone.Database.Importers.LegalReviewBaseImporter|ConstructDummyRootDocument for familyId <FAMILY_ID>|

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.

APPLIES TO

3.6; 3.7; 3.7 Service Pack 1

Was this article helpful?
0 out of 2 found this helpful
Return to top

Comments

0 comments

Article is closed for comments.