24/06/2021 19:43:16 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_sno_c_nomina MÉTODO->BuscarUltimoPeridodoCalculo ERROR->Invalid query: ERROR: column hp.numpernom does not exist LINE 3: SELECT c.anocur ,c.codperi,MAX(hp.numpernom) AS numpe... ^ HINT: Perhaps you meant to reference the column "n.numpernom". Whole query: SELECT c.anocur ,c.codperi,MAX(hp.numpernom) AS numpernom,MAX(hp.tippernom) AS tippernom FROM sno_hsalida s INNER JOIN sno_hconcepto c ON s.codemp = c.codemp AND s.codnom = c.codnom AND s.anocur = c.anocur AND s.codperi = c.codperi AND s.codconc = c.codconc INNER JOIN sno_hperiodo hp ON hp.codemp = s.codemp AND hp.codnom = s.codnom AND hp.anocur = s.anocur AND hp.codperi = s.codperi INNER JOIN sno_hnomina n ON n.codemp = c.codemp AND n.codnom = c.codnom AND n.anocurnom = c.anocur AND n.peractnom = c.codperi WHERE s.codemp='0001' AND espnom='0' AND sigcon='A' AND s.codper='0010536297' AND s.codnom='0002' GROUP BY 1,2 ORDER BY 1,2 DESC LIMIT 1 24/06/2021 20:34:18 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Vacación MÉTODO->uf_load_periodo ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...o WHERE codemp='0001' AND codnom='1002' AND ''>=fecdes... ^ Whole query: SELECT codperi,fecdesper,fechasper FROM sno_hperiodo WHERE codemp='0001' AND codnom='1002' AND ''>=fecdesper AND ''<=fechasper 24/06/2021 20:34:18 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Permiso MÉTODO->DiasPermisoVac ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...RE codemp='0001' AND codper='' AND feciniper>='' AND f... ^ Whole query: SELECT sum(numdiaper) as total FROM sno_permiso WHERE codemp='0001' AND codper='' AND feciniper>='' AND feciniper<='' AND afevacper=1 24/06/2021 20:34:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Vacación MÉTODO->uf_load_periodo ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...o WHERE codemp='0001' AND codnom='1002' AND ''>=fecdes... ^ Whole query: SELECT codperi,fecdesper,fechasper FROM sno_hperiodo WHERE codemp='0001' AND codnom='1002' AND ''>=fecdesper AND ''<=fechasper 24/06/2021 20:34:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Permiso MÉTODO->DiasPermisoVac ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...RE codemp='0001' AND codper='' AND feciniper>='' AND f... ^ Whole query: SELECT sum(numdiaper) as total FROM sno_permiso WHERE codemp='0001' AND codper='' AND feciniper>='' AND feciniper<='' AND afevacper=1 24/06/2021 20:35:25 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Vacación MÉTODO->uf_load_periodo ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...o WHERE codemp='0001' AND codnom='1002' AND ''>=fecdes... ^ Whole query: SELECT codperi,fecdesper,fechasper FROM sno_hperiodo WHERE codemp='0001' AND codnom='1002' AND ''>=fecdesper AND ''<=fechasper 24/06/2021 20:35:25 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Permiso MÉTODO->DiasPermisoVac ERROR->Invalid query: ERROR: invalid input syntax for type date: "" LINE 1: ...RE codemp='0001' AND codper='' AND feciniper>='' AND f... ^ Whole query: SELECT sum(numdiaper) as total FROM sno_permiso WHERE codemp='0001' AND codper='' AND feciniper>='' AND feciniper<='' AND afevacper=1 24/06/2021 22:21:57 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Fideicomiso MÉTODO->uf_procesar_personal_version2 ERROR->Invalid query: ERROR: date/time field value out of range: "2021-04-300" LINE 7: date_part('month',age('2021-04-300', sno_personal... ^ HINT: Perhaps you need a different "datestyle" setting. Whole query: SELECT sno_hpersonalnomina.codper, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codded, sno_hpersonalnomina.codtipper, sno_hpersonalnomina.fecingper, sno_personal.fecingper AS fecingpersonal, MAX(sno_hpersonalnomina.codtabvac) AS codtabvac, date_part('year',age('2021-04-30', sno_personal.fecingper)) AS anos, date_part('month',age('2021-04-300', sno_personal.fecingper)) AS meses, date_part('day',age('2021-04-30', sno_personal.fecingper)) AS dias, SUM(sno_hpersonalnomina.sueintper) AS sueintper, SUM((SELECT SUM(abs(sno_hsalida.valsal)) FROM sno_hsalida, sno_hconcepto WHERE sno_hconcepto.asifidper ='1' AND (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='R' OR sno_hsalida.tipsal='P1') AND sno_hsalida.codemp = sno_hpersonalnomina.codemp AND sno_hsalida.codnom = sno_hpersonalnomina.codnom AND sno_hsalida.anocur = sno_hpersonalnomina.anocur AND sno_hsalida.codperi = sno_hpersonalnomina.codperi AND sno_hsalida.codper = sno_hpersonalnomina.codper AND sno_hsalida.codemp = sno_hconcepto.codemp AND sno_hsalida.codnom = sno_hconcepto.codnom AND sno_hsalida.anocur = sno_hconcepto.anocur AND sno_hsalida.codperi = sno_hconcepto.codperi AND sno_hsalida.codconc = sno_hconcepto.codconc )) AS asifidper, SUM((SELECT SUM(abs(sno_hsalida.valsal)) FROM sno_hsalida, sno_hconcepto WHERE sno_hconcepto.sueintfid ='1' AND (sno_hsalida.tipsal='A' OR sno_hsalida.tipsal='P1') AND sno_hsalida.codemp = sno_hpersonalnomina.codemp AND sno_hsalida.codnom = sno_hpersonalnomina.codnom AND sno_hsalida.anocur = sno_hpersonalnomina.anocur AND sno_hsalida.codperi = sno_hpersonalnomina.codperi AND sno_hsalida.codper = sno_hpersonalnomina.codper AND sno_hsalida.codemp = sno_hconcepto.codemp AND sno_hsalida.codnom = sno_hconcepto.codnom AND sno_hsalida.anocur = sno_hconcepto.anocur AND sno_hsalida.codperi = sno_hconcepto.codperi AND sno_hsalida.codconc = sno_hconcepto.codconc )) AS sueintfid, SUM((SELECT SUM(abs(sno_hsalida.valsal)) FROM sno_hsalida, sno_hconcepto WHERE sno_hconcepto.asifidpat ='1' AND sno_hsalida.tipsal='P2' AND sno_hsalida.codemp = sno_hpersonalnomina.codemp AND sno_hsalida.codnom = sno_hpersonalnomina.codnom AND sno_hsalida.anocur = sno_hpersonalnomina.anocur AND sno_hsalida.codperi = sno_hpersonalnomina.codperi AND sno_hsalida.codper = sno_hpersonalnomina.codper AND sno_hsalida.codemp = sno_hconcepto.codemp AND sno_hsalida.codnom = sno_hconcepto.codnom AND sno_hsalida.anocur = sno_hconcepto.anocur AND sno_hsalida.codperi = sno_hconcepto.codperi AND sno_hsalida.codconc = sno_hconcepto.codconc)) AS asifidpat, (SELECT sno_fideicomiso.capantcom FROM sno_fideicomiso WHERE sno_fideicomiso.codemp = sno_hpersonalnomina.codemp AND sno_fideicomiso.codper = sno_hpersonalnomina.codper GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codper, sno_fideicomiso.capantcom ) AS capantcom, MAX(sno_hperiodo.fecdesper) AS fecdesper FROM sno_hpersonalnomina, sno_hnomina, sno_hperiodo,sno_personal WHERE sno_hpersonalnomina.codemp = '0001' AND ((sno_hpersonalnomina.codnom='0001') OR (sno_hpersonalnomina.codnom='1002')) AND sno_hpersonalnomina.anocur = '2021' AND (sno_hpersonalnomina.staper = '1' OR sno_hpersonalnomina.staper = '2') AND substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) = '04' AND substr(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2021' AND sno_hnomina.espnom = '0' AND sno_hpersonalnomina.codemp = sno_hnomina.codemp AND sno_hpersonalnomina.codnom = sno_hnomina.codnom AND sno_hpersonalnomina.anocur = sno_hnomina.anocurnom AND sno_hpersonalnomina.codperi = sno_hnomina.peractnom AND sno_hpersonalnomina.codemp = sno_hperiodo.codemp AND sno_hpersonalnomina.codnom = sno_hperiodo.codnom AND sno_hpersonalnomina.anocur = sno_hperiodo.anocur AND sno_hpersonalnomina.codperi = sno_hperiodo.codperi AND sno_personal.codemp = sno_hpersonalnomina.codemp AND sno_personal.codper = sno_hpersonalnomina.codper GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.codper, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codded, sno_hpersonalnomina.codtipper,sno_hpersonalnomina.fecingper,sno_personal.fecingper ORDER BY sno_hpersonalnomina.codper 24/06/2021 22:47:13 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Fideicomiso MÉTODO->uf_procesar_personal_version2 ERROR->Invalid query: ERROR: syntax error at or near "," LINE 1: ...i)VALUES ('0001','1002','0005308302','2021',04,0,0,,0,0,5,0) ^ Whole query: INSERT INTO sno_fideiperiodo (codemp,codnom,codper,anocurper,mescurper,bonvacper,bonfinper,sueintper,apoper,bonextper,diafid,diaadi)VALUES ('0001','1002','0005308302','2021',04,0,0,,0,0,5,0) 24/06/2021 22:52:09 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Fideicomiso MÉTODO->uf_procesar_personal_version2 ERROR->Invalid query: ERROR: syntax error at or near "," LINE 1: ...i)VALUES ('0001','1002','0005308302','2021',04,0,0,,0,0,5,0) ^ Whole query: INSERT INTO sno_fideiperiodo (codemp,codnom,codper,anocurper,mescurper,bonvacper,bonfinper,sueintper,apoper,bonextper,diafid,diaadi)VALUES ('0001','1002','0005308302','2021',04,0,0,,0,0,5,0)