Symptom
- Your application reports a message with error 1204:
[ASE Error SQL1204]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.
- In situations where the SAP system hangs and is stalled due to SQL1204 error, please see KBA 2203739
- For SAP BW
- You are currently experiencing serious locks situations in the SAP BW system that let the system as unusable.
- Database becomes unresponsive even to commands on ISQL command line.
- You already checked and implemented those KBAs
-KBA 1899144 - ASE Error SQL1204 during transfer of data between Infocubes
-SAP Note 1605169 - SYB: SAP BW 7.02 Correction Collection
-SAP Note 1608417 - SYB: SAP BW 7.30 Correction Collection
-SAP Note 1616726 - SYB: SAP BW 7.31 Correction Collection
-SAP Note 1821924 - SYB: SAP BW 7.40 Correction Collection
-SAP Note 2193724 - SYB: SAP BW 7.50 / 7.51 / 7.52 Correction Collection
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Enterprise Resource Planning (ERP) 6.0
- SAP Business Warehouse (SAP BW)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions
Keywords
Sybase, locks configuration, 1204, number of locks, dynamic value, sp_monitorconfig , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.