sql_response "provider" value duplicated as "Provider" when using Admin Console

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After configuring some profiles in sql_response using Infrastructure Manager, I later made some changes to those profiles in Admin Console.

After this, I see that "provider" appears in the sql_response.cfg file but also "Provider" with a capital P. 

Which one is correct?

Environment

sql_response 1.81 and prior

Cause

This is caused by a defect in the Admin Console GUI for the sql_response probe.

"Provider" with a capital P will be ignored, the probe will use "provider" (all lowercase) for the setting.

Resolution

This will be resolved in the next release of sql_response, currently expected in January 2025 (subject to change).

For now, delete the "Provider" key with the capital P, and then use Infrastructure Manager to ensure the database provider is set correctly.