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 

Comments