Sentinel: DAS processes language must match the Oracle software language.

  • Document ID:3306569
  • Creation Date:07-May-2007
  • Modified Date:26-Apr-2012
    • Micro Focus Products:
      Sentinel

Environment

Sentinel 6
Oracle

Situation

During the install of Sentinel 6, the DAS processes (also referred to as Sentinel Server) language selection was different than the language selected for the Oracle software install.
Following error messages are observed in the $ESEC_HOME/log/das_*.log files:

ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified - SQLState : 60000 - ErrorCode :604

Resolution

To modify the language the DAS processes will run in:

1) Make a backup copy of the configuration.xml
2) Open the configuration.xml file for editing.
3) Search for all instances of "-Duser.language=" and"-Duser.country=" (without the quotes). The value of these properties determines the language DAS will run in.
4) Modify the value of the properties above to the desired language.
5) Save the configuration.xml
6) Restart the Sentinel service.
Valid values for -Duser.language:

en (English)
de (German)
es (Spanish)
fr (French)
it (Italian)
ja (Japanese)
pt (Portuguese)
zh (Chinese)

Note: Any other value will default English.

In addition, if -Duser.country=TW is specified with -Duser.language=zh
traditional Chinese will be set as the language.
Specifying -Duser.lanauge=zh with -Duser.country set to any other value other than TW will result in the language being simplified Chinese.

If -Duser.language or -Duser.country is omitted, the default value will be taken from the underlying operating system.
-Duser.country can be any valid two-letter code according to Java standards. http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html

Additional Information

Found the error below in all of the log files of all the das processes that access the database:
Wed Apr 18 17:32:13 EDT 2007|Timer-0|SEVERE|esecurity.base.exceptions.DBConnectException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
- SQLState : 60000 - ErrorCode : 604
at esecurity.base.db.connection.DBConnectionPool.getNewConnection(DBConnectionPool.java:335)
at esecurity.base.db.connection.DBConnectionPool.getConnection(DBConnectionPool.java:127)
at esecurity.base.db.connection.DBConnectionManager.getConnection(DBConnectionManager.java:185)
at esecurity.base.ccs.comp.dataobject.ConnectionManager.fetchConnection(ConnectionManager.java:131)
at esecurity.base.ccs.comp.dataobject.ConnectionManager$ConnectTask.run(ConnectionManager.java:191)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at esecurity.base.db.driver.AbstractProxyDriver.connect(AbstractProxyDriver.java:139)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at esecurity.base.db.platform.DefaultPlatform.getNewConnection(DefaultPlatform.java:365)
at esecurity.base.db.connection.DBConnectionPool.getNewConnection(DBConnectionPool.java:327)
... 6 more
||||esecurity.base.ccs.comp.dataobject.ConnectionManager|fetchConnection|