R12 Search Project Performance Is Slow (Doc ID 1484739.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After searching for the project in the Search Projects html screen the performance to open the Workplan tab encounters slow performance. The most expensive query while doing this is:

SELECT PATH_DOCID
FROM
 jdr_paths paths, jdr_attributes WHERE rownum=1 AND path_name=:1 AND
  path_docid=att_comp_docid AND att_comp_seq=0 AND att_name='customizes' AND
  att_value=:2 AND EXISTS (SELECT 'x' FROM jdr_paths p, jdr_paths owner WHERE
  owner.path_name = 'customizations' and owner.path_docid =
  p.path_owner_docid and p.path_name not in ('user', 'portlet') START WITH
  p.path_docid = paths.path_docid CONNECT BY PRIOR p.path_owner_docid =
  p.path_docid)


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 109 0.01 0.01 0 0 0 0
Fetch 109 70.10 68.83 0 21408225 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 218 70.11 68.84 0 21408225 0 2

Then the screen shows error:

500 Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, Afernand@epcor.ca and inform them of the time the error occurred, and anything you might have that that may have caused the error.
More information about this error may be available in the server error log.

Afterwards clicking on the workplan tab and the information comes up almost immediately.

Cause

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 hundreds of Community platforms