1933435 - Error 1601: There are not enough 'user connections' - SAP ASE for BS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1933435 - Error 1601: There are not enough 'user connections' - SAP ASE for BS

Symptom

  • The 'number of user connections' ASE configuration parameter seems to be set high enough.
  • However, sometimes the available user connections are exhausted.
  • The following message is reported in the ASE errorlog:
     
         Error 1601: There are not enough 'user connections' available to start a new process.
     
  • The number of user connection goes up, as soon as the transaction log is almost 100% in use.
  • Even when the transaction log is dumped and the log free is again 99% or more, the number of user connections will stay at a high level causing problems like Error 1601.
     
    For example:

processes: 61, log free: 99.28%.
processes: 61, log free: 99.27%.
processes: 57, log free: 99.41%.
processes: 55, log free: 18.21%.
processes: 55, log free: 14.22%.
processes: 55, log free: 9.60%.
processes: 55, log free: 4.75%.
processes: 54, log free: 0.85%.
processes: 283, log free: 0.84%.
processes: 306, log free: 99.60%.
processes: 306, log free: 99.60%.
processes: 306, log free: 99.59%.


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)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.3

Keywords

dump, transaction, syslogs, full, DBSL, dbsl_lib, DBSL, kernel , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

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