Project and Portfolio Management Practitioners Forum
cancel

Performance issue on Project summary & edit workplan page on PPM7.1

Highlighted
Ashish_Parakh
New Member.

Performance issue on Project summary & edit workplan page on PPM7.1

Hi,

 

 

We are using HP PPM 7.1 & facing performance issue on instance specially while loading of 'Project Summary' & 'View/Edit Workplan' page.

 

The seeded query which runs in backend during this which is taking Max. time is shown below:

 

SELECT * FROM ( SELECT PENDINGTAS1_.CREATION_DATE AS COL_0_0_ FROM PPMC46PR01.WP_TASKS TASK0_,
PPMC46PR01.ITG_PENDING_ROLLUPS PENDINGTAS1_ WHERE PENDINGTAS1_.ROLLUP_TYPE_CODE='TEST'
AND TASK0_.WORK_PLAN_ID=10
AND PENDINGTAS1_.SOURCE_ENTITY_PRIMARY_KEY=TASK0_.TASK_ID
ORDER BY PENDINGTAS1_.CREATION_DATE ASC ) WHERE ROWNUM <= 5;

 

In above query '10' & 'TEST' are just example values. Actually bind variables are getting passed here.

 

Also, we find many such queries in backend running & many are waiting in queue to get processed, o.e. in waiting status. Hence this is causing performance issue specially in loading that project summary page.

 

Any help will be appreaciated, thanks!!