NodeRed Node Dynamic Query results in Class Cast Exception

[UncleDinoso]

Hy, i want to execute a simple update statement on a virtual entity, located in a postgresdb:

msg.ontology = 'airquality_observed_dynamicdata_hl'; msg.queryType = 'SQL'; msg.query = 'update airquality_observed_dynamicdata_hl set co2value = 0;'; return msg;

The debug output of the Dynamic Query Node is: "Error executing query. Ontology=airquality_observed_dynamicdata_hl, QueryType =SQL, Query = update airquality_observed_dynamicdata_hl set co2value = 0;. Cause = com.minsait.onesait.platform.persistence.exceptions.DBPersistenceException: java.lang.ClassCastException."

Select statements works flawful and with the query tool, i can execute the update statement without trouble, so i think, its a node-red node problem.

Schema of entity:

[renetashi]

Hi @UncleDinoso, we are looking into it.

We'll try to replicate the behaivour and came you back to you with the result.