The translation memory data file engine returned an error: constraint failed UNIQUE

Hi,

I just uploaded an excel file to trados and I got this error. I am surprised because until now I have worked with this type of files and never had any problem.

This document has html language which is already configured. However I think the error is related to the TM, isn't it?

Trados Studio error message displaying 'Error: 1 (errors), 0 (warnings)' with details 'The translation memory data storage engine returned an error: constraint failed UNIQUE constraint failed: translation_units.id'.

Thank you.

Best regards,

Rita



Generated Image Alt-Text
[edited by: Trados AI at 12:56 PM (GMT 0) on 29 Feb 2024]
emoji
Parents
  • Hello Rita,

    I understand that you're encountering an error with your translation memory (TM) in Trados Studio. This error is indeed related to the TM and not the file type you're working with. Here's how you can resolve this issue:

    Step 1: Close all Trados Studio applications.

    Step 2: Navigate to the following location on your computer (you may need to enable viewing of hidden folders):

    For Trados Studio 2021: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\Studio16

    For Trados Studio 2019: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\15.0.0.0

    For Trados Studio 2017: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\14.0.0.0

    Step 3: Locate the file named 'Translation Memory Repository.xml' and rename it to 'Translation Memory Repository_old.xml'.

    Step 4: Open Trados Studio and check if the error persists.

    If the error still occurs, you can try to repair the TM using third-party applications such as the SDLTM Repair add-in available on the RWS AppStore, or the SQLite Expert trial version app.

    Remember, if your TM is stored on a network or shared drive, try copying it to your local drive (C:\ drive of your computer) and see if the error persists with this local copy as well.

    I hope this helps! If you have any other questions, feel free to ask.

    Best regards,

    RWS Community AI

    emoji
Reply
  • Hello Rita,

    I understand that you're encountering an error with your translation memory (TM) in Trados Studio. This error is indeed related to the TM and not the file type you're working with. Here's how you can resolve this issue:

    Step 1: Close all Trados Studio applications.

    Step 2: Navigate to the following location on your computer (you may need to enable viewing of hidden folders):

    For Trados Studio 2021: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\Studio16

    For Trados Studio 2019: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\15.0.0.0

    For Trados Studio 2017: C:\Users\[your User Name]\AppData\Local\RWS\Trados Studio\14.0.0.0

    Step 3: Locate the file named 'Translation Memory Repository.xml' and rename it to 'Translation Memory Repository_old.xml'.

    Step 4: Open Trados Studio and check if the error persists.

    If the error still occurs, you can try to repair the TM using third-party applications such as the SDLTM Repair add-in available on the RWS AppStore, or the SQLite Expert trial version app.

    Remember, if your TM is stored on a network or shared drive, try copying it to your local drive (C:\ drive of your computer) and see if the error persists with this local copy as well.

    I hope this helps! If you have any other questions, feel free to ask.

    Best regards,

    RWS Community AI

    emoji
Children
No Data