30/09/2021 09:44:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_COV_22_2021 ERROR->Invalid query: ERROR: insert or update on table "soc_ordencompra" violates foreign key constraint "fk_soc_orde_sigesp_mo_sigesp_m" DETAIL: Key (codmon)=(VES) is not present in table "sigesp_moneda". Whole query: UPDATE cxp_solicitudes SET codmon='VES' WHERE codmon='---' OR codmon='' OR codmon IS NULL; UPDATE soc_ordencompra SET codmon='VES' WHERE codmon='---' OR codmon='' OR codmon IS NULL; UPDATE sep_solicitud SET codmon='VES' WHERE codmon='---' OR codmon='' OR codmon IS NULL; UPDATE scv_solicitudviatico SET codmon='VES' WHERE codmon='---' OR codmon='' OR codmon IS NULL; UPDATE scg_dt_cmp SET codmonscg='VES' WHERE codmonscg='---' OR codmonscg='' OR codmonscg IS NULL; ALTER TABLE scv_solicitudviatico ADD COLUMN codmonref character varying(4); ALTER TABLE scv_solicitudviatico ADD COLUMN tascamref double precision DEFAULT 1; ALTER TABLE scv_solicitudviatico ALTER COLUMN tascam SET DEFAULT (1)::double precision; ALTER TABLE scg_dt_cmp ADD COLUMN codmonscgref character varying(4); ALTER TABLE scg_dt_cmp ADD COLUMN tascamscgref double precision DEFAULT 1;