No more available App Servers.

[techjohnny]

When our users receive this error message "No more available app servers" the locks logger program, which is basically promon, reports all activity on table 1167, which is our LicUser table.

What could be causes our app serves to max out?

Thanks,

--tj

 

[Casper]

The Appservers are actually all busy at that moment?
What is the operating mode of the appservers?
What programs are running then?
How many users and how many appservers?
Now we are at it, what os are you using?
Is the program which act on table 1167 part of the appserver or is it been called remotely? (e.g. is it a super procedure or singleton on the appserver or run separetely?)

Regards,
Casper.

 

[cj_brandt]

If you are on 10.1C you can go look and see what code the app server is running.
If you are on a previous version, you can turn up the logging level in the app server broker / server to capture the code being executed and that might provide enough info.

 

[techjohnny]

Our server is using 10.1b with the latest hotfix. The LicUser table 1167 is the table that is displayed when the App Servers run out. The logging is set to its highest level, but has yet to reveal what is triggering this event.

--tj

 

[TomBascom]

"10.1B" and "latest" don't belong in the same sentence

As CJ says, if you at least had 10.1C then you could, potentially, view the problem code (using the client statement cache). Or you could send a SIGUSR1 if this is UNIX.