2006684 - Errors 1204 "ASE has run out of locks" and 3914 "Illegal internal transaction status" - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2006684 - Errors 1204 "ASE has run out of locks" and 3914 "Illegal internal transaction status" - SAP ASE

Symptom

  • ASE errorlog reports error 1204
  • Some instances of error 1204 will not identify a user:

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: 1204, Severity: 17, State: 2 occurred for User ''. Client IP address is 'Unknown'.
SQL Text: [no text]

  • Following above error, ASE errorlog may begin reporting error 3914 every minute:

Error: 3914, Severity: 26, State: 1
Illegal internal transaction status. This is an internal system error.
Error: 3914, Severity: 26, State: 1
Illegal internal transaction status. This is an internal system error.

  • ASE may hang

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

checkpoint, resources, lock exhaustion, lock configuration, sp_configure, number of locks, sp_helpconfig, additional memory , KBA , cr737335 , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

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

Search for additional results

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