Questions? Feedback?powered byOlark live chat software
Bug 3321

input string was not in a correct format 11 September, 2019

Gerardo Barquero
11 September, 2019
Product: PowerServer Category: Web App
Version: 2019 Publishing: Public
Status: Analyzing Priority: P3
Classification: Issue Resolution:
Zhao Kai 11 September, 2019
Hi Gerardo,

Please note the NLS_LANG on the machine where the Appeon server located at
should be the same with the one in the database. You can go to the Register on
the server where the Appeon server is installed to check if the NLS_LANG in the
directory: HKEY_LOCAL_MACHINE>SOFTWARE>ORICAL (or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE) is the same with the one in
database. If they are different, change it as per the one in database and
restart the machine.

The NLS_LANG value is in the format
[NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET], it is
"AMERICAN_AMERICA.AL32UTF8" on our end.

Please refer to the article below for details.
https://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html

You could use the below SQL statement to check the parameter in the database.
SELECT * FROM nls_database_parameter;


Regards,
ZhaoKai
Gerardo Barquero 11 September, 2019
inputstring.png (9KB)

*Phenomenon:
I got "input string was not in a correct format" error on Appeon web when trying to retrieve a datawindow.

*Reproduce Steps:
When I run on client-server it works fine... the problem is in the web browser. 
I guess it is a problem with decimal configuration, but I cant find how to set up comma "," as decimal separator on PS.
The nls_numeric_character database parameter are equal (",.") at both sides database and PS machines.
I also checked the REGEDIT key out and it is ",." too
The only way to avoid the error is to set the REGEDIT NLS_NUMERIC_CHARACTERS key as ".," but the entire db configuration is ",." so I get other type of errors.

Thanks for your attention;
Gerardo
OS:
All 
Platform:
All 
Database Type:
Oracle 
Database Version:
11g 
OS for Mobile Device:
 
OS version for Mobile Device:
 
Mobile Device Type: