search cancel

UIM 20.3 Dynamic Group creation via SQL query fails with the Edge browser.

book

Article ID: 203381

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The group is created with no members and the upper left corner has: Error saving criteria | Group update failed.

Environment

Release : 20.3

Component : UIM - OPERATOR CONSOLE

Cause

The Edge browser is not able to correctly process the CR character in the query. 

Resolution

Remove all the CR characters from the query. 

For example change this: 

select distinct cs.cs_id from cm_computer_system cs 
inner join cm_device cd 
on cs.cs_id = cd.cs_id 
inner join cm_nimbus_robot cr 
on cd.dev_id = cr.dev_id 
where cr.hub ='P_hub'

To this: 

select distinct cs.cs_id from cm_computer_system cs inner join cm_device cd on cs.cs_id = cd.cs_id inner join cm_nimbus_robot cr on cd.dev_id = cr.dev_id where cr.hub ='P_hub'