Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Ashish_Parakh
Acclaimed Contributor

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!!

 

 

 

 

 

//Add this to "OnDomLoad" event