[Issues] Some AW_UTIL functions cause lost RPC connection errors

[Hugo Buddelmeijer]

Hi all,

It appears that some of the functions in AW_UTIL cause the ORA-28576
error: lost RPC connection to external procedure agent. This means that
scripts (or sessions) using these functions cannot last longer than 30
minutes.

E.g. running this query twice with a 35 minute delay will raise above
error: "SELECT * FROM TABLE(AWOPER.AW_UTIL.RADIUSTEST(15, 243.0, 27.0,
5.0/3600.0))". Other queries, such as simple SourceList queries, do not
raise this error.

The AssociatList class uses above function to find associations. The
consequences of this is that it is not possible to create several
AssociateLists in a script/session if the time between their creation is
more than 30 minutes.

Is there a way around this problem? Am I doing something wrong?

Attached scripts show the timeout in question. rpcTimeOutTest.py
compares several queries which are specifically crafted for this test
and would not be used in a regular session. testAL8.py tries two
associations with an (artificial) delay, such a situation can be quite
common.

Greetings,
Hugo



-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: testAL8.py
Url: http://listman.astro-wise.org/pipermail/issues/attachments/20080304/c8200165/attachment.ksh 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: rpcTimeOutTest.py
Url: http://listman.astro-wise.org/pipermail/issues/attachments/20080304/c8200165/attachment.pl