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 11, 2016

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:/v02/OFSAA/
[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 dsnmaster 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 dsnmaster dsnm join db_master 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 i18nmaster) 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 i18nmaster 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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms