Whilst trying to track down a completely unrelated issue, I've noticed an oddity in our protrace files and would appreciate any help to work out what it's telling me.
We're running 11.2 clients against 11.5 db. AppServers are on the same box as the db, so also 11.5.
We are getting errors that are producing protrace files from the AppServer, and I notice that there is a lot of repetition in the persistent procedures section. I'm guessing this indicates something is not tidying up after itself. The log is below. Is this the persistent procedures for the session? So every process that has run on that AppServer process since inception? Or is it caused by the particular .p that is running at that time? It's going to be a tricky one to track down if it's the former!
** Persistent procedures/Classes ** Handle File Name 6650406 \\hob\clients\ICMAS\RCODE\v11\live\exportmgr.r 6650380 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\stdplip.r 6650268 \\hob\clients\ICMAS\RCODE\v11\live\RedemptionProcess.r 6650267 \\hob\clients\ICMAS\RCODE\v11\live\Redemption.r 6650204 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6646166 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\tapi.r 6642766 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6642449 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6642414 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6642292 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6642089 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6641707 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6640271 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6578083 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6568284 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 6568197 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6567131 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6567023 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6566047 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6565687 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6564091 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6564060 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6559546 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6555608 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6555577 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6554570 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6554489 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 6554048 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5824589 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5824518 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5824151 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5822621 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5822121 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5818123 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5817925 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5817558 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5816342 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5813839 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5813594 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5813076 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5813023 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5812794 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5811679 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5810558 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5810088 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5809407 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 5809215 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5807729 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5802214 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5799851 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5799226 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5795885 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5795760 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5594400 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5593959 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5593928 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5593889 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5574175 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 5574167 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5573528 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 5573402 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5571630 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5567429 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5567110 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5566859 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5564519 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5564448 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5564359 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5564121 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 5564076 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4850796 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4848900 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 4848323 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4847539 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 4847415 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 4846849 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4846647 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4846526 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 4843222 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4843164 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 4843098 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4843067 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4842733 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4842598 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4842509 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4842474 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4842260 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4841485 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4840905 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4840189 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4840081 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 4839452 \\hob\clients\ICMAS\RCODE\v11\live\excelmgr.r 4838146 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 3726964 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599677 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599627 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599569 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599538 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599050 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2599005 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2598406 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2594457 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2594400 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2014567 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2013921 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2013759 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2013595 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2012319 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2010897 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2005116 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2004896 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2003912 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2003459 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2003332 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2003154 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 2000372 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1999623 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1992386 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 1992290 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1992259 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1990370 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1990060 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1989235 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1988667 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1985414 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1985160 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1984822 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 1984820 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1984549 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1984376 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1983956 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1983475 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1983120 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1983089 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1969851 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1969457 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1969358 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1969162 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1968390 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1968259 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1968068 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1966132 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1963663 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1963553 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1963512 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1963151 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1962564 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1961943 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1961728 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1961107 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1960690 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1960615 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1959394 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1396680 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1396481 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 1396298 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 715283 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 151095 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 151075 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 150607 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 150241 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149692 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149661 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149620 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149403 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149360 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149179 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149144 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 149113 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 148811 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 148501 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 148445 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 148325 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 147911 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 147880 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 147849 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 147593 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 147380 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 146993 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 144744 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 144487 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 143380 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 141264 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 139782 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 136875 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 135603 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 135422 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 135299 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 135250 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 128971 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 127113 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 125980 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 125799 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\Stdplip.r 125482 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 125146 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 124839 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 124789 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 124750 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 124141 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 123825 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 123680 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 123350 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 123283 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 069224 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 041334 \\hob\clients\ICMAS\RCODE\v11\live\icrmgrpm.r 041157 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 040796 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 040428 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 040010 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 039411 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 039064 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 038981 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 038525 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 038125 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 037478 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 032651 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 032071 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 029160 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 028049 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 028014 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 027777 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 026743 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 026536 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 026471 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 007962 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 004717 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 004531 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 004476 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 003889 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 003716 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 002682 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 001893 \\hob\clients\ICMAS\ICMAS\v11\Live\PATCHES\fesmgrpm.r 000000 \\hob\clients\ICMAS\RCODE\v11\live\STDLibrary.r (STATIC)
These are all persistent at the time of crash.
RUN lala.p PERSISTENT.
RUN lala.p PERSISTENT.
And voila you have two leaked persistent procedures.
DEFINE VARIABLE hp AS HANDLE NO-UNDO.
RUN lala.p PERSISTENT SET hp.
RUN lala.p PEERSISTENT SET hp.
DELETE OBJECT hp.
And voila you have one leaked persistent procedure.
Thanks Stefan, so these are from all the code that might have been run on that AppServer process in its lifetime before the crash? Needle in a haystack job to find! :(
Assuming you can increase the logging without running out of disk space, this article knowledgebase.progress.com/.../P133306 should help point out where instances get created that don't get deleted.
Don't know how long it takes for the agent to crash, but I expect you can find enough evidence of the leak before the crash happens.
Thanks Frank. Unfortunately a bit strapped for disk space. The agent is crashing because of another issue which is how we found the problem. It's very intermittent.
So I'm looking at implementing an AppServer Disconnect procedure that will walk the session procedure tree and delete any procedures. Just to check before I do anything stupid - this won't affect any other AppServer processes will it? So each time I connect to the AppServer I get a new session?
It will only impact the appserver agent that runs the disconnect procedure.
What operating mode is your appserver set to? Stateless or state-aware?
Stateless
You will be fine with that KB from the other thread. Obviously test it first before deploying in production :)
I am assuming that any persistent procedures needed are either loaded by a connect procedure or by the code that you run on the appserver.
If you have any appserver startup procedures that load persistent (super) procedures you probably want to exclude them from the disconnect procedure. Or move them into the connect procedure.
Thanks for the help. It all works fine in development and we'll be deploying to Production this evening.