OFSAA Server Initialization Failed: ORA-00068: invalid value 0 for parameter _query_execution_time_limit, must be between [] (Doc ID 2151986.1)

Last updated on JULY 29, 2024

Applies to:

Symptoms

When attempting to restart OFSAA server, nothing happened and the below error was triggered in nohup.out

ERROR

FIC_HOME:<FIC_HOME>
[21-06-16 17:03:22,643 PM]~[ERROR]~[ApplicationResources]~[getInnerInstance]~ApplicationResources is not initialized. Please initialize vy restarting the container.
[21-06-16 17:03:22,752 PM]~[INFO ]~[PreparedStatementDecorator]~[<init>]~PreparedStatement Query: SELECT dsnid FROM dsn order by DSNID
[21-06-16 17:03:22,758 PM]~[ERROR]~[ApplicationResources]~[getInnerInstance]~ApplicationResources is not initialized. Please initialize vy restarting the container.
[21-06-16 17:03:22,817 PM]~[INFO ]~[PreparedStatementDecorator]~[<init>]~PreparedStatement Query: select dsnm.dsnid, dbm.dbname, dbm.jdbcdrivername, dbm.jdbcconnstr, dbm.dbuserid, dbm.dbpasswd, dbm.dbtype from dsn dsnm join db_dbm on dbm.dbipaddress = dsnm.dbserver and upper(dbm.dbname) = upper(dsnm.dbname) where dsnm.dsnid in (?,?,?,?,?,?)
[21-06-16 17:03:22,825 PM]~[ERROR]~[ApplicationResources]~[getInnerInstance]~ApplicationResources is not initialized. Please initialize vy restarting the container.
[21-06-16 17:03:22,881 PM]~[INFO ]~[PreparedStatementDecorator]~[<init>]~PreparedStatement Query: select distinct conf.paramname, conf.paramvalue from configuration conf
[21-06-16 17:03:22,909 PM]~[ERROR]~[ApplicationResources]~[getInnerInstance]~ApplicationResources is not initialized. Please initialize vy restarting the container.
[21-06-16 17:03:22,965 PM]~[INFO ]~[PreparedStatementDecorator]~[<init>]~PreparedStatement Query: SELECT parametername, value FROM localerepository WHERE localecontext IN (SELECT namespace FROM i18n) AND parametername = 'POSTFIXSTRING' AND localecontext = 'INSTALL' AND revlocale in (SELECT DISTINCT revlocale FROM localerepository a WHERE a.localecontext = 'INSTALL' AND a.localecontext IN (SELECT namespace FROM i18n b WHERE a.revlocale = b.revlocale))
[21-06-16 17:03:22,976 PM]~[WARN ]~[ApplicationResources]~[getDBInstalledLocales]~Error while getting all installed locales
java.sql.SQLException: ORA-00068: invalid value 0 for parameter _query_execution_time_limit, must be between 1920300144 and 101

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.