SAP Knowledge Base Article - Preview

2607694 - Error 15600 following error 1204 'out of locks' - SAP ASE

Symptom

ASE errorlog reports error 15600 preceded by error 1204:

Error: 1204, Severity: 17, State: 2
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: 15600, Severity: 20, State: 2
Lookup of systabstats for database 'tempdb' (2), object '#tmp_tab123456' (167713316), index '#tmp_tab123456' (0), ..... failed.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.