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

Last updated on APRIL 29, 2016

Applies to:

Primavera Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.
Checked for currency on 20-Aug-2012

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.

*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>

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