The OPPM (Application Website) Becomes Inaccessible After OPPM Console Restart

Last updated on DECEMBER 08, 2016

Applies to:

Symptoms

On : 15.1.1.1 version, Setup Module

When attempting to OPPM login page,
the following error occurs.

ERROR
-----------------------
OPPM is currently under maintenance and unavailable

<Trace Type="Error" Time="10/11/2016 4:23:50.199" Class="HierarchyGraphCache" Method="get_Graph" Process="w3wp.exe (3840)" Client="">
Could not initialize dependencies graph
&ltException&gt
System.NullReferenceException: Object reference not set to an instance of an object.
at ProSight.Portfolios.Infrastructure.Database.psOracleFactory.createCommand()
at ProSight.Portfolios.Infrastructure.Database.psCommand..ctor()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Queries.psCacheQuery.getMaxCacheMessage()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.IpsWriteThroughCache.getInitialLoadMessageID()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.DependenciesGraph.HierarchyGraphCache.get_Graph()
&lt/Exception&gt
</Trace>
<Trace Type="Error" Time="10/11/2016 4:23:50.261" Class="psException" Method="printException" Process="w3wp.exe (3840)" Client="">
Could not initialize psReservedProperties
USERID: 0
DEADLOCK DETECTED: False

&ltException&gt
ProSight.Portfolios.Infrastructure.Exceptions.psInternalException: System.NullReferenceException: Object reference not set to an instance of an object.
at ProSight.Portfolios.Infrastructure.Database.psOracleFactory.createCommand()
at ProSight.Portfolios.Infrastructure.Database.psCommand..ctor()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Queries.psPropertiesQuery.get(String iType, String iName)
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psPropertiesObj.get(String iName, String iType)
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psVersionObj.checkServer2DBCompatibility()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psDiagnosticsObj.isDBVersionUpToDate()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psTransactionContextObj.create(Boolean iCheckCacheMessages, Boolean iForceCheckCacheMessage, Int32 iTransactionIsolationLevel, Int32 iTransactionMode)
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psTransactionContextObj.create(Boolean iCheckCacheMessages, Boolean iForceCheckCacheMessage, Int32 iTransactionIsolationLevel, Int32 iTransactionMode)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenario.psTransactionalScenario.beginTransaction(Int32 iUserID, Int32 iIsolationLevel, Int32 iTransactionMode, Boolean iForceSync)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenario.psTransactionalScenario.beginTransaction(Int32 iUserID, Int32 iIsolationLevel, Int32 iTransactionMode)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenario.psTSProperties.initReserverdProperties()
&lt/Exception&gt
</Trace>
<Trace Type="Error" Time="10/11/2016 4:23:50.261" Class="HierarchyGraphCache" Method="get_Graph" Process="w3wp.exe (3840)" Client="">
Could not initialize dependencies graph
&ltException&gt
System.NullReferenceException: Object reference not set to an instance of an object.
at ProSight.Portfolios.Infrastructure.Database.psOracleFactory.createCommand()
at ProSight.Portfolios.Infrastructure.Database.psCommand..ctor()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Queries.psCacheQuery.getMaxCacheMessage()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.IpsWriteThroughCache.getInitialLoadMessageID()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Caches.DependenciesGraph.HierarchyGraphCache.get_Graph()
&lt/Exception&gt
</Trace>

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. try to access OPPM.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access OPPM.

Cause