Skip to main content

There are not enough 'user connections' available to start a new process - SAP on Sybase ASE Error

 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
Labels:

Comments

Post a Comment

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...
Post a Comment
Read more