E-PC: PT 8.56 Performance Issues After Transfer peoplecode is triggered.
Last updated on JULY 13, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.
PUM 11 but multiple patches have been applied
Using classic page
User is clicking a link on a custom grid and when the new window is opened it and it takes 200 seconds
The parent grid has 337,000 rows in it and it ti chunked at 1000. The secondary page only has 1 row.
PageTransfer call very slow after PT8.56.05 upgrade
Custom page calling delivered pagetransfer peoplecode. After 8.56 upgrade, the transfer takes a very long time to complete. Appears to be isolated to specific page, but I'm not entirely sure about that.
Developers have traced PC for a "good" and "bad" environment, and noted the only difference as this in "bad":
PSAPPSRV.1141 (153) 1-7364 04.17.08 213.656839 Cur#0.1141.PSFDV2 RC=0 Dur=0.000344 Destroy Connection Handle=000000000237D8D0
A trace from a "good" environment does not has a "destory connection handle" call - it just moves on to creating the next connection.
Performance should be the same after upgrade
The issue can be reproduced at will with the following steps:
1.User logs in and navigates to custom page with grid
2. Selects a row on the grid where another window will open
3. System hangs for 3.5 minutes before rendering page
The issue has the following business impact:
Due to this issue, users experience performance when clicking on link in grid on custom page.
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