Items Quarantined; relation doesn't exist

Ignition
1

Hi All,

Fairly new to Ignition.

A facility we are supporting has got an issue: trends have basically flat lined over the last few days. (I had opened up another topic regarding this.)

PostgreSQL is being used in the project. Here's the Store and Forward:

image
image389×121 11.5 KB

image
image1109×466 47.5 KB

Here are the details on the 'Local' database:

image
image1104×624 74.5 KB

The reason is given as:
'java.sql.BatchUpdateException: Batch entry 0 INSERT INTO sqlt_data_1_2025_02("tagid", "intvalue", "floatvalue", "stringvalue", "datevalue", "dataintegrity", "t_stamp") VALUES(258,NULL,196.47900390625,NULL,NULL,192,1738453254079) was aborted: ERROR: relation "sqlt_data_1_2025_02" does not exist Position: 13 Call getNextException to see other errors in the batch'

I could view relation 'sqlt_data_1_2025_02' via the Database Query Browser yesterday:

image
image942×381 90.5 KB

But today I can't view the schema on the list:
image
image807×372 42 KB

When I try to create the schema, I get an error that the schema of the same name already exists.

Has anyone come across this? Is there a remedy?

Best Regards,
Sasi Rai

2

You should open a support ticket. You have complex problems, and probably more breakage in your DB than is currently obvious.

3

Hi pturmel,

Agreed. I will be pushing it up the pecking order. Cheers.