06/07/2021 23:23:22 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_CXC_24_2021 ERROR->Invalid query: ERROR: constraint "cxc_documento_codemp_key" of relation "cxc_documento" does not exist Whole query: CREATE TABLE cxc_procesos ( codproccxc character varying(30) NOT NULL, desproccxc character varying(256) NOT NULL, CONSTRAINT pk_cxc_procesos PRIMARY KEY (codproccxc) ) WITH ( OIDS=FALSE ); ALTER TABLE cxc_procesos OWNER TO postgres; INSERT INTO cxc_procesos (codproccxc,desproccxc) VALUES('CERCTAINC','Cerrar Cuentas Incobrables'); CREATE TABLE cxc_mov_procesos ( nromovproc integer NOT NULL, codproccxc character varying(30) NOT NULL, fecproc date, fecreg date, usureg character varying(45), horareg time without time zone, CONSTRAINT pk_cxc_mov_procesos PRIMARY KEY (nromovproc,codproccxc) ) WITH ( OIDS=FALSE ); ALTER TABLE cxc_mov_procesos OWNER TO postgres; ALTER TABLE cxc_documento ADD COLUMN doc_nromovproc integer DEFAULT 0; ALTER TABLE cxc_documento ADD COLUMN doc_codproccxc character varying(30); ALTER TABLE cxc_factura ADD COLUMN fac_nromovproc integer DEFAULT 0; ALTER TABLE cxc_factura ADD COLUMN fac_codproccxc character varying(30); ALTER TABLE cxc_ingresos ADD COLUMN ing_nromovproc integer DEFAULT 0; ALTER TABLE cxc_ingresos ADD COLUMN ing_codproccxc character varying(30); ALTER TABLE cxc_anticipos ADD COLUMN ant_nromovproc integer DEFAULT 0; ALTER TABLE cxc_anticipos ADD COLUMN ant_codproccxc character varying(30); ALTER TABLE soc_servicios ADD COLUMN perdida_fac smallint DEFAULT 0; ALTER TABLE sep_conceptos ADD COLUMN perdida_fac smallint DEFAULT 0; ALTER TABLE public.cxc_documento DROP CONSTRAINT cxc_documento_codemp_key; ALTER TABLE public.cxc_documento ADD CONSTRAINT cxc_documento_codemp_key UNIQUE(codemp, codtipdoc, codsuc, numdoc);