There are not enough 'user connections' available to start a new process - SAP on Sybase ASE Error
Issue :-
There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections
Checking number of user connections :-
isql -Usa -Ppassword -SSID -X (Sybase SQL login)
> use master
> go
> sp_configure "number of user connections"
> go
Changing number of User Connections
> use master
> go
> sp_configure "number of user connections", 500
> go
Note :- System restart not required for this.
Source Link :- https://basisgenie.blogspot.com/2021/04/there-are-not-enough-user-connections.html
Comments
Post a Comment