SAP Hana – parameter mismatch alert

If You use in Your environment HANA system replication then there is a high probability that You’ll see in the Alerts information like:

Solution

The reason for the error is simple. The parameter was created or changed on only one side of the site (primary/secondary).

You have several possibilities to repair this.

  1. Manually enter parametr to the config on the right site:
    • log to OS on sidadm
    • go to path – /usr/sap/<SID>/SYS/global/hdb/custom/config
    • modify correct file, e.g. global.ini, indexserver.ini, etc. – it depends on your alert error
    • pay attention to the relevant sections where the parameter must be placed – if necessary, check on the other server
    • save file and execute command: hdbnsutil –reconfig to enable the parameters.

2. There’s a simpler method 😉 Is possible to automatically replicate parameters from the primary to the secondary site by activating the following parameter on primary site:

global.ini -> [inifile_checker] -> replicate = 'true'

You can set the parameter by executing SQL:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('inifile_checker', 'replicate') = 'true' with reconfigure;

More information about monitoring and replication INI file You can find here. Among other things, You’ll find information about preventing parameters from generating alerts and how to create exclusions.

Copyright © 2023. SAPBasisWorld.com Privacy Policy