Using Windows Regional Settings

Document ID : KB000020548
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

ISSUE

Having incorrect Regional settings on the server can cause various errors in the web interface and in the product logs (any product) with errors referencing invalid Int32 strings, invalid input string, and/or invalid DateTime entries.

DETAILS

This issue is caused when Windows servers is/are using non-US regional settings, or using date formats set to: dd MMMM yyyy.

An example of this is having regional settings set to "English (United Kingdom)".

All products require that the Regional Settings on the server be set to US Regional settings with the proper sShortDate and sLongDate settings in the registry.

Solution:

You can run the USsettings.exe included in the NQ Support Tools and reboot the server to apply the below changes, or you can perform the steps manually as described below.

  • Enter the Windows regional settings menu through Control Panel on the server itself.
  • Modify this setting to "English (United States)".
  • Click OK.
  • Now, enter the Windows Registry, and highlight My Computer.
  • Go to Edit > Find, and search for string 'yyyy'.
  • Change only keys sLongDate and sShortDate to the following values:

    sLongDate = dddd, MMMM dd, yyyy sShortDate = M/d/yyyy

  • Also change all sdecimal settings from "," to ".".
  • Use the F3 key to continue searching the registry for more instances of these keys.
  • Keep doing so until it states it has finished searching the registry.
  • The regional settings change in the control panel doesn't always update every registry entry and that can still affect the database if all entries are not updated manually in the registry. This is a windows issue, so the full search through the registry is necessary.
  • After all changes are made, Restart the Server to apply the registry changes.

You might also reference this site for any further registry changes that need to be made to resolve errors. The above steps should be all that is needed in most cases:

http://www.windowsitpro.com/article/registry2/jsi-tip-0311-regional-settings-in-the-registry-