The below error occurs when opening project file in Online Editor or Trados Studio Corrupt file: Missing id attribute for element: Oasis.Xliff12.g Same error is logged in sdl.application.log as well |
select * from sts.Resource where resourceguid = '<Project_GUID_Here>' -- Query 1
select * from proj.ProjectFile where ProjectId = <resourceid_from_Query 1> --Query 2
select * from proj.LanguageFile where ProjectFileId = <Projectfileid_from_Query 2> -- Query 3
(If multiple files present, check files for the TargetLanguage direction in next query else skip next Query.
select * from proj.LanguageDirection where LanguageDirectionId = <LanguageDirectionId_from Query 3>
SELECT F.FileUniqueId,F.LanguageFileId,f.FileTimeStamp,f.VersionNumber,f.LatestVersion,F.Name
FROM proj.[File] AS F
JOIN proj.LanguageFile AS LF ON F.LanguageFileId = LF.LanguageFileId
JOIN proj.ProjectFile AS PF ON LF.ProjectFileId = PF.ProjectFileId
JOIN sts.[Resource] AS R ON PF.ProjectId = R.resourceId
WHERE R.resourceGuid like '<Project_GUID_Here>'
AND LF.LanguageFileUniqueId like '<LanguageFileUniqueID_from_Query 3>' and f.LatestVersion=1 --Query 4
|
When an editor or a translator is working on a file in Trados GroupShare Online Editor with track changes applied, when the user tries to add or delete track changes in segment data, formatting data is missed while updating the sdlxliff file. Since formatting data updates with a blank value, sdlxliff file becomes corrupt and error would be displayed when it is opened in Online Editor or Trados Studio. |