NCLOB in Alarm Journal - not in DB tables (Oracle)

Ignition
1

Hi folks,

Ignition 8.1.24
Oracle XE 18.0

We're seeing event data showing up as "oracle.sql.NCLOB", while the actual data in the tables is correct:

image
image1671×316 32.2 KB

And the columns appear correct:
It appears as though the auto-generated column type is a NCLOB, rather than VARCHAR. Is this something that needs to be changed?
image

Referred to both other threads on this (thread 1 and thread 2), but was unable to find a solution.

Short of running my own query to get the data and putting it in a table, does anyone have ideas as to how to fix this, or what the root cause may be?

Thank you in advance.

2

Ran this series of commands to change it from CLOB to VARCHAR. Picked a length of 500 to leave room for longer descriptions (my longest was 293).

--create new column
alter table ALARM_EVENT_DATA add ("strvalue2" varchar2(500));
--copy clob to varchar
update ALARM_EVENT_DATA set "strvalues" = dbms_lob.substr("strvalue",500,1);
--rename clob, then rename new column
alter table ALARM_EVENT_DATA rename column "strvalue" to "strvalueClob";
alter table ALARM_EVENT_DATA rename column "strvalue2" to "strvalue";

I was hesitant to drop the CLOB just yet, but it will happen once I'm content this is working.

Since this is a system created table, perhaps the folks at IA can make these changes for future releases?

Cheers!

Edit:
Used this command to get the max clob length for determining my new VARCHAR size.

SELECT max(dbms_lob.getlength("strvalue")) FROM ALARM_EVENT_DATA

1 Like