Skip to main content

ASE has run out of LOCKS - Export/Import or SPAM/SAINT Error

 ASE has run out of LOCKS - Export/Import or SPAM/SAINT Error


Issue :-

ASE has run out of LOCKS. Re-run your command when there are fewer active users, 
or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.
Error: 1204, Severity: 17, State: 2 occurred for User ''. Client IP address is 'Unknown'.
server SQL Text: [no text]

Login into isql using system user

First Check

1> use master
2> go
1> sp_helpconfig 'number of locks'
2> go

Secondly Change

1> use master
2> go
1> sp_helpconfig 'number of locks', <New Value>
2> go

Note :- Restart not required for this activity, So once we changed the value we can repeat the activity.
Once the activity completed we can change the lock value to older one or maintain normal value.


Source Link : https://basisgenie.blogspot.com/2019/07/ase-has-run-out-of-locks-import.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