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?
Hello @s.riccardi
This error shows up because you are trying to insert some nodes which are on the same place. To avoid the error and allow its insertion, you can switch to MIGRATION mode using Giswater Toolbox.
In the attached image you can see the tool to use. It will allow the insertion of duplicated nodes, but to properly work with Giswater you will need to clean your data later on.