My Oracle Support Banner

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:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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