Extremely Long Action and Function Queue Run Times

(Doc ID 1364571.1)

Last updated on JULY 26, 2016

Applies to:

Primavera Portfolio Management - Version 7.5SP1 to 9.0 [Release 7.5 to 9.0]
Information in this document applies to any platform.

Symptoms

On : Primavera Portfolio Management 7.5 SP1 version (or more recent):

ACTUAL BEHAVIOR
---------------
The Action and Function queue takes an unusually long time to process. The queue may appear to be stalled or hung.

ERROR
-----------------------
Prosight.log file may contain these errors:
1. System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
2. Couldn't read request for cloned buffer. System.NullReferenceException: Object reference not set to an instance of an object.

EXPECTED BEHAVIOR
-----------------------
While queueing of actions is expected under heavy loads, normally the Action and Function queue will process actions as they enter the queue without delay.

BUSINESS IMPACT
-----------------------
Due to this issue, Actions and Function calculations are not processing in a timely fashion possibly showing invalid data for hours.

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