My Oracle Support Banner

Data Does Not Load in Team Member Web Application and 'Loading' Icon Continues to Spin until an Error Displays (Doc ID 3017571.1)

Last updated on JUNE 13, 2024

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 24.1 to 24.4 [Release 24.1 to 24.4]
Primavera P6 Team Member - Version 22.12 to 22.12.13.0 [Release 22.12]
Information in this document applies to any platform.

Symptoms

When attempting to view My Activities data in the Team Member Web application, the "Loading" icon continues to spin until the following Alert eventually occurs.

Alert

TeamMemberServicesException: tm_load_primaryresourceactivity_error$@#DBEngine.executeSelect() error while executing: {<a very long complex SELECT query>}
  --IO Error: Socket read timed out

A corresponding error is also found in the <P6 EPPM home>\tmws\p6tmweb.log file:

SEVERE: Failed to load tasks with filter -activeAndCompleted
com.oracle.pgbu.teammember.services.common.TeamMemberServicesException: tm_load_activities_error$@#tm_load_primaryresourceactivity_error$@#DBEngine.executeSelect() error while executing: {<same complex SELECT query>}
--Connection has been recycled. Database: XXXXX, Pool: PMR, Id: #
          . . .
          Caused by: com.oracle.pgbu.teammember.services.common.TeamMemberServicesException: tm_load_primaryresourceactivity_error$@#DBEngine.executeSelect() error while executing: {<same complex SELECT query>}

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.