PostgreSQL Connector Time Zone Error
Article ID: KB0078244
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
When trying to connect to the PostgreSQL server using the TIBCO Scribe ® Online Connector for PostgreSQL, you may encounter an exception with the following error:
[500] Unable to resolve the timezone "{timezone name}" to one recognized by the system
The issue is that the CData PostgreSQL ADO.NET provider relies on the time zone’s StandardName, which is the display name of the time zone. The display name is localized based on the culture installed with the Windows operating system.
[500] Unable to resolve the timezone "{timezone name}" to one recognized by the system
The issue is that the CData PostgreSQL ADO.NET provider relies on the time zone’s StandardName, which is the display name of the time zone. The display name is localized based on the culture installed with the Windows operating system.
Issue/Introduction
Solution for the following time zone error: [500] Unable to resolve the timezone "{timezone name}" to one recognized by the system
Resolution
Resolution
Change the language settings on the Windows account where the TIBCO Scribe ® Online Agent is installed. The TIBCO Scribe ® Online Agent uses the Local System account by default.
WARNING: Changing language settings for the Local System account can affect other applications and/or services that run under the Local System account. To overcome this issue, you can change the TIBCO Scribe ® Agent service to use a different Windows account and update the regional settings for that account instead. See Changing The Agent Windows Service To Run As Another User.
Changing your display language allows you to change the language your entire Windows operating system will use. After installing the language pack, set that language as default to change the Windows 10 display language.
- Go to Control Panel > Language.
- Find English (United States) in the languages list and select the Options link.
If English (United States) is not listed, click the Add a language button.
- On the Language Options screen, under Windows display language, select Make this primary language.
- Log off and back on for the display changes to take effect.
Feedback
Yes
No
Powered by
