Kbase P64890: ASP page which uses Open Client proxies is holding connections to the AppServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2009 |
|
Status: Verified
SYMPTOM(s):
ASP page which uses Open Client proxies is holding connections to the AppServer
Connections are held for about a minute after the ASP program terminates
Eventually all AppServer server processes are locked by ASP
Users receive "http 500 internal server error" when all AppServer server processes are locked
FACT(s) (Environment):
Progress 9.x
Windows
CAUSE:
The ASP program is invoking a method on a persistent procedure using the following coding construct:
MyAppObject.CreatePO_MyPersistentProcedure.SomeMethod
This type of coding construct will cause the AppServer connection to not be released as the code does not store the object handle returned by the CreatePO_MyPersistentProcedure call. When a persistent procedure is created using any CreatePO_Something call you must store off the object handle that is returned by the call so that you can invoke the object handles OC_Release method when you are finished with it.
FIX:
Modify the ASP application code as follows:
Dim MyPersistentProcedure
Set MyPersistentProcedure = MyAppObject.CreatePO_MyPersistentProcedure
MyPersistentProcedure.SomeMethod
MyPersistentProcedure.OC_Release
Set MyPersistentProcedure = Nothing