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.
- 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.