Options
Tags:
Related
Recommended

SDL TMS 2011 SP5 CU2 | Status and Last Refresh sometimes not updating correctly for the GroupShare Inbox in SDL TMS

Judith de Jong

Symptoms:
Sometimes in SDL TMS within the GroupShare Inbox, the Status may not update or the date of the Last Refresh may be incorrect.

Explanation:
When the server hosting the SDL TMS application and the server hosting the TMS Microsoft® SQL database do not share the same date format, the following errors may occur:

  • Status not updating

    • The current date and time on the operating system (OS) hosting the SQL Server is set to an Invariant Culture format like: 03/17/2015 15:39:05 (Tuesday March 17 2015, 3:39:05 PM).
    • The date format in the regional settings of the user account running the TMS services is different from the Invariant Culture format. For example, in the case of en-GB, the month and date are reversed compared to the Invariant Culture format. In the above example, the expected representation of the current time would be: 17/03/2015 15:39:05.
    • When retrieving the status, the conversion from the Invariant Culture format to the en-GB format fails with an exception because 17 is an invalid month.

    As a consequence, the status update process is aborted and the Status displayed in the GroupShare Inbox is incorrect.

  • Incorrect Last Refresh date

    • The current date and time on the OS hosting the SQL Server is set to an Invariant Culture format like: 03/12/2015 15:39:05 (Thursday March 12 2015, 3:39:05 PM).
    • The date format in the regional settings of the user account running the TMS services is different from the Invariant Culture format. For example, in the case of en-GB, the month and date are reversed compared to the Invariant Culture format. In the above example, the expected representation of the current time would be: 12/03/2015 15:39:05.
    • When converting from the Invariant Culture format to the en-GB, no error is displayed because 12 is a valid month.

    As a consequence, the value shown in the GroupShare Inbox for the Last Refresh is wrongly displayed as: 03/12/2015 15:39:05 (namely, Saturday December 12, 2015 3:39:05 PM).

Resolution:
The solution proposed in this hotfix allows proper handling of date/time mismatches between servers, thus enabling users to read correct Status and Last Refresh information in the GroupShare Inbox.

SDL-hosted customers should contact SDL Support to arrange for a hotfix to be deployed.

Customers who host TMS themselves should download the installer for SDLTMS2011SP5CU2 Hotfix for 36580.exe from the following FTP site: ftp://sdlpatches:5dlpatch35@ftp-emea.sdlproducts.com/SDL TMS/2011 SP5/CU2/Hotfix.