How To Fix DB6565 - The SOFTMAX parameter is out of range

DB6565 - Overview

• Message type: E = Error

• Message class: DB6 - DB6: Alert Monitoring and Alert Configuration

• Message number: 565

• Message text: The SOFTMAX parameter is out of range

1st and 2nd block copied from DB6 553

What causes this issue?

Using the database configuration parameter SOFTMAX, you can set how the
maximum number of log files that will be required for restoration after
a crash (Crash Recovery).

System Response

The parameter SOFTMAX determines the maximum number of log files with
changes that were not yet written from the buffer pool to the database.
If this number is reached, the system writes the changed pages from the
buffer pool. This parameter therefore has consequences for system
performance; you should choose a value that means that, on the one
hand, Crash Recovery in the case of errors does not take too long, and
on the other, pages are not written from the buffer pool too often.

How to fix this error?

Adjust the parameter using the command:
<LB>UPDATE DB CFG USING SOFTMAX <value></>

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6565 - The SOFTMAX parameter is out of range ?

  The SAP error message DB6565, which states that "The SOFTMAX parameter is out of range," typically relates to issues with the database configuration, particularly in the context of the SAP HANA database. The SOFTMAX parameter is used to control the maximum number of soft locks that can be held by a transaction.
  
  Cause:
  
  Parameter Value: The SOFTMAX parameter has been set to a value that exceeds the allowed range. This can happen if the parameter is manually configured or if there are changes in the database settings.
  Database Configuration: The database might be misconfigured, leading to the parameter being set incorrectly.
  Resource Constraints: The system may be under heavy load, causing the parameter to exceed its limits.
  
  
  Solution:
  
  
  Check Parameter Value: Verify the current value of the SOFTMAX parameter. You can do this by executing the following SQL command in the HANA database:
  SELECT * FROM M_INIFILE WHERE KEY = 'SOFTMAX';
  Ensure that the value is within the