unable to test SQL Query in sql_response 1.81-HF1 using Admin Console GUI

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When I try to test any SQL Query in the Admin Console GUI for sql_response 1.81-HF1, the query fails with a message that only says "SQL Query test failed."

The same query works in Infrastructure Manager (IM).

Environment

sql_response probe 1.81-HF1 only

Cause

defect in Admin Console GUI adapter

Resolution

This does not occur in the sql_response probe version 1.81 and will not occur in the upcoming 1.82 release.  It only affects the 1.81-HF1 release (hotfix).

As a workaround, you can downgrade to 1.81 (or upgrade to 1.82+ if that has been released) or use the GUI in Infrastructure Manager, which does not have the issue.