Portingset installed into Test environment on new server. get following error when trying to connect via BW client after installation.


Fatal error : Error 402 (configuration error detected) on SELECT
Fatal error : Can not continue in ottstpstdlib (mess)

System working ok prior to portingset install.

Any ideas please.

This is a new server running AIX 5.3 and Oracle 10.2.0g

From the Tools manual:
402 ECONFIG - Configuration error
Description:
This error indicates that one of database driver resources contains an invalid value or conflicting value. See the log file for more detailed information.
Solution:
XXXXXXXXX
Post the contents of the db_resource file of your system.

This is the last message in the log.oracle file. Is this helpful?

log.oracle8" 142 lines, 10658 characters
2007-09-05[16:25:31]:E:callaghc: Errno 0 bdb_errno 0
2007-09-05[16:25:31]:E:callaghc:
2007-09-05[16:25:31]:E:callaghc: dbs_errno = 0, Error 402 occurred:
2007-09-05[16:25:31]:E:callaghc: Incompatible NLS Characterset settings:
2007-09-05[16:25:31]:E:callaghc: Client: NLS_LANG = '' --> characterset 'US7ASCI
I'
2007-09-05[16:25:31]:E:callaghc: Server: NLS_CHARACTERSET = 'WE8ISO8859P1'
2007-09-05[16:25:31]:E:callaghc: Logon failed; errno 402
2007-09-05[16:25:31]:E:callaghc: Flushed at /BAAN/view/port.6.1c.07.15/vobs/tt/s
ervers/ORACLE_2/ora_driver.c : #215.
2007-09-05[16:25:31]:E:callaghc: ******* E N D of Error message *******
~
~

Found this string on another thread which admittedly was for windows not Unix and added it to the $BSE/lib/defaults/db_resource file and I can now login.

The oracle log file indicated there was an NLS_LANG issue.

Will have to test more thoroughly of course and will post back here

nls_lang:AMERICAN_AMERICA.WE8ISO8859P1

Thanks for your help.

:):) :)

Hi,
I'm in Italy and am having the same problem on a Windows 2003 server. What would the nls_lang parameter be set for Italy? I have no clue.

Thanks.

Hi,
I'm in Italy and am having the same problem on a Windows 2003 server. What would the nls_lang parameter be set for Italy? I have no clue.

Thanks.


Hello,

for Oracle 10g on MS-2003 Server:

in $BSE/lib/ora/set_ora10

NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

must be ok.

Regards

Found this string on another thread which admittedly was for windows not Unix and added it to the $BSE/lib/defaults/db_resource file and I can now login.

The oracle log file indicated there was an NLS_LANG issue.

Will have to test more thoroughly of course and will post back here

nls_lang:AMERICAN_AMERICA.WE8ISO8859P1

Thanks for your help.

:):) :)

What is your database's actual character set?
if it's US7ASCII like your old file you get corrupt data.

Dave

Hi bdk9904.

I run AIX here and know nothing about environment for Oracle/baan on windows but i know that nls-param needs to be set in registry. Oracle website is probably the best resource.

I think the nls_param for italy should be NLS_LANG=ITALIAN_.WE8MSWIN1252 .