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 NOVEMBER 28, 2022

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 */ projwbs.proj_id, projwbs.wbs_id, projwbs.parent_wbs_id, projwbs.wbs_short_name,
projwbs.obs_id, projwbs.proj_node_flag, project.project_flag, project.msp_managed_flag, project.orig_proj_id, projwbs.status_code,
project.checkout_flag, wbs_name from projwbs, project where project.proj_id=projwbs.proj_id and (<multiple projwbs.proj_id selection criteria> ...

(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)

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

 

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.

Changes

 

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.