Hello everyone,

I'm trying to add nodes (JUNCTIONS) in my UD project from a pre-formatted shp file following the same format of the layer

v_edit_node

When I copy all the elements from my SHP file into the v_edit_node layer and I try to save the changes it returns this:

(sorry some text strings are in Italian)

Errori: ERRORE: 1122 elementi non aggiunti.

Errori della sorgente dati:

Errore PostGIS nell'aggiunta degli elementi: ERRORE: Function: [<NULL>] - IT IS NOT ALLOWED TO INSERT/UPDATE ONE NODE WITH STATE(1) OVER ANOTHER ONE WITH STATE (1) ALSO. THE NODE IS: 906. HINT: PLEASE CKECK IT - <NULL>

CONTEXT: funzione PL/pgSQL gw_fct_getmessage(json) riga 125 a RAISE

istruzione SQL "SELECT gw_fct_getmessage($${"client":{"device":4, "infoType":1, "lang":"ES"},"feature":{},

"data":{"message":"1097", "function":"1334","debug_msg":"906"}}$$);"

funzione PL/pgSQL gw_trg_topocontrol_node() riga 82 a EXECUTE

istruzione SQL "INSERT INTO node (node_id, code, top_elev, custom_top_elev, ymax, custom_ymax, elev, custom_elev, node_type,nodecat_id,epa_type,sector_id,"state", state_type, annotation,observ,"comment",

dma_id,soilcat_id, function_type, category_type,fluid_type,location_type,workcat_id, workcat_id_end, workcat_id_plan, buildercat_id, builtdate, enddate, ownercat_id,

muni_id, streetaxis_id, postcode, district_id, streetaxis2_id,postnumber, postnumber2, postcomplement, postcomplement2, descript,rotation,link,verified,

undelete,label_x,label_y,label_rotation,the_geom, expl_id, publish, inventory, uncertain, xyz_date, unconnected, num_value, lastupdate, lastupdate_user,

asset_id, drainzone_id, parent_id, arc_id, expl_id2)

VALUES (NEW.node_id,NEW.code, NEW.top_elev,NEW.custom_top_elev, NEW.ymax, NEW. custom_ymax, NEW. elev, NEW. custom_elev, NEW.node_type,NEW.nodecat_id,NEW.epa_type,NEW.sector_id,

NEW.state, NEW.state_type, NEW.annotation,NEW.observ, NEW.comment,NEW.dma_id,NEW.soilcat_id, NEW. function_type, NEW.category_type,NEW.fluid_type,NEW.location_type,

NEW.workcat_id, NEW.workcat_id_end, NEW.workcat_id_plan, NEW.buildercat_id,NEW.builtdate, NEW.enddate, NEW.ownercat_id,

NEW.muni_id, v_streetaxis, NEW.postcode, NEW.district_id,v_streetaxis2,NEW.postnumber,NEW.postnumber2, NEW.postcomplement, NEW.postcomplement2,

NEW.descript, NEW.rotation,NEW.link, NEW.verified, NEW.undelete, NEW.label_x,NEW.label_y,NEW.label_rotation,NEW.the_geom,

NEW.expl_id, NEW.publish, NEW.inventory, NEW.uncertain, NEW.xyz_date, NEW.unconnected, NEW.num_value, NEW.lastupdate, NEW.lastupdate_user,

NEW.asset_id, NEW.drainzone_id, NEW.parent_id, NEW.arc_id, NEW.expl_id2)"

funzione PL/pgSQL takoradiport_drainage.gw_trg_edit_node() riga 529 a istruzione SQL

I couldn't find a solution.

Do you have any suggestion?