Problem: Even though there is no active jobs or load on the server, SAP Application dumps every transaction and SM21 logs the message "SQL message: rejected as server is temporarily overloaded".
Reason: HANA enables a new feature with the new updates.
It uses the admission control feature to apply processing limits and to decide how to handle new requests if the system is close to the point of saturation.
You can apply thresholds using configuration parameters to define an acceptable limit of activity in terms of the percentage of memory usage or percentage of CPU capacity.
Limits can be applied at two levels so that firstly new requests will be queued until adequate processing capacity is available or a timeout is reached, and secondly, a higher threshold can be defined to determine the maximum workload level above which new requests will be rejected. If requests have been queued, items in the queue are processed when the load on the system reduces below the threshold levels. If the queue exceeds a specified size or if items are queued for longer than a specified period of time they are rejected.
In the case of rejected requests an error message is returned to the client that the server is temporarily overloaded: 1038,'ERR_SES_SERVER_BUSY','rejected as server is temporarily overloaded'.
Reason: HANA enables a new feature with the new updates.
It uses the admission control feature to apply processing limits and to decide how to handle new requests if the system is close to the point of saturation.
You can apply thresholds using configuration parameters to define an acceptable limit of activity in terms of the percentage of memory usage or percentage of CPU capacity.
Limits can be applied at two levels so that firstly new requests will be queued until adequate processing capacity is available or a timeout is reached, and secondly, a higher threshold can be defined to determine the maximum workload level above which new requests will be rejected. If requests have been queued, items in the queue are processed when the load on the system reduces below the threshold levels. If the queue exceeds a specified size or if items are queued for longer than a specified period of time they are rejected.
In the case of rejected requests an error message is returned to the client that the server is temporarily overloaded: 1038,'ERR_SES_SERVER_BUSY','rejected as server is temporarily overloaded'.
Resolution: Under SystemDB -> configuration -> indexserver.ini ->admission_control:enable: Set to False