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 , Business Suite on Adaptive Server Enterprise , 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.