execute oracle procedure in dashboard designer error illegal capacity -1

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We can run oracle procedure in SQL Developer tools, we can get below output

However, when we run from dashboard designer, it throw error " illegal capacity -1"

 

 

 

Environment

UIM 23.4 CU4

Resolution

This would not work.   We can query the database for values but this query is creating a stored procedure, which alters the database.   ALTER TABLE statements would similarly not work for this reason.  The dashboard designer queries can read from the database, not write to it, this is intentional.   This query does not retrieve data, it creates a stored procedure which retrieves data.

Scripts, stored procedures, etc generally will not work in this manner from Dashboard Designer, it has to be a simple query like:

SELECT DISTINCT TARGET FROM S_QOS_DATA WHERE SOURCE = <source>;