Cannot Create custom Checkpoint: Query test connection failed

Document ID : KB000112529
Last Modified Date : 14/09/2018
Show Technical Document Details
Issue:
When creating a custom checkpoint /query with the oracle probe its giving 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 ; 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