# Label Column showing NCLOB data in Alarm Journal Table

**URL:** <https://forum.inductiveautomation.com/t/label-column-showing-nclob-data-in-alarm-journal-table/48056>\
**Category:** Ignition\
**Tags:** vision, database, ignition80\
**Created:** [June 22, 2021, 1:15pm UTC](https://forum.inductiveautomation.com/t/label-column-showing-nclob-data-in-alarm-journal-table/48056 "2021-06-22T13:15:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![c.bertulli](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\
**Post date:** [June 22, 2021, 1:15pm UTC](https://forum.inductiveautomation.com/t/label-column-showing-nclob-data-in-alarm-journal-table/48056/1 "2021-06-22T13:15:33Z")

</div>

Hi All,

I have the alarms set as the following:  
Inside the DisplayPath there is the alarm string such as “Alm036-Motor Fault” ( the string is generated by an expression ) and inside the Label, there is the Factory such as “Department206” ( this string is static )  
I use the DisplayPath for the alarm string because it can be filtered inside the Alarm Journal Table ( Search String property ) so there is no option to swap DisplayPath and Label.  
The issue I have is that the Alarm Journal Table displays **oracle.sql.NCLOB@2d9ee3cb** inside the Label column instead of “Department206”.

 ![Immagine](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/3/43246192eb0ff87d60057231db2849334c7491f0.png)

The two tables reserved for the alarms ( Alarms\_events and Alarms\_event\_data ) have been created from Ignition automatically.  
I think this happens only with Oracle since I have multiple Ignition installations ( in other countries ) with the same configuration but with SQL Server and there is no issue.  
I checked the column’s datatype of the “strvalue” column in Alarms\_event\_data ( this is where the Label is stored ) and is NCLOB (overkill?) maybe the Alarm Journal Table is not interpreting this datatype correctly? ( I saw on google is not a friendly datatype ).  
In **Gateway - Config - Allarming - Journal** , my Journal is configurated as the following:  
**Stored Event Data**  
Static Config - True  
Dynamic Config - True  
Static Associated Data - True  
Dynamic Associated Data - True

Any help will be greatly appreciated 🙂

Igntion 8.0.16

---

<div class="post-metadata">

**Author:** ![Philip\_Harhay](https://avatars.discourse-cdn.com/v4/letter/p/71e660/32.png) [@Philip\_Harhay](https://forum.inductiveautomation.com/u/Philip_Harhay)\
**Post date:** [September 13, 2022, 5:38pm UTC](https://forum.inductiveautomation.com/t/label-column-showing-nclob-data-in-alarm-journal-table/48056/2 "2022-09-13T17:38:39Z")

</div>

I have this issue as well, what is the solution to it?

---

<div class="post-metadata">

**Author:** ![Philip\_Harhay](https://avatars.discourse-cdn.com/v4/letter/p/71e660/32.png) [@Philip\_Harhay](https://forum.inductiveautomation.com/u/Philip_Harhay)\
**Post date:** [September 15, 2022, 3:40pm UTC](https://forum.inductiveautomation.com/t/label-column-showing-nclob-data-in-alarm-journal-table/48056/3 "2022-09-15T15:40:23Z")

</div>

The solution is to use the Display Path property instead of the Label Property.