15.1 Intensive Query Runs Once per Minute After Summarize Job Completes (Doc ID 2104996.1)

Last updated on MARCH 08, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

The following query runs once a minute after a summarize job completes.


EXPECTED BEHAVIOR
-----------------------
The query should only run once after a summarize job.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into P6 web
2. Ensure projects have changed since the last summarization.
3. Summarize a project or group of projects.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The query can return a significant number of rows and is consuming database resources.

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