HANA Configuration parameter set to unsupported value

[former_member612721]

Hello community,

Does anyone knows HANA deals with the parameters which have unsupported value set?

I recently found an alert on one of our databases "Configuration parameter system_replication_hostname_resolution set to unsupported value."

In this case, Is the database using the Default value, or trying to use the incorrectly configured value?

Thank you,

Chris

[dvankempen]

Hi Chris,

Documented in the SAP HANA Configuration Parameter Reference:

The configuration parameter unsupported_configuration_change is available to determine what action to take if an invalid value is set; the parameter can be set to Error, Warning, or None:

• Error - enforces validity by ensuring that invalid values are not set; in this case invalid values are rejected with an error.
• Warning - invalid values can be applied but a warning is generated.
• None - invalid values can be applied but if the parameter was defined with strong validation a warning is generated.

Apart from the reference, you might also find the FAQ of interest

• 2186744 - FAQ: SAP HANA Parameters
• Configuration Framework Improvements in SAP HANA 2 SPS 04 (blog)

===

You asked a question. Don't forget to mark the answer that helped you most as correct.

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks!

[sumitjais]

Hi Chris,

Based on the kind of parameters,HANA treats differently for the each parameter. Some parameters are so important that they keep on throwing errors until rectified and sometimes refuses to start too. Also, not all parameters have default values.

See more here - 2186744 - FAQ: SAP HANA Parameters in Q15. What happens if I specify a wrong parameter name or value?

In your case, system_replication_hostname_resolution holds IP address to hostname mapping ( IP = hostname) and hence there is no default value.