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

Last updated on FEBRUARY 21, 2023

Applies to:

Symptoms

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

PPM Console

• Indicates successful connection to back-end database
• Functions indicator has a red status (hovering over the red status indicator displays: 'Functions: stopped')

Action Queue Viewer

• One or more actions contain a POP value of '1' (indicating the number of retries)
• Actions with POP value of '1' also have a status of ‘Persistent’
• Vast majority of actions in the queue are of the 'Change Portfolio Hierarchy' type (where portfolios are either being added to or removed from other portfolios)
• Actions with POP value of '0' or '1' that have a status of 'Restore'

Windows Services Panel

• 'PPM Functions' service has a status of 'Starting'
• 'PPM Service' and 'PPM Watchdog' show that they are started

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.

Changes

Cause

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