Cannot Create custom Checkpoint: Query test connection failed

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

When creating a custom checkpoint / query with the oracle probe its giving a connection error / failed even though the connection works properly when executed from the connection tab.

Environment

• oracle probe
• UIM 8.5.1

Cause

- the use of ; at the end of the query is causing the issue.
- without ; the query is working fine

Resolution

Looks like the use of ; after the query was causing the issue. Without ; query is working fine

Example:

When Clicking "TEST" for:

select file_name,file_id from dba_data_files;
--> Query test connection failed

When Clicking "TEST" for:

select file_name,file_id from dba_data_files
--> Query connection succeeded