PostgreSQL Connector Input string was not in correct format
Article ID: KB0079027
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | 1.0 |
Description
When using the PostgreSQL Connector, if the PostgreSQL database contains values that are Arbitrary Precision numbers, such as decimal or numeric data types,or Floating Point data types, such as real or double precision, you may encounter errors similar to the following:
FormatException
Input string was not in correct format.
This is caused because the CData PostgreSQL ADO.NET uses the regional settings for the current application user, such as a comma for a decimal separator instead of a period. However, the PostgreSQL Connector always uses a period as the decimal separator.
FormatException
Input string was not in correct format.
This is caused because the CData PostgreSQL ADO.NET uses the regional settings for the current application user, such as a comma for a decimal separator instead of a period. However, the PostgreSQL Connector always uses a period as the decimal separator.
Issue/Introduction
If you are working with Arbitrary Precision numbers or Floating Point types, you may encounter a format exception with the message Input string was not in correct format.
Resolution
Change the regional 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 regional 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
Steps to change regional settings of Local System account:
WARNING: Changing regional 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
Steps to change regional settings of Local System account:
- Open the Windows Services panel.
- Locate the TIBCO Scribe Online Agent and stop the service.
- Open the Windows Control Panel and navigate to the Region dialog.
- On the Formats tab change the Format drop-down to English (United States)
- Select the Additional Settings button, ensure that you have a period (.) as the Decimal symbol, and close the Customize Format dialog.
- In the Region dialog on Formats tab, click Apply.
- Select the Administrative tab and click Copy Settings button. The Welcome screen and new user accounts settings dialog displays.
- Check the Welcome screen and system accounts checkbox.
- In the center panel, ensure that under the Welcome screen section you see English (United States) as the format and click OK.
- Return to the Windows Services panel and restart Scribe Online Agent service.
Feedback
Yes
No
Powered by
