My Oracle Support Banner

Opening a Project(s) Hangs and Finally Fails With Error "Unable To Load Data" (Doc ID 2743397.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

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

Symptoms

When opening a project the application hangs/freezes, and finally fails with the following error.

Unable to load data.

In addition, the following long-running query can be found in a trace log created via How To Trace SQL And Java From The P6 Web Access Server (Doc ID 894429.1):

E=### F=##### #1302671 U155 select /*+ NO_EXPAND */ <complex SELECT statement>

(where the F= value is at least a four- or five-digit number, indicating that the identified SQL statement takes a very long time to process)

 

The issue can be reproduced with the following steps:

  1. In P6 Web, navigate to the Projects view, or to a Dashboard where a project can be opened.
  2. Open a project.
  3. Observe the Projects > EPS page hangs, then fails with the reported error.

 

This issue may also cause the P6 managed server to crash after a restart.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.