Function Engine Continues To Process Slowly

(Doc ID 1480140.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

On OPPM 9.0SP1, after upgrading the server RAM, the application was reinstalled successfully but the function engine continues to process slowly and the Actions queue will not clear.

The SQL Server normally times out with a deadlock.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Indicators and advanced function calculation categories do not update after user entry due to function engine backlog.

Changes

Server's RAM was upgraded on the Frontend and Backend servers to 32GB

SQL server at 64GB.

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