My Oracle Support Banner

Primavera Portfolio Management (PPM) Action And Function Queues Seem To Be Hung (Doc ID 1253208.1)

Last updated on JANUARY 24, 2019

Applies to:

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

Symptoms

The Action and Function Queue seems to be stalled and will not complete processing.

PPM Console

Action Queue Viewer

Windows Services Panel

ProSight.Log file has the following error repeated numerous times:

&ltException>
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider)
at ProSight.Portfolios.Infrastructure.Database.psCommand.getIntScalar()
at ProSight.Portfolios.BusinessLogic.Infrastructure.Objects.psFunctionObj.FunctionQueue.getMaxId(Int32 iRank)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenario.psTSFunctionEngine.getMaxId(Int32 iUserID, Int32 iRank, psResultContainer oResults)
</Exception>
</Trace>
<Trace Type="Error" Time="10/14/2010 14:0:2.229" Class="psTransactionalScenarioInterface" Method="handleException" Process="prosightFunctions.exe (4464)" Client="">
Error in psTSFunctionEngine.getMaxId
&ltException>
System.InvalidCastException: Object cannot be cast from DBNull to other types.
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.shouldRetry(Exception iEx, Int32 iRetries, Int32 iMaxRetries)
at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)
</Exception>
</Trace>
<Trace Type="Error" Time="10/14/2010 14:0:2.245" Class="psFunctionDispatcher" Method="run" Process="prosightFunctions.exe (4464)" Client="">
Error in function dispatcher execution loop.

*Note that other functionality can be affected when PPM loses connectivity with the database. For example, email alerts may fail to run as PPM cannot read the object id's needed from the database. Here is an example of the error that is generated:

<Trace Type="Error" Time="[Date & Time]" class="psEventAlertMultiplier" Method="run" Process="prosightService.exe (1336)" Client="">
psEventAlertMultiplier.run: error
ProSight.Portfolios.Infrastructure.Exceptions.psObjectDoesNotExistException: Primavera Portfolio Management Context Object for ContextID: 2992b6b4-394d-44aa-a23e-7cb54ccad9dc:207346 Does not exist
</Trace>

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.