Follow

Restore fails on single case

Created by: Tod Ewasko
Created date:
Last Updated date:

Problem

User attempts to restore a case in dbconfig and receives the following error in the system log:

Project creation exception: String or binary data would be truncated.
The statement has been terminated.

and then

AppDB project creation failed during sync-up operation between AppDB and UnifiedDB for CaseName : My Case Name, CaseUUID : 1a5ba3bb-87b8-446e-8896-94f63b0520a3

Resolution

Locate the casedescription field. This will differ depending on the version the backup came from and what application did the backing up, the field it will be in one of the xml files located in the backup directory app.xml or map.xml.

          <Extra Key="casedescription" Value="String:" />

The field is limited to under 200 characters, if this value is higher the syncing will fail to the legalmatters table which will fail to show in the we user interface. Clear this field out, like you see above.

Cause

The casedescription field is limited to 256, however the restore process uses FTK case sync and that adds ~40 characters to the case description which causes a failure when attempting to insert too much text into the legalmatters table.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk