|
Hi there, I thought I fixed a few issues I was having with
Invalid Authorization errors by increasing the number have sessions that can be
open at the same time but I am still getting the errors… Let me try and explain whats happening and maybe
somebody can offer some advice? It is a telecommunications application that has 45 channels(channels meaning scripts that connect to the
database and run various querys)… most of the scripts/channels connect to
the database but some fail… If I restart the scripts (that failed) to reconnect
to the database then all is fine so I was wondering that if it runs out of
connections or something… So I did increased the
number of active users. When I start the application there are around 45
scripts all trying to connect to the database…. They all connect i.e.
OPEN the database without problem but about 4 scripts fail when doing a SELECT
if I just restart these its fine…. It seems to be that they are all doing
things at once.. but as I say
I have increased the active users to 75… Any help would be really appreciated,
this is about the only issues I have left now after upgrading my db from MS SQL
Server to SAP DB. Thanks in advance
|
