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) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions (or specific version if related only to a specific SAP Basis)
Product
Keywords
file descriptors, ulimit, sybase, operating system limit, SQL16749, SQL16750, SQL5849 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.