19/03/2018 09:46:48  *****  ERROR DE SISTEMA:   *****  mramirez  *****  CLASE->Evaluador MÉTODO->uf_antiguedad_previa ERROR->Invalid query: ERROR:  no existe la columna per.diasservprevper
LINE 1: SELECT per.anoservpreper, per.messervpreper, per.diasservpre...
                                                     ^
Whole query: SELECT per.anoservpreper, per.messervpreper, per.diasservprevper FROM sno_personal per WHERE per.codper='0018402255' AND per.codemp = '0001'

19/03/2018 09:58:35  *****  ERROR DE SISTEMA:   *****  mramirez  *****  CLASE->Selecionar hnomina MÉTODO->uf_procesar_sql ERROR->Invalid query: ERROR:  no existe la columna «codbenfid» en la relación «sno_thnomina»
LINE 1: ...odorgcestic, confidnom, recdocfid,     tipdocfid, codbenfid,...
                                                             ^
Whole query: INSERT INTO sno_thnomina (codemp, codnom, anocurnom, peractnom, desnom, tippernom, despernom, fecininom, numpernom, tipnom, 			 subnom, racnom, adenom, espnom, ctnom, ctmetnom, diabonvacnom, diareivacnom, diainivacnom, diatopvacnom, 			 diaincvacnom, consulnom, descomnom, codpronom, codbennom, conaponom, cueconnom, notdebnom, numvounom, perresnom, 			 recdocnom, recdocapo, tipdocnom, tipdocapo, conpernom, conpronom, titrepnom, codorgcestic, confidnom, recdocfid, 			 tipdocfid, codbenfid, cueconfid, divcon,recdocpagperche,tipdocpagperche,estctaalt,racobrnom)      SELECT codemp, codnom, anocurnom, peractnom, desnom, tippernom, despernom, fecininom, numpernom, tipnom, subnom, racnom, 			 adenom, espnom, ctnom, ctmetnom, diabonvacnom, diareivacnom, diainivacnom, diatopvacnom, diaincvacnom, 			 consulnom, descomnom, codpronom, codbennom, conaponom, cueconnom, notdebnom, numvounom, perresnom,  recdocnom, 			 recdocapo, tipdocnom, tipdocapo, conpernom, conpronom, titrepnom, codorgcestic, confidnom, recdocfid, tipdocfid, 			 codbenfid, cueconfid, divcon,recdocpagperche,tipdocpagperche,estctaalt,racobrnom        FROM sno_hnomina       WHERE codemp='0001'        AND codnom='0001'        AND anocurnom='2013'        AND peractnom='012'

19/03/2018 10:05:36  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%subero%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

19/03/2018 10:06:29  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%5889326%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

19/03/2018 10:07:19  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%5889326%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

19/03/2018 10:10:09  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%5889%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

19/03/2018 10:10:32  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%5889%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper 

19/03/2018 10:11:15  *****  ERROR DE SISTEMA:   *****  mramirez  *****  ERROR->Invalid query: ERROR:  no existe la columna sno_personal.diasservprevper
LINE 1: ... sno_personal.anoservprefijo, sno_personal.codorg,sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, 		sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, 		sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, 		sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, 		sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, 		sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, 		sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, 		sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, 		sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, 		sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper,        sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper, 		sno_personal.codcom, sno_personal.codran, sno_personal.numexpper, sno_personal.codpainac, sno_personal.codestnac,sno_personal.codtippersss , sno_personal.enviorec, sno_personal.fecleypen, sno_personal.codcausa,        sno_personal.fecreingper, sno_personal.fecjubper, sno_personal.codunivipladin,         sno_personal.situacion, sno_personal.fecsitu, sno_personal.talcamper, sno_personal.talzapper,        sno_personal.talpanper,  sno_personal.anoservprecont, sno_personal.anoservprefijo, sno_personal.codorg,sno_personal.diasservprevper,        sno_personal.porcajahoper, sno_personal.codger, sno_personal.anoperobr,sno_personal.carantper,sno_personal.rifper,sno_personal.messervpreper, 
						sno_personal.habediusu, sno_personal.feccieedi,
				       (SELECT denger FROM srh_gerencia          WHERE srh_gerencia.codemp = sno_personal.codemp            AND srh_gerencia.codger = sno_personal.codger ) AS denger,        (SELECT desorg FROM srh_organigrama          WHERE srh_organigrama.codemp = sno_personal.codemp            AND srh_organigrama.codorg = sno_personal.codorg ) AS desorg, 		(SELECT denunivipladin FROM srh_unidadvipladin 		  WHERE srh_unidadvipladin.codemp = sno_personal.codemp 			AND srh_unidadvipladin.codunivipladin = sno_personal.codunivipladin ) AS denunivipladin, 		(SELECT dentippersss FROM sno_tipopersonalsss WHERE  sno_tipopersonalsss.codemp= sno_personal.codemp AND sno_tipopersonalsss.codtippersss = sno_personal.codtippersss) as dentippersss,		(SELECT descom FROM sno_componente WHERE sno_componente.codemp = sno_personal.codemp AND sno_componente.codcom = sno_personal.codcom ) AS descom, 		(SELECT desran FROM sno_rango WHERE sno_rango.codemp = sno_personal.codemp AND sno_rango.codcom = sno_personal.codcom AND sno_rango.codran = sno_personal.codran) AS desran, 		(SELECT despai FROM sigesp_pais WHERE sigesp_pais.codpai = sno_personal.codpainac ) AS despainac, 		(SELECT desest FROM sigesp_estados WHERE sigesp_estados.codpai = sno_personal.codpainac AND sigesp_estados.codest = sno_personal.codestnac ) AS desestnac   FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia  WHERE sno_personal.codemp='0001'   AND sno_profesion.codemp = sno_personal.codemp    AND sno_profesion.codpro = sno_personal.codpro    AND sigesp_pais.codpai = sno_personal.codpai    AND sigesp_estados.codpai = sno_personal.codpai    AND sigesp_estados.codest = sno_personal.codest    AND sigesp_municipio.codpai = sno_personal.codpai    AND sigesp_municipio.codest = sno_personal.codest    AND sigesp_municipio.codmun = sno_personal.codmun    AND sigesp_parroquia.codpai = sno_personal.codpai    AND sigesp_parroquia.codest = sno_personal.codest    AND sigesp_parroquia.codmun = sno_personal.codmun    AND sigesp_parroquia.codpar = sno_personal.codpar    AND sno_personal.codper ILIKE '%%'    AND sno_personal.cedper ILIKE '%%'   AND sno_personal.nomper ILIKE '%%'    AND sno_personal.apeper ILIKE '%subero%'   AND sno_personal.numexpper ILIKE '%%'  AND sno_personal.codper IN (SELECT sno_personal.codper FROM  sss_permisos_internos,sno_personal WHERE  sss_permisos_internos.codsis='SNO' AND sss_permisos_internos.codusu='mramirez'  AND sss_permisos_internos.enabled=1 AND sno_personal.codtippersss=sss_permisos_internos.codintper  ) ORDER BY sno_personal.codper