Could Not Initialize PsReservedProperties Appears in ProSight Log Files (Doc ID 2172003.1)

Last updated on AUGUST 12, 2016

Applies to:

Primavera Portfolio Management - Version 15.1.1.3 and later
Information in this document applies to any platform.

Symptoms

On OPPM version 15.1.1.3

On the Frontend application server of a scaled-out configuration, the following error occurs:

ERROR
-----------------------
ORA-03135.


Could not initialize psReservedProperties
USERID: 0
DEADLOCK DETECTED: False

&ltException&gt
ProSight.Portfolios.Infrastructure.Exceptions.psInternalException: Oracle.DataAccess.Client.OracleException ORA-03135: connection lost contact
Process ID: 12789
Session ID: 1155 Serial number: 2177 at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
 at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
 at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
 at ProSight.Portfolios.Infrastructure.Database.psBaseConnection.executeOracleQuery(String iQuery, IDbConnection iCon)
 at ProSight.Portfolios.Infrastructure.Database.psBaseConnection.setIsolationLevel(IDbConnection iCon, Int32 iProvider, Int32 iIsolationLevel, Int32 iSQLServerLockTimeOut)
 at ProSight.Portfolios.Infrastructure.Database.psConnection.getNonDTSConnection()
 at ProSight.Portfolios.Infrastructure.Database.psCommand.openConnection()
 at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataTableAddToDataSet(DataSet iDataSet, String iNewTableName, Int32 iTableIndex)
 at ProSight.Portfolios.Infrastructure.Database.psCommand.getDataRow()
 at ProSight.Portfolios.Infrastructure.Database.psCommand.refreshTimeDiffFromDB()
 at ProSight.Portfolios.BusinessLogic.Infrastructure.Queries.psCacheQuery.CacheTimestamp.fetchTimeStamp(String iName



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