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

SAP Error Message - Details

• 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 acceptable range.
  
  
  Adjust Parameter: If the value is out of range, you can adjust it using the following SQL command:
  ALTER SYSTEM SET SOFTMAX = <new_value>;
  Replace <new_value> with a value that is within the acceptable range.
  
  
  Restart Database: After making changes to the parameter, it may be necessary to restart the database for the changes to take effect.
  
  
  Monitor System Performance: After adjusting the parameter, monitor the system performance to ensure that the changes have resolved the issue and that the system is stable.
  
  
  Consult Documentation: Refer to the SAP HANA documentation for specific details on the SOFTMAX parameter and its acceptable range.
  
  
  Contact SAP Support: If the issue persists after making adjustments, consider reaching out to SAP support for further assistance.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions related to this error.
  Database Logs: Review the database logs for any additional error messages or warnings that may provide context for the issue.
  System Resources: Ensure that the system has adequate resources (CPU, memory, etc.) to handle the workload, as resource constraints can lead to various database issues.
  
  By following these steps, you should be able to resolve the DB6565 error and ensure that the SOFTMAX parameter is correctly configured.