My Oracle Support Banner

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

Last updated on JULY 27, 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>=67337) AND (rsrc.rsrc_id<=67351)) OR ((rsrc.rsrc_id>=68428) AND (rsrc.rsrc_id<=68441)) OR ((rsrc.rsrc_id>=69767) AND (rsrc.rsrc_id<=69783)) OR ((rsrc.rsrc_id>=77431) AND (rsrc.rsrc_id<=77442)) OR ((rsrc.rsrc_id>=80207) AND (rsrc.rsrc_id<=80225)) OR ((rsrc.rsrc_id>=80987) AND (rsrc.rsrc_id<=81001)) OR ((rsrc.rsrc_id>=81346) AND (rsrc.rsrc_id<=81359)) OR ((rsrc.rsrc_id>=84403) AND (rsrc.rsrc_id<=84414)) OR ((rsrc.rsrc_id>=92140) AND (rsrc.rsrc_id<=92151)) OR ((rsrc.rsrc_id>=92153) AND (rsrc.rsrc_id<=92174)) OR ((rsrc.rsrc_id>=92422) AND (rsrc.rsrc_id<=92432)) OR ((rsrc.rsrc_id>=100309) AND (rsrc.rsrc_id<=100322)) OR ((rsrc.rsrc_id>=101064) AND (rsrc.rsrc_id<=101077)) OR ((rsrc.rsrc_id>=106080) AND (rsrc.rsrc_id<=106090)) OR ((rsrc.rsrc_id>=107075) AND (rsrc.rsrc_id<=107085)) OR ((rsrc.rsrc_id>=110953) AND (rsrc.rsrc_id<=110985)) OR ((rsrc.rsrc_id>=116897) AND (rsrc.rsrc_id<=116906)) OR ((rsrc.rsrc_id>=118655) AND (rsrc.rsrc_id<=118668)) OR ((rsrc.rsrc_id>=121118) AND (rsrc.rsrc_id<=121128)) OR ((rsrc.rsrc_id>=121860) AND (rsrc.rsrc_id<=121870)) OR ((rsrc.rsrc_id>=122103) AND (rsrc.rsrc_id<=122114)) OR ((rsrc.rsrc_id>=124898) AND (rsrc.rsrc_id<=124908)) OR ((rsrc.rsrc_id>=126261) AND (rsrc.rsrc_id<=126271)) OR ((rsrc.rsrc_id>=128604) AND (rsrc.rsrc_id<=128617)) OR ((rsrc.rsrc_id>=130838) AND (rsrc.rsrc_id<=130848)) OR ((rsrc.rsrc_id>=130850) AND (rsrc.rsrc_id<=130862)) OR ((rsrc.rsrc_id>=146971) AND (rsrc.rsrc_id<=146980)) OR ((rsrc.rsrc_id>=148711) AND (rsrc.rsrc_id<=148723)) OR ((rsrc.rsrc_id>=161581) AND (rsrc.rsrc_id<=161590)) OR ((rsrc.rsrc_id>=185635) AND (rsrc.rsrc_id<=185655)) OR ((rsrc.rsrc_id>=320144) AND (rsrc.rsrc_id<=320156)) OR ((rsrc.rsrc_id>=325609) AND (rsrc.rsrc_id<=325620)) OR ((rsrc.rsrc_id>=357237) AND (rsrc.rsrc_id<=357251)) OR ((rsrc.rsrc_id>=359295) AND (rsrc.rsrc_id<=359304)) OR ((rsrc.rsrc_id>=362511) AND (rsrc.rsrc_id<=362529))..........


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.