18/10/2021 07:46:07  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_fichapersonal_personal ERROR->Invalid query: ERROR:  relation "sno_personal.fotper" does not exist
LINE 1: ...sno_unidadadmin, sigesp_estados, sigesp_municipio,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper,        sno_personal.fecingper, sno_personal.dirper, sno_personal.coreleper, sno_personal.sexper, 		sno_personal.telhabper, sno_personal.telmovper, sno_personal.fecnacper, sno_personal.estper, 		sno_personal.nacper, sno_personal.edocivper, sno_personal.numhijper, sno_personal.fecegrper,			sno_profesion.despro, sno_unidadadmin.desuniadm, sigesp_estados.desest, sigesp_municipio.denmun,        (SELECT denasicar FROM sno_asignacioncargo    	     WHERE sno_personalnomina.codasicar<>'0000000'            AND sno_personalnomina.codemp = sno_asignacioncargo.codemp 		   AND sno_personalnomina.codnom = sno_asignacioncargo.codnom            AND sno_personalnomina.codasicar = sno_asignacioncargo.codasicar) as denasicar,        (SELECT descar FROM sno_cargo    	     WHERE sno_personalnomina.codcar<>'0000000000' 		   AND sno_personalnomina.codemp = sno_cargo.codemp 		   AND sno_personalnomina.codnom = sno_cargo.codnom            AND sno_personalnomina.codcar = sno_cargo.codcar) as descar   FROM sno_personal, sno_profesion, sno_personalnomina, sno_nomina, sno_unidadadmin, sigesp_estados, sigesp_municipio,sno_personal.fotper  WHERE sno_personal.codemp = '0001'    AND sno_personalnomina.codnom>='1001' AND sno_personalnomina.codnom<='1008' AND (sno_personalnomina.staper='1'  OR sno_personalnomina.staper='2'  OR sno_personalnomina.staper='3'  OR sno_personalnomina.staper='4'  ) AND sno_personal.codper>='0024940147' AND sno_personal.codper<='0024940147' AND (sno_personal.estper='1' ) AND (sno_personal.sexper='M'  OR sno_personal.sexper='F' )   AND sno_personal.codemp = sno_profesion.codemp 	AND sno_personal.codpro = sno_profesion.codpro    AND sno_personal.codemp = sno_personalnomina.codemp 	AND sno_personal.codper = sno_personalnomina.codper    AND sno_personalnomina.codemp = sno_nomina.codemp 	AND sno_personalnomina.codnom = sno_nomina.codnom     AND sno_personalnomina.codemp = sno_unidadadmin.codemp 	AND sno_personalnomina.minorguniadm = sno_unidadadmin.minorguniadm  	AND sno_personalnomina.ofiuniadm = sno_unidadadmin.ofiuniadm  	AND sno_personalnomina.uniuniadm = sno_unidadadmin.uniuniadm  	AND sno_personalnomina.depuniadm = sno_unidadadmin.depuniadm  	AND sno_personalnomina.prouniadm = sno_unidadadmin.prouniadm     AND sno_personal.codpai = sigesp_estados.codpai 	AND sno_personal.codest = sigesp_estados.codest    AND sno_personal.codpai = sigesp_municipio.codpai 	AND sno_personal.codest = sigesp_municipio.codest 	AND sno_personal.codmun = sigesp_municipio.codmun ORDER BY sno_personal.codper 

18/10/2021 07:46:35  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_fichapersonal_personal ERROR->Invalid query: ERROR:  relation "sno_personal.fotper" does not exist
LINE 1: ...sno_unidadadmin, sigesp_estados, sigesp_municipio,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper,        sno_personal.fecingper, sno_personal.dirper, sno_personal.coreleper, sno_personal.sexper, 		sno_personal.telhabper, sno_personal.telmovper, sno_personal.fecnacper, sno_personal.estper, 		sno_personal.nacper, sno_personal.edocivper, sno_personal.numhijper, sno_personal.fecegrper,			sno_profesion.despro, sno_unidadadmin.desuniadm, sigesp_estados.desest, sigesp_municipio.denmun,        (SELECT denasicar FROM sno_asignacioncargo    	     WHERE sno_personalnomina.codasicar<>'0000000'            AND sno_personalnomina.codemp = sno_asignacioncargo.codemp 		   AND sno_personalnomina.codnom = sno_asignacioncargo.codnom            AND sno_personalnomina.codasicar = sno_asignacioncargo.codasicar) as denasicar,        (SELECT descar FROM sno_cargo    	     WHERE sno_personalnomina.codcar<>'0000000000' 		   AND sno_personalnomina.codemp = sno_cargo.codemp 		   AND sno_personalnomina.codnom = sno_cargo.codnom            AND sno_personalnomina.codcar = sno_cargo.codcar) as descar   FROM sno_personal, sno_profesion, sno_personalnomina, sno_nomina, sno_unidadadmin, sigesp_estados, sigesp_municipio,sno_personal.fotper  WHERE sno_personal.codemp = '0001'    AND sno_personalnomina.codnom>='1001' AND sno_personalnomina.codnom<='1008' AND (sno_personalnomina.staper='1'  OR sno_personalnomina.staper='2'  OR sno_personalnomina.staper='3'  OR sno_personalnomina.staper='4'  ) AND sno_personal.codper>='0024940147' AND sno_personal.codper<='0024940147' AND (sno_personal.estper='1' ) AND (sno_personal.sexper='M'  OR sno_personal.sexper='F' )   AND sno_personal.codemp = sno_profesion.codemp 	AND sno_personal.codpro = sno_profesion.codpro    AND sno_personal.codemp = sno_personalnomina.codemp 	AND sno_personal.codper = sno_personalnomina.codper    AND sno_personalnomina.codemp = sno_nomina.codemp 	AND sno_personalnomina.codnom = sno_nomina.codnom     AND sno_personalnomina.codemp = sno_unidadadmin.codemp 	AND sno_personalnomina.minorguniadm = sno_unidadadmin.minorguniadm  	AND sno_personalnomina.ofiuniadm = sno_unidadadmin.ofiuniadm  	AND sno_personalnomina.uniuniadm = sno_unidadadmin.uniuniadm  	AND sno_personalnomina.depuniadm = sno_unidadadmin.depuniadm  	AND sno_personalnomina.prouniadm = sno_unidadadmin.prouniadm     AND sno_personal.codpai = sigesp_estados.codpai 	AND sno_personal.codest = sigesp_estados.codest    AND sno_personal.codpai = sigesp_municipio.codpai 	AND sno_personal.codest = sigesp_municipio.codest 	AND sno_personal.codmun = sigesp_municipio.codmun ORDER BY sno_personal.codper