My Oracle Support Banner

Accessing Resources Tab In P6 Web Either Fails Or Triggers Performance Issues (Doc ID 2562104.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.9.0 to 16.2.17.0 [Release 16.2]
Information in this document applies to any platform.

Symptoms

DESCRIPTION OF THE LOSS OF FUNCTIONALITY
----------------------------------------------
In Oracle Primavera Web, opening Resources Tab hangs and the background query is causing locks on the database.


SELECT rsrc.rsrc_id ResourceId,rsrc.rsrc_name ResourceName,rsrc.clndr_id CalendarId
FROM rsrc
WHERE (((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>)) OR ((rsrc.rsrc_id>=<rsrc_id>) AND (rsrc.rsrc_id<=<rsrc_id>))..........

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.