GroupShare: Error "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM." when publishing a project to GroupShare server from Studio
000011846|2/14/2020 10:48 AM
SDL Trados Studio 2017 SR1
SDL Trados Studio 2019 SR2
SDL Trados GroupShare 2017 SR1
SDL Trados GroupShare 2020
When you are trying to publish a project from SDL Trados Studio 2017 or 2019 to a GroupShare server, you get the following error message:
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
At least 1 source file used in the project has no Date modified visible in Windows Explorer.
If you check its/ their properties (right-click on the files and select Properties), the Modified date is older than 1/1/1753.
The reason why some files end up with such Date modified dates is unknown. The Date modified for files can be changed using some PowerShell scripts but it is unclear how this happens "by mistake" because it is very unlikely someone would set this on purpose. The earliest/latest dates that can be read by Windows Explorer: 1980,01,01, 00,00,00 2107,12,31, 23,59,00
WORKAROUND A Recreate the project from the GroupShare Web Interface (GS WebUI)
Upload the project template file (.sdltpl) you use into the GS WebUI in Resources > Project templates. If the project template is not yet saved, right-click on your project in the Studio project list and select Create Project Template
Use the uploaded project template to create the project in the GS WebUI
Apply Pre-translate or Perfect Match batch tasks to re-import the already translated content from the initial project. This needs to be done in Studio once the project was successfully created in the GS WebUI
WORKAROUND B Recreate the project in SDL Trados Studio
Open the affected source files in a file editor (Notepad or Notepad++) and save them. this will change the Date modified.
Recreate the project in Studio
Apply Pre-translate or Perfect Match batch tasks to re-import the already translated content from the translation memories or from the initial project.