ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Using Windows Regional Settings

book

Article ID: 20548

calendar_today

Updated On:

Products

APPLICATION DELIVERY ANALYSIS SUPERAGENT CA Infrastructure Performance CA NetVoyant (NetQoS / NV) CA eHealth

Issue/Introduction

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-

Environment

Release: RAIB1H99000-9.1-Network Flow Analysis-Interface Bundle-Hardware
Component: