2049556 - 16749, 16750 and 5849 may occur during increasing "number of user connections" - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2049556 - 16749, 16750 and 5849 may occur during increasing "number of user connections" - SAP ASE

Symptom

Errors 16749, 16750 and 5849 may occur during increasing "number of user connections"

Msg 16749, Level 16, State 1
Server 'TESTSERVER', Procedure 'sp_configure', Line 1357
The number of file descriptors per ASE process required to support the
configuration resulting from the value 444 of the configuration parameter
'number of user connections' exceeds the limit 1024 by 1.

Msg 16750, Level 16, State 1
Server 'TESTSERVER', Procedure 'sp_configure', Line 1357
The maximum number of file descriptors per ASE process is calculated by
the SMP edition in threaded mode using:
(number of user connections + number of remote sites + max cis remote
connections + number of java sockets + max number network listeners + max
native threads per engine + overhead (16)).

Msg 5849, Level 16, State 1
Server 'TESTSERVER', Procedure 'sp_configure', Line 1357
Verification failed for parameter 'number of user connections'.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) All version for Business Suite (BS) / Business Warehouse (BW)
  • SAP Netweaver (NW)
  • SAP Adaptive Server Enterprise (ASE) All version

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

file descriptors, ulimit, sybase, operating system limit, SQL16749, SQL16750, SQL5849 , 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.