search cancel

Cannot Create custom Checkpoint: Query test connection failed

book

Article ID: 112529

calendar_today

Updated On:

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.

Cause

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

Environment

  • oracle probe
  • UIM 8.5.1

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