Slow Drawing and Scrolling of Project View in P6 Professional (Doc ID 2256988.1)

Last updated on MAY 05, 2017

Applies to:

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

Symptoms

After the project view data is loaded, when the projects grid is first displayed, there is a database query executed for each and every displayed row.
If you scroll down to display more rows, the new rows continue to invoke database calls. The SQL query indicates it's getting the project open/locked status for each row.

This only happens for direct db connection (not cloud connect).
Once you scroll through the entire view, it will stop querying the database.
But,  if you change the grouping, it will start querying all over again.
This becomes noticeable when database latency is around 5ms, the drawing becomes sluggish.


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