• State Suggested Answer
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 432 subscribers
  • Views 2597 views
  • Users 0 members are here
Options
Related

UNIQUE constraint failed

Pavla Voltrová

Hi All,

can you please help me with the following issue? I was adding several files to an ongoing project and while most files were uploaded smoothly, with two I got the following error: "The translation memory data file engine returned an error: constraint failed. UNIQUE constraint failed: translation_units.id"

I tried copy-pasting the content of the files into new Word documents, but these won't upload either. I tried uploading another random file and it mysteriously worked...

Can you please advise?

Many thanks!

Pavla
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
  • 0

    Hello ,

    As always, Its always worth adding the whole error stack, as this may shed some light on the problem

    Error message popup in Trados Studio with instructions: 1) Click on the icon, 2) Save the XML file to your desktop, 3) Add file to the thread.

    I would perhaps try removing the TM from the project and adding a new TM and see if the issue persists as this should show if the files or the TM is the problem.

    The following article may also help

    gateway.sdl.com/.../communityknowledge

    Lydia Simplicio | RWS Group

    _______
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 12:40 AM (GMT 0) on 29 Feb 2024]
  • 0 in reply to Lydia Simplicio

    Hello Steven,

    Thank you very much for your assistance! Please find the error report attached.

    Can you tell where the problem is?

    Thank you very much!

    Pavla

     

    Fullscreen sdlerror-2021118-21h6m49s.sdlerror.sdlerror.xml Download 
    <SDLErrorDetails time="18.01.2021 21:06:57">
  <ErrorMessage>The translation memory data file engine returned an error:
constraint failed
UNIQUE constraint failed: translation_units.id</ErrorMessage>
  <Exception>
    <Type>Sdl.ProjectApi.ProjectApiException, Sdl.ProjectApi, Version=16.0.0.0, Culture=neutral, PublicKeyToken=c28cdb26c445c888</Type>
    <HelpLink />
    <Source />
    <HResult>-2146233088</HResult>
    <StackTrace><![CDATA[]]></StackTrace>
  </Exception>
  <Environment>
    <ProductName>SDL Trados Studio</ProductName>
    <ProductVersion>Studio16</ProductVersion>
    <EntryAssemblyFileVersion>16.1.3.4096</EntryAssemblyFileVersion>
    <OperatingSystem>Microsoft Windows 10 Home</OperatingSystem>
    <ServicePack>NULL</ServicePack>
    <OperatingSystemLanguage>1029</OperatingSystemLanguage>
    <CodePage>1250</CodePage>
    <LoggedOnUser>DESKTOP-5MEFU34\Pavla</LoggedOnUser>
    <DotNetFrameWork>4.0.30319.42000</DotNetFrameWork>
    <ComputerName>DESKTOP-5MEFU34</ComputerName>
    <ConnectedToNetwork>True</ConnectedToNetwork>
    <PhysicalMemory>8183912 MB</PhysicalMemory>
  </Environment>
</SDLErrorDetails>
  • 0 in reply to Pavla Voltrová

    Hello ,

    The error is being returned from the TM.

    Have you tried removing the TM and following the steps in the Gateway article?

    https://gateway.rws.com/csm?id=kb_article_view&sysparm_article=KB0039439

    Lydia Simplicio | RWS Group

    _______
    Design your own training!
    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

  • 0 in reply to Lydia Simplicio

    Hi Steven,

    Thank you very much for your answers. There were two TMs in the project and one of them was corrupted.

    Thanks and have a great day!

    Pavla