Device Availability Report fails: Error executing SQL statement for: Device_Query

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

While Group Availability Report in CABI is executing fine, the Device Availability is failing with an error:

Jasperserver.log:

[2022-04-22T15:20:30,493 ERROR SecureExceptionHandlerImpl,https-jsse-nio-443-exec-5:116 - Error executing SQL statement for: Device_Query.]

Environment

Release: 20.4

Component: UIM - CABI

Resolution

Path: Cabi Application -> View -> Repository ->Public -> CA->UIM->Resources ->library -> availability ->input_controls ->Device Query (Right click go to
EDIT option -next -next-(paste)->save

select ccs.cs_id, ccs.name as cs_name
from CM_COMPUTER_SYSTEM ccs 
join CM_COMPUTER_SYSTEM_ORIGIN ccso ON ccs.cs_id = ccso.cs_id 
and ccso.origin in (CASE WHEN coalesce($P{Attribute_allowed_origins},'A') ='A'  THEN ccso.origin ELSE 'A' END)
or  ccso.origin in ($P{Attribute_allowed_origins})
order by cs_name

The availability by device report then loads without error, but unfortunately, the Select Device dropdown is still not being populated with devices.

This modified the SQL query resolves it.

select ccs.cs_id, ccs.name as cs_name
from CM_COMPUTER_SYSTEM ccs 
join CM_COMPUTER_SYSTEM_ORIGIN ccso ON ccs.cs_id = ccso.cs_id 
order by cs_name