24/01/2021 02:34:03 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SNO_02_2021 ERROR->Invalid query: ERROR: update or delete on table "sno_profesion" violates foreign key constraint "fk_sno_pers_sno_profe_sno_prof" on table "sno_personal"
DETAIL: Key (codemp, codpro)=(0001, 999) is still referenced from table "sno_personal".
Whole query:
ALTER TABLE sno_profesion ALTER COLUMN codpro TYPE character varying(6);
ALTER TABLE sno_personal ALTER COLUMN codpro TYPE character varying(6);
UPDATE sno_profesion SET codpro = trim(codpro);
UPDATE sno_personal SET codpro = trim(codpro);
UPDATE sno_profesion SET codpro=lpad(codpro,6,'0');
UPDATE sno_personal SET codpro=lpad(codpro,6,'0');
24/01/2021 02:35:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SNO_02_2021 ERROR->Invalid query: ERROR: update or delete on table "sno_profesion" violates foreign key constraint "srh_concursante_codemp_fkey" on table "srh_concursante"
DETAIL: Key (codemp, codpro)=(0001, 022) is still referenced from table "srh_concursante".
Whole query:
ALTER TABLE public.sno_personal DROP CONSTRAINT fk_sno_pers_sno_profe_sno_prof;
ALTER TABLE sno_profesion ALTER COLUMN codpro TYPE character varying(6);
ALTER TABLE sno_personal ALTER COLUMN codpro TYPE character varying(6);
UPDATE sno_profesion SET codpro = trim(codpro);
UPDATE sno_personal SET codpro = trim(codpro);
UPDATE sno_profesion SET codpro=lpad(codpro,6,'0');
UPDATE sno_personal SET codpro=lpad(codpro,6,'0');
ALTER TABLE public.sno_personal
ADD CONSTRAINT fk_sno_pers_sno_profe_sno_prof FOREIGN KEY (codemp, codpro)
REFERENCES public.sno_profesion (codemp, codpro) MATCH SIMPLE
ON UPDATE RESTRICT
ON DELETE RESTRICT;
24/01/2021 21:23:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SCV_24A_2020 ERROR->Invalid query: ERROR: syntax error at or near "$"
LINE 5: $
^
Whole query:
CREATE OR REPLACE FUNCTION eval(expression text)
RETURNS integer AS
$
DECLARE
result integer;
BEGIN
EXECUTE expression;
RETURN 1;
END;
$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION eval(text)
OWNER TO postgres;
24/01/2021 21:25:31 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SCV_24A_2020 ERROR->Invalid query: ERROR: syntax error at or near "$"
LINE 10: AS $
^
Whole query:
CREATE OR REPLACE FUNCTION public.eval(
expression text)
RETURNS integer
LANGUAGE 'plpgsql'
COST 100
VOLATILE
AS $
DECLARE
result integer;
BEGIN
EXECUTE expression;
RETURN 1;
END;
$;
ALTER FUNCTION public.eval(text)
OWNER TO postgres;
24/01/2021 21:27:47 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SCV_24A_2020 ERROR->Invalid query: ERROR: syntax error at or near "$"
LINE 10: AS $
^
Whole query:
CREATE OR REPLACE FUNCTION public.eval(
expression text)
RETURNS integer
LANGUAGE 'plpgsql'
COST 100
VOLATILE
AS $
DECLARE
result integer;
BEGIN
EXECUTE expression;
RETURN 1;
END; $$
LANGUAGE 'plpgsql' VOLATILE STRICT SECURITY DEFINER;
ALTER FUNCTION public.eval(text)
OWNER TO postgres;
24/01/2021 21:29:16 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SCV_24A_2020 ERROR->Invalid query: ERROR: conflicting or redundant options
LINE 17: LANGUAGE 'plpgsql' VOLATILE STRICT SECURITY DEFINE...
^
Whole query:
CREATE OR REPLACE FUNCTION public.eval(
expression text)
RETURNS integer
LANGUAGE 'plpgsql'
COST 100
VOLATILE
AS $$
DECLARE
result integer;
BEGIN
EXECUTE expression;
RETURN 1;
END; $$
LANGUAGE 'plpgsql' VOLATILE STRICT SECURITY DEFINER;
ALTER FUNCTION public.eval(text)
OWNER TO postgres;
24/01/2021 21:31:50 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_SSS_51_2020 ERROR->Invalid query: ERROR: constraint "pk_sss_registro_eventos" of relation "sss_registro_eventos" does not exist
Whole query:
ALTER TABLE sss_registro_eventos DROP CONSTRAINT pk_sss_registro_eventos;
ALTER TABLE sss_registro_eventos DROP CONSTRAINT unk_sss_registro_eventos;
ALTER TABLE sss_registro_eventos ADD COLUMN id_evento serial;
ALTER TABLE sss_registro_eventos
ADD CONSTRAINT pk_sss_registro_eventos PRIMARY KEY(id_evento);
CREATE INDEX sss_registro_eventos_numeve_idx
ON sss_registro_eventos
USING btree
(numeve);
CREATE INDEX sss_registro_eventos_codusu_codsis_nomven_fecevetra_idx
ON sss_registro_eventos
USING btree
(codusu COLLATE pg_catalog."default", codsis COLLATE pg_catalog."default", nomven COLLATE pg_catalog."default", fecevetra);
24/01/2021 21:39:30 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_fop_c_formulacion
METODO: ConsultaPryInvalid query: ERROR: column e.codobj does not exist
LINE 34: AND e.codobj = ep1.codobj
^
HINT: Perhaps you meant to reference the column "o.codobj".
Whole query: SELECT ep1.*,pg.desplangob,es.desestproy,sp.desitprepry,a.desamb,
d.desdirect,o.desobj,e.denestratj,p.denpol,
um.desunimed,bp.nombenpry,s.densec,ss.densubsec,
oreq.desorg AS reqcontdesorg,
oges.desorg AS contgesdesorg,
ocon.desorg AS conflicdesorg,
pger.nomper||' '||pger.apeper AS nomger,
pger.sexper AS sexperger,
pger.coreleper AS coreleperger,
preg.nomper||' '||preg.apeper AS nomreg,
preg.sexper AS sexperreg,
preg.coreleper AS coreleperreg,
paut.nomper||' '||paut.apeper AS nomaut,
paut.sexper AS sexperaut,
paut.coreleper AS coreleperaut
FROM fop_ep1 ep1 LEFT JOIN fop_plangob pg ON pg.codemp = ep1.codemp
AND pg.codplangob = ep1.codplangob
LEFT JOIN fop_estproy es ON es.codemp = ep1.codemp
AND es.codestpry = ep1.codestpry
LEFT JOIN fop_sitprepry sp ON sp.codemp = ep1.codemp
AND sp.codsitprepry = ep1.codsitprepry
LEFT JOIN fop_ambito a ON a.codemp = ep1.codemp
AND a.codamb = ep1.codamb
LEFT JOIN fop_ae_directriz d ON d.codemp = ep1.codemp
AND d.coddirect = ep1.coddirect
AND d.codplangob = ep1.codplangob
LEFT JOIN fop_ae_obj o ON o.codemp = ep1.codemp
AND o.coddirect = ep1.coddirect
AND o.codobj = ep1.codobj
AND o.codplangob = ep1.codplangob
LEFT JOIN fop_ae_estrategia e ON e.codemp = ep1.codemp
AND e.coddirect = ep1.coddirect
AND e.codobj = ep1.codobj
AND e.codestrat = ep1.codestrat
AND e.codplangob = ep1.codplangob
LEFT JOIN fop_ae_politica p ON p.codemp = ep1.codemp
AND p.coddirect = ep1.coddirect
AND p.codobj = ep1.codobj
AND p.codestrat = ep1.codestrat
AND p.codpol = ep1.codpol
AND p.codplangob = ep1.codplangob
LEFT JOIN fop_unimed um ON um.codemp = ep1.codemp
AND um.codunimed = ep1.codunimed
LEFT JOIN fop_benefpry bp ON bp.codemp = ep1.codemp
AND bp.codbenpry = ep1.codbenpry
LEFT JOIN fop_sector s ON s.codemp = ep1.codemp
AND s.codsec = ep1.codsec
LEFT JOIN fop_subsector ss ON ss.codemp = ep1.codemp
AND ss.codsec = ep1.codsec
AND ss.codsubsec = ep1.codsubsec
LEFT JOIN fop_org oreq ON oreq.codorg = ep1.cicodorgreqcont
LEFT JOIN fop_org oges ON oges.codorg = ep1.cicodorgcontges
LEFT JOIN fop_org ocon ON ocon.codorg = ep1.cicodorgconflic
LEFT JOIN sno_personal pger ON pger.codemp = ep1.codemp
AND pger.codper = ep1.codperger
LEFT JOIN sno_personal preg ON preg.codemp = ep1.codemp
AND preg.codper = ep1.codperreg
LEFT JOIN sno_personal paut ON paut.codemp = ep1.codemp
AND paut.codper = ep1.codperaut
WHERE ep1.codemp = '0001'
AND ep1.anopresup ='2013'
AND ep1.codplangob ='1'
AND ep1.codestpro1 ='0000000000000000000PRY001'
AND ep1.estcla = 'P'