Error with Align Translation Units when trying to Upgrade Translation Memory

Question

Hello, here is the error message
Process failed (2023-06-05 09:47:28)
System.AggregateException: One or more errors occurred. ---> System.ServiceModel.FaultException`1[Sdl.LanguagePlatform.Core.FaultDescription]: The translation memory data file engine returned an error:
constraint failed
UNIQUE constraint failed: translation_unit_fragments.translation_unit_id, translation_unit_fragments.fragment_hash
at Sdl.LanguagePlatform.TranslationMemoryImpl.API. d__292.MoveNext()
I looked around, but I had no luck. Thank you in advance!

Paul · Answer

Josee Gordon 
 This error message suggests that there is a constraint violation happening in the database of your Trados Studio Translation Memory. This problem may be due to duplicate translation units, or parts of translation units (known as fragments) in the translation memory you're trying to update. 
 The UNIQUE constraint failed: translation_unit_fragments.translation_unit_id, translation_unit_fragments.fragment_hash error indicates that there's an attempt to insert a new record into the database that has the same values in the fields (specifically, translation_unit_id and fragment_hash ) that are supposed to be unique.. presumably the attempt made when you tried to update. 
 Can you try running a repair on your Translation Memory? Use this app: appstore.rws.com/.../41

Trados Studio > 2. Trados Studio

Error with Align Translation Units when trying to Upgrade Translation Memory