09/09/2016 08:45:18 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 08:46:30 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:19:30 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:22:43 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:32:33 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:38:26 ***** ERROR DE SISTEMA: ***** eguevara ***** ERROR-> No se registraron movimientos para el comprobante. 09/09/2016 09:44:52 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:46:28 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR-> 09/09/2016 09:57:35 ***** ERROR DE SISTEMA: ***** eguevara ***** ERROR-> 09/09/2016 17:16:00 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: una subconsulta utilizada como expresión retornó más de un registro Whole query: SELECT DISTINCT (sno_personalnomina.codper), sno_personalnomina.codsubnom, sno_personalnomina.codasicar, sno_personalnomina.codtab, sno_personalnomina.codgra, sno_personalnomina.codpas, sno_personalnomina.sueper, sno_personalnomina.horper, sno_personalnomina.minorguniadm, sno_personalnomina.ofiuniadm, sno_personalnomina.uniuniadm, sno_personalnomina.depuniadm, sno_personalnomina.prouniadm, sno_personalnomina.pagbanper, sno_personalnomina.codban, sno_personalnomina.codcueban, sno_personalnomina.tipcuebanper, sno_personalnomina.codcar, sno_personalnomina.fecingper, sno_personalnomina.staper, sno_personalnomina.cueaboper, sno_personalnomina.fecculcontr, sno_personalnomina.codded, sno_personalnomina.codtipper, sno_personalnomina.quivacper, sno_personalnomina.codtabvac, sno_personalnomina.sueintper, sno_personalnomina.pagefeper, sno_personalnomina.sueproper, sno_personalnomina.codage, sno_personalnomina.fecegrper, sno_personalnomina.fecsusper, sno_personalnomina.cauegrper, sno_personalnomina.codescdoc, sno_personalnomina.codcladoc, sno_personalnomina.codubifis, sno_personalnomina.tipcestic, sno_personalnomina.conjub, sno_personalnomina.catjub, sno_personalnomina.codclavia, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personalnomina.codunirac, sno_personalnomina.pagtaqper, sno_unidadadmin.desuniadm, sno_dedicacion.desded, sno_tipopersonal.destipper, sno_subnomina.dessubnom, sno_personalnomina.grado, sno_tablavacacion.dentabvac, sno_escaladocente.desescdoc, sno_clasificaciondocente.descladoc, sno_ubicacionfisica.desubifis, sno_personalnomina.fecascper, sno_personalpension.suebasper, sno_personalpension.priespper, sno_personalpension.pritraper, sno_personalpension.priproper, sno_personalpension.prianoserper, sno_personalpension.pridesper, sno_personalpension.porpenper, sno_personalnomina.descasicar, sno_personalnomina.coddep, sno_personalnomina.obsrecper, sno_personalpension.prinoascper, sno_personalpension.monpenper, sno_personalpension.subtotper, sno_personalpension.tipjub, sno_personalpension.fecvid, sno_personalpension.prirem, sno_personalpension.segrem, sno_personalnomina.salnorper, sno_personalnomina.estencper, sno_personal.codger, (SELECT srh_departamento.dendep FROM srh_departamento WHERE srh_departamento.codemp=sno_personalnomina.codemp AND srh_departamento.coddep=sno_personalnomina.coddep) AS dendep, (SELECT descar FROM sno_cargo WHERE sno_cargo.codemp = sno_personalnomina.codemp AND sno_cargo.codnom = sno_personalnomina.codnom AND sno_cargo.codcar = sno_personalnomina.codcar) as descar, (SELECT denasicar FROM sno_asignacioncargo WHERE sno_asignacioncargo.codemp = sno_personalnomina.codemp AND sno_asignacioncargo.codnom = sno_personalnomina.codnom AND sno_asignacioncargo.codasicar = sno_personalnomina.codasicar) as denasicar, (SELECT destab FROM sno_tabulador WHERE sno_tabulador.codemp = sno_personalnomina.codemp AND sno_tabulador.codnom = sno_personalnomina.codnom AND sno_tabulador.codtab = sno_personalnomina.codtab) as destab, (SELECT moncomgra FROM sno_grado WHERE sno_grado.codemp = sno_personalnomina.codemp AND sno_grado.codnom = sno_personalnomina.codnom AND sno_grado.codtab = sno_personalnomina.codtab AND sno_grado.codpas = sno_personalnomina.codpas AND sno_grado.codgra = sno_personalnomina.codgra) as compensacion, (SELECT denominacion FROM scg_cuentas WHERE scg_cuentas.codemp = sno_personalnomina.codemp AND scg_cuentas.SC_cuenta = sno_personalnomina.cueaboper AND scg_cuentas.status = 'C') as dencueaboper, (SELECT nomban FROM scb_banco WHERE scb_banco.codemp = sno_personalnomina.codemp AND scb_banco.codban = sno_personalnomina.codban) as nomban, (SELECT nomage FROM scb_agencias WHERE scb_agencias.codemp = sno_personalnomina.codemp AND scb_agencias.codban = sno_personalnomina.codban AND scb_agencias.codage = sno_personalnomina.codage) as nomage, (SELECT dencat FROM scv_categorias WHERE scv_categorias.codemp = sno_personalnomina.codemp AND scv_categorias.codcat = sno_personalnomina.codclavia) as dencat FROM sno_personalnomina LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper, sno_personal, sno_subnomina, sno_unidadadmin, sno_dedicacion, sno_tipopersonal, sno_tablavacacion, sno_escaladocente, sno_clasificaciondocente, sno_ubicacionfisica WHERE sno_personalnomina.codemp = '0001' AND sno_personalnomina.codnom = '1402' AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.estper = '1' AND sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper AND sno_personalnomina.codemp = sno_subnomina.codemp AND sno_personalnomina.codnom = sno_subnomina.codnom AND sno_personalnomina.codsubnom = sno_subnomina.codsubnom 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_personalnomina.codemp = sno_dedicacion.codemp AND sno_personalnomina.codded = sno_dedicacion.codded AND sno_personalnomina.codemp = sno_tipopersonal.codemp AND sno_personalnomina.codded = sno_tipopersonal.codded AND sno_personalnomina.codtipper = sno_tipopersonal.codtipper AND sno_personalnomina.codemp = sno_tablavacacion.codemp AND sno_personalnomina.codtabvac = sno_tablavacacion.codtabvac AND sno_personalnomina.codemp = sno_escaladocente.codemp AND sno_personalnomina.codescdoc = sno_escaladocente.codescdoc AND sno_personalnomina.codemp = sno_clasificaciondocente.codemp AND sno_personalnomina.codescdoc = sno_clasificaciondocente.codescdoc AND sno_personalnomina.codcladoc = sno_clasificaciondocente.codcladoc AND sno_personalnomina.codemp = sno_ubicacionfisica.codemp AND sno_personalnomina.codubifis = sno_ubicacionfisica.codubifis ORDER BY sno_personalnomina.codper 09/09/2016 17:16:47 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: una subconsulta utilizada como expresión retornó más de un registro Whole query: SELECT DISTINCT (sno_personalnomina.codper), sno_personalnomina.codsubnom, sno_personalnomina.codasicar, sno_personalnomina.codtab, sno_personalnomina.codgra, sno_personalnomina.codpas, sno_personalnomina.sueper, sno_personalnomina.horper, sno_personalnomina.minorguniadm, sno_personalnomina.ofiuniadm, sno_personalnomina.uniuniadm, sno_personalnomina.depuniadm, sno_personalnomina.prouniadm, sno_personalnomina.pagbanper, sno_personalnomina.codban, sno_personalnomina.codcueban, sno_personalnomina.tipcuebanper, sno_personalnomina.codcar, sno_personalnomina.fecingper, sno_personalnomina.staper, sno_personalnomina.cueaboper, sno_personalnomina.fecculcontr, sno_personalnomina.codded, sno_personalnomina.codtipper, sno_personalnomina.quivacper, sno_personalnomina.codtabvac, sno_personalnomina.sueintper, sno_personalnomina.pagefeper, sno_personalnomina.sueproper, sno_personalnomina.codage, sno_personalnomina.fecegrper, sno_personalnomina.fecsusper, sno_personalnomina.cauegrper, sno_personalnomina.codescdoc, sno_personalnomina.codcladoc, sno_personalnomina.codubifis, sno_personalnomina.tipcestic, sno_personalnomina.conjub, sno_personalnomina.catjub, sno_personalnomina.codclavia, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personalnomina.codunirac, sno_personalnomina.pagtaqper, sno_unidadadmin.desuniadm, sno_dedicacion.desded, sno_tipopersonal.destipper, sno_subnomina.dessubnom, sno_personalnomina.grado, sno_tablavacacion.dentabvac, sno_escaladocente.desescdoc, sno_clasificaciondocente.descladoc, sno_ubicacionfisica.desubifis, sno_personalnomina.fecascper, sno_personalpension.suebasper, sno_personalpension.priespper, sno_personalpension.pritraper, sno_personalpension.priproper, sno_personalpension.prianoserper, sno_personalpension.pridesper, sno_personalpension.porpenper, sno_personalnomina.descasicar, sno_personalnomina.coddep, sno_personalnomina.obsrecper, sno_personalpension.prinoascper, sno_personalpension.monpenper, sno_personalpension.subtotper, sno_personalpension.tipjub, sno_personalpension.fecvid, sno_personalpension.prirem, sno_personalpension.segrem, sno_personalnomina.salnorper, sno_personalnomina.estencper, sno_personal.codger, (SELECT srh_departamento.dendep FROM srh_departamento WHERE srh_departamento.codemp=sno_personalnomina.codemp AND srh_departamento.coddep=sno_personalnomina.coddep) AS dendep, (SELECT descar FROM sno_cargo WHERE sno_cargo.codemp = sno_personalnomina.codemp AND sno_cargo.codnom = sno_personalnomina.codnom AND sno_cargo.codcar = sno_personalnomina.codcar) as descar, (SELECT denasicar FROM sno_asignacioncargo WHERE sno_asignacioncargo.codemp = sno_personalnomina.codemp AND sno_asignacioncargo.codnom = sno_personalnomina.codnom AND sno_asignacioncargo.codasicar = sno_personalnomina.codasicar) as denasicar, (SELECT destab FROM sno_tabulador WHERE sno_tabulador.codemp = sno_personalnomina.codemp AND sno_tabulador.codnom = sno_personalnomina.codnom AND sno_tabulador.codtab = sno_personalnomina.codtab) as destab, (SELECT moncomgra FROM sno_grado WHERE sno_grado.codemp = sno_personalnomina.codemp AND sno_grado.codnom = sno_personalnomina.codnom AND sno_grado.codtab = sno_personalnomina.codtab AND sno_grado.codpas = sno_personalnomina.codpas AND sno_grado.codgra = sno_personalnomina.codgra) as compensacion, (SELECT denominacion FROM scg_cuentas WHERE scg_cuentas.codemp = sno_personalnomina.codemp AND scg_cuentas.SC_cuenta = sno_personalnomina.cueaboper AND scg_cuentas.status = 'C') as dencueaboper, (SELECT nomban FROM scb_banco WHERE scb_banco.codemp = sno_personalnomina.codemp AND scb_banco.codban = sno_personalnomina.codban) as nomban, (SELECT nomage FROM scb_agencias WHERE scb_agencias.codemp = sno_personalnomina.codemp AND scb_agencias.codban = sno_personalnomina.codban AND scb_agencias.codage = sno_personalnomina.codage) as nomage, (SELECT dencat FROM scv_categorias WHERE scv_categorias.codemp = sno_personalnomina.codemp AND scv_categorias.codcat = sno_personalnomina.codclavia) as dencat FROM sno_personalnomina LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper, sno_personal, sno_subnomina, sno_unidadadmin, sno_dedicacion, sno_tipopersonal, sno_tablavacacion, sno_escaladocente, sno_clasificaciondocente, sno_ubicacionfisica WHERE sno_personalnomina.codemp = '0001' AND sno_personalnomina.codnom = '1402' AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.estper = '1' AND sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper AND sno_personalnomina.codemp = sno_subnomina.codemp AND sno_personalnomina.codnom = sno_subnomina.codnom AND sno_personalnomina.codsubnom = sno_subnomina.codsubnom 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_personalnomina.codemp = sno_dedicacion.codemp AND sno_personalnomina.codded = sno_dedicacion.codded AND sno_personalnomina.codemp = sno_tipopersonal.codemp AND sno_personalnomina.codded = sno_tipopersonal.codded AND sno_personalnomina.codtipper = sno_tipopersonal.codtipper AND sno_personalnomina.codemp = sno_tablavacacion.codemp AND sno_personalnomina.codtabvac = sno_tablavacacion.codtabvac AND sno_personalnomina.codemp = sno_escaladocente.codemp AND sno_personalnomina.codescdoc = sno_escaladocente.codescdoc AND sno_personalnomina.codemp = sno_clasificaciondocente.codemp AND sno_personalnomina.codescdoc = sno_clasificaciondocente.codescdoc AND sno_personalnomina.codcladoc = sno_clasificaciondocente.codcladoc AND sno_personalnomina.codemp = sno_ubicacionfisica.codemp AND sno_personalnomina.codubifis = sno_ubicacionfisica.codubifis ORDER BY sno_personalnomina.codper 09/09/2016 17:17:02 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: una subconsulta utilizada como expresión retornó más de un registro Whole query: SELECT DISTINCT (sno_personalnomina.codper), sno_personalnomina.codsubnom, sno_personalnomina.codasicar, sno_personalnomina.codtab, sno_personalnomina.codgra, sno_personalnomina.codpas, sno_personalnomina.sueper, sno_personalnomina.horper, sno_personalnomina.minorguniadm, sno_personalnomina.ofiuniadm, sno_personalnomina.uniuniadm, sno_personalnomina.depuniadm, sno_personalnomina.prouniadm, sno_personalnomina.pagbanper, sno_personalnomina.codban, sno_personalnomina.codcueban, sno_personalnomina.tipcuebanper, sno_personalnomina.codcar, sno_personalnomina.fecingper, sno_personalnomina.staper, sno_personalnomina.cueaboper, sno_personalnomina.fecculcontr, sno_personalnomina.codded, sno_personalnomina.codtipper, sno_personalnomina.quivacper, sno_personalnomina.codtabvac, sno_personalnomina.sueintper, sno_personalnomina.pagefeper, sno_personalnomina.sueproper, sno_personalnomina.codage, sno_personalnomina.fecegrper, sno_personalnomina.fecsusper, sno_personalnomina.cauegrper, sno_personalnomina.codescdoc, sno_personalnomina.codcladoc, sno_personalnomina.codubifis, sno_personalnomina.tipcestic, sno_personalnomina.conjub, sno_personalnomina.catjub, sno_personalnomina.codclavia, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personalnomina.codunirac, sno_personalnomina.pagtaqper, sno_unidadadmin.desuniadm, sno_dedicacion.desded, sno_tipopersonal.destipper, sno_subnomina.dessubnom, sno_personalnomina.grado, sno_tablavacacion.dentabvac, sno_escaladocente.desescdoc, sno_clasificaciondocente.descladoc, sno_ubicacionfisica.desubifis, sno_personalnomina.fecascper, sno_personalpension.suebasper, sno_personalpension.priespper, sno_personalpension.pritraper, sno_personalpension.priproper, sno_personalpension.prianoserper, sno_personalpension.pridesper, sno_personalpension.porpenper, sno_personalnomina.descasicar, sno_personalnomina.coddep, sno_personalnomina.obsrecper, sno_personalpension.prinoascper, sno_personalpension.monpenper, sno_personalpension.subtotper, sno_personalpension.tipjub, sno_personalpension.fecvid, sno_personalpension.prirem, sno_personalpension.segrem, sno_personalnomina.salnorper, sno_personalnomina.estencper, sno_personal.codger, (SELECT srh_departamento.dendep FROM srh_departamento WHERE srh_departamento.codemp=sno_personalnomina.codemp AND srh_departamento.coddep=sno_personalnomina.coddep) AS dendep, (SELECT descar FROM sno_cargo WHERE sno_cargo.codemp = sno_personalnomina.codemp AND sno_cargo.codnom = sno_personalnomina.codnom AND sno_cargo.codcar = sno_personalnomina.codcar) as descar, (SELECT denasicar FROM sno_asignacioncargo WHERE sno_asignacioncargo.codemp = sno_personalnomina.codemp AND sno_asignacioncargo.codnom = sno_personalnomina.codnom AND sno_asignacioncargo.codasicar = sno_personalnomina.codasicar) as denasicar, (SELECT destab FROM sno_tabulador WHERE sno_tabulador.codemp = sno_personalnomina.codemp AND sno_tabulador.codnom = sno_personalnomina.codnom AND sno_tabulador.codtab = sno_personalnomina.codtab) as destab, (SELECT moncomgra FROM sno_grado WHERE sno_grado.codemp = sno_personalnomina.codemp AND sno_grado.codnom = sno_personalnomina.codnom AND sno_grado.codtab = sno_personalnomina.codtab AND sno_grado.codpas = sno_personalnomina.codpas AND sno_grado.codgra = sno_personalnomina.codgra) as compensacion, (SELECT denominacion FROM scg_cuentas WHERE scg_cuentas.codemp = sno_personalnomina.codemp AND scg_cuentas.SC_cuenta = sno_personalnomina.cueaboper AND scg_cuentas.status = 'C') as dencueaboper, (SELECT nomban FROM scb_banco WHERE scb_banco.codemp = sno_personalnomina.codemp AND scb_banco.codban = sno_personalnomina.codban) as nomban, (SELECT nomage FROM scb_agencias WHERE scb_agencias.codemp = sno_personalnomina.codemp AND scb_agencias.codban = sno_personalnomina.codban AND scb_agencias.codage = sno_personalnomina.codage) as nomage, (SELECT dencat FROM scv_categorias WHERE scv_categorias.codemp = sno_personalnomina.codemp AND scv_categorias.codcat = sno_personalnomina.codclavia) as dencat FROM sno_personalnomina LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper, sno_personal, sno_subnomina, sno_unidadadmin, sno_dedicacion, sno_tipopersonal, sno_tablavacacion, sno_escaladocente, sno_clasificaciondocente, sno_ubicacionfisica WHERE sno_personalnomina.codemp = '0001' AND sno_personalnomina.codnom = '1402' AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.estper = '1' AND sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper AND sno_personalnomina.codemp = sno_subnomina.codemp AND sno_personalnomina.codnom = sno_subnomina.codnom AND sno_personalnomina.codsubnom = sno_subnomina.codsubnom 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_personalnomina.codemp = sno_dedicacion.codemp AND sno_personalnomina.codded = sno_dedicacion.codded AND sno_personalnomina.codemp = sno_tipopersonal.codemp AND sno_personalnomina.codded = sno_tipopersonal.codded AND sno_personalnomina.codtipper = sno_tipopersonal.codtipper AND sno_personalnomina.codemp = sno_tablavacacion.codemp AND sno_personalnomina.codtabvac = sno_tablavacacion.codtabvac AND sno_personalnomina.codemp = sno_escaladocente.codemp AND sno_personalnomina.codescdoc = sno_escaladocente.codescdoc AND sno_personalnomina.codemp = sno_clasificaciondocente.codemp AND sno_personalnomina.codescdoc = sno_clasificaciondocente.codescdoc AND sno_personalnomina.codcladoc = sno_clasificaciondocente.codcladoc AND sno_personalnomina.codemp = sno_ubicacionfisica.codemp AND sno_personalnomina.codubifis = sno_ubicacionfisica.codubifis ORDER BY sno_personalnomina.codper 09/09/2016 17:17:12 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: una subconsulta utilizada como expresión retornó más de un registro Whole query: SELECT DISTINCT (sno_personalnomina.codper), sno_personalnomina.codsubnom, sno_personalnomina.codasicar, sno_personalnomina.codtab, sno_personalnomina.codgra, sno_personalnomina.codpas, sno_personalnomina.sueper, sno_personalnomina.horper, sno_personalnomina.minorguniadm, sno_personalnomina.ofiuniadm, sno_personalnomina.uniuniadm, sno_personalnomina.depuniadm, sno_personalnomina.prouniadm, sno_personalnomina.pagbanper, sno_personalnomina.codban, sno_personalnomina.codcueban, sno_personalnomina.tipcuebanper, sno_personalnomina.codcar, sno_personalnomina.fecingper, sno_personalnomina.staper, sno_personalnomina.cueaboper, sno_personalnomina.fecculcontr, sno_personalnomina.codded, sno_personalnomina.codtipper, sno_personalnomina.quivacper, sno_personalnomina.codtabvac, sno_personalnomina.sueintper, sno_personalnomina.pagefeper, sno_personalnomina.sueproper, sno_personalnomina.codage, sno_personalnomina.fecegrper, sno_personalnomina.fecsusper, sno_personalnomina.cauegrper, sno_personalnomina.codescdoc, sno_personalnomina.codcladoc, sno_personalnomina.codubifis, sno_personalnomina.tipcestic, sno_personalnomina.conjub, sno_personalnomina.catjub, sno_personalnomina.codclavia, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personalnomina.codunirac, sno_personalnomina.pagtaqper, sno_unidadadmin.desuniadm, sno_dedicacion.desded, sno_tipopersonal.destipper, sno_subnomina.dessubnom, sno_personalnomina.grado, sno_tablavacacion.dentabvac, sno_escaladocente.desescdoc, sno_clasificaciondocente.descladoc, sno_ubicacionfisica.desubifis, sno_personalnomina.fecascper, sno_personalpension.suebasper, sno_personalpension.priespper, sno_personalpension.pritraper, sno_personalpension.priproper, sno_personalpension.prianoserper, sno_personalpension.pridesper, sno_personalpension.porpenper, sno_personalnomina.descasicar, sno_personalnomina.coddep, sno_personalnomina.obsrecper, sno_personalpension.prinoascper, sno_personalpension.monpenper, sno_personalpension.subtotper, sno_personalpension.tipjub, sno_personalpension.fecvid, sno_personalpension.prirem, sno_personalpension.segrem, sno_personalnomina.salnorper, sno_personalnomina.estencper, sno_personal.codger, (SELECT srh_departamento.dendep FROM srh_departamento WHERE srh_departamento.codemp=sno_personalnomina.codemp AND srh_departamento.coddep=sno_personalnomina.coddep) AS dendep, (SELECT descar FROM sno_cargo WHERE sno_cargo.codemp = sno_personalnomina.codemp AND sno_cargo.codnom = sno_personalnomina.codnom AND sno_cargo.codcar = sno_personalnomina.codcar) as descar, (SELECT denasicar FROM sno_asignacioncargo WHERE sno_asignacioncargo.codemp = sno_personalnomina.codemp AND sno_asignacioncargo.codnom = sno_personalnomina.codnom AND sno_asignacioncargo.codasicar = sno_personalnomina.codasicar) as denasicar, (SELECT destab FROM sno_tabulador WHERE sno_tabulador.codemp = sno_personalnomina.codemp AND sno_tabulador.codnom = sno_personalnomina.codnom AND sno_tabulador.codtab = sno_personalnomina.codtab) as destab, (SELECT moncomgra FROM sno_grado WHERE sno_grado.codemp = sno_personalnomina.codemp AND sno_grado.codnom = sno_personalnomina.codnom AND sno_grado.codtab = sno_personalnomina.codtab AND sno_grado.codpas = sno_personalnomina.codpas AND sno_grado.codgra = sno_personalnomina.codgra) as compensacion, (SELECT denominacion FROM scg_cuentas WHERE scg_cuentas.codemp = sno_personalnomina.codemp AND scg_cuentas.SC_cuenta = sno_personalnomina.cueaboper AND scg_cuentas.status = 'C') as dencueaboper, (SELECT nomban FROM scb_banco WHERE scb_banco.codemp = sno_personalnomina.codemp AND scb_banco.codban = sno_personalnomina.codban) as nomban, (SELECT nomage FROM scb_agencias WHERE scb_agencias.codemp = sno_personalnomina.codemp AND scb_agencias.codban = sno_personalnomina.codban AND scb_agencias.codage = sno_personalnomina.codage) as nomage, (SELECT dencat FROM scv_categorias WHERE scv_categorias.codemp = sno_personalnomina.codemp AND scv_categorias.codcat = sno_personalnomina.codclavia) as dencat FROM sno_personalnomina LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper, sno_personal, sno_subnomina, sno_unidadadmin, sno_dedicacion, sno_tipopersonal, sno_tablavacacion, sno_escaladocente, sno_clasificaciondocente, sno_ubicacionfisica WHERE sno_personalnomina.codemp = '0001' AND sno_personalnomina.codnom = '1402' AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.estper = '1' AND sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper AND sno_personalnomina.codemp = sno_subnomina.codemp AND sno_personalnomina.codnom = sno_subnomina.codnom AND sno_personalnomina.codsubnom = sno_subnomina.codsubnom 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_personalnomina.codemp = sno_dedicacion.codemp AND sno_personalnomina.codded = sno_dedicacion.codded AND sno_personalnomina.codemp = sno_tipopersonal.codemp AND sno_personalnomina.codded = sno_tipopersonal.codded AND sno_personalnomina.codtipper = sno_tipopersonal.codtipper AND sno_personalnomina.codemp = sno_tablavacacion.codemp AND sno_personalnomina.codtabvac = sno_tablavacacion.codtabvac AND sno_personalnomina.codemp = sno_escaladocente.codemp AND sno_personalnomina.codescdoc = sno_escaladocente.codescdoc AND sno_personalnomina.codemp = sno_clasificaciondocente.codemp AND sno_personalnomina.codescdoc = sno_clasificaciondocente.codescdoc AND sno_personalnomina.codcladoc = sno_clasificaciondocente.codcladoc AND sno_personalnomina.codemp = sno_ubicacionfisica.codemp AND sno_personalnomina.codubifis = sno_ubicacionfisica.codubifis ORDER BY sno_personalnomina.codper 09/09/2016 17:18:03 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: una subconsulta utilizada como expresión retornó más de un registro Whole query: SELECT DISTINCT (sno_personalnomina.codper), sno_personalnomina.codsubnom, sno_personalnomina.codasicar, sno_personalnomina.codtab, sno_personalnomina.codgra, sno_personalnomina.codpas, sno_personalnomina.sueper, sno_personalnomina.horper, sno_personalnomina.minorguniadm, sno_personalnomina.ofiuniadm, sno_personalnomina.uniuniadm, sno_personalnomina.depuniadm, sno_personalnomina.prouniadm, sno_personalnomina.pagbanper, sno_personalnomina.codban, sno_personalnomina.codcueban, sno_personalnomina.tipcuebanper, sno_personalnomina.codcar, sno_personalnomina.fecingper, sno_personalnomina.staper, sno_personalnomina.cueaboper, sno_personalnomina.fecculcontr, sno_personalnomina.codded, sno_personalnomina.codtipper, sno_personalnomina.quivacper, sno_personalnomina.codtabvac, sno_personalnomina.sueintper, sno_personalnomina.pagefeper, sno_personalnomina.sueproper, sno_personalnomina.codage, sno_personalnomina.fecegrper, sno_personalnomina.fecsusper, sno_personalnomina.cauegrper, sno_personalnomina.codescdoc, sno_personalnomina.codcladoc, sno_personalnomina.codubifis, sno_personalnomina.tipcestic, sno_personalnomina.conjub, sno_personalnomina.catjub, sno_personalnomina.codclavia, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personalnomina.codunirac, sno_personalnomina.pagtaqper, sno_unidadadmin.desuniadm, sno_dedicacion.desded, sno_tipopersonal.destipper, sno_subnomina.dessubnom, sno_personalnomina.grado, sno_tablavacacion.dentabvac, sno_escaladocente.desescdoc, sno_clasificaciondocente.descladoc, sno_ubicacionfisica.desubifis, sno_personalnomina.fecascper, sno_personalpension.suebasper, sno_personalpension.priespper, sno_personalpension.pritraper, sno_personalpension.priproper, sno_personalpension.prianoserper, sno_personalpension.pridesper, sno_personalpension.porpenper, sno_personalnomina.descasicar, sno_personalnomina.coddep, sno_personalnomina.obsrecper, sno_personalpension.prinoascper, sno_personalpension.monpenper, sno_personalpension.subtotper, sno_personalpension.tipjub, sno_personalpension.fecvid, sno_personalpension.prirem, sno_personalpension.segrem, sno_personalnomina.salnorper, sno_personalnomina.estencper, sno_personal.codger, (SELECT srh_departamento.dendep FROM srh_departamento WHERE srh_departamento.codemp=sno_personalnomina.codemp AND srh_departamento.coddep=sno_personalnomina.coddep) AS dendep, (SELECT descar FROM sno_cargo WHERE sno_cargo.codemp = sno_personalnomina.codemp AND sno_cargo.codnom = sno_personalnomina.codnom AND sno_cargo.codcar = sno_personalnomina.codcar) as descar, (SELECT denasicar FROM sno_asignacioncargo WHERE sno_asignacioncargo.codemp = sno_personalnomina.codemp AND sno_asignacioncargo.codnom = sno_personalnomina.codnom AND sno_asignacioncargo.codasicar = sno_personalnomina.codasicar) as denasicar, (SELECT destab FROM sno_tabulador WHERE sno_tabulador.codemp = sno_personalnomina.codemp AND sno_tabulador.codnom = sno_personalnomina.codnom AND sno_tabulador.codtab = sno_personalnomina.codtab) as destab, (SELECT moncomgra FROM sno_grado WHERE sno_grado.codemp = sno_personalnomina.codemp AND sno_grado.codnom = sno_personalnomina.codnom AND sno_grado.codtab = sno_personalnomina.codtab AND sno_grado.codpas = sno_personalnomina.codpas AND sno_grado.codgra = sno_personalnomina.codgra) as compensacion, (SELECT denominacion FROM scg_cuentas WHERE scg_cuentas.codemp = sno_personalnomina.codemp AND scg_cuentas.SC_cuenta = sno_personalnomina.cueaboper AND scg_cuentas.status = 'C') as dencueaboper, (SELECT nomban FROM scb_banco WHERE scb_banco.codemp = sno_personalnomina.codemp AND scb_banco.codban = sno_personalnomina.codban) as nomban, (SELECT nomage FROM scb_agencias WHERE scb_agencias.codemp = sno_personalnomina.codemp AND scb_agencias.codban = sno_personalnomina.codban AND scb_agencias.codage = sno_personalnomina.codage) as nomage, (SELECT dencat FROM scv_categorias WHERE scv_categorias.codemp = sno_personalnomina.codemp AND scv_categorias.codcat = sno_personalnomina.codclavia) as dencat FROM sno_personalnomina LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper, sno_personal, sno_subnomina, sno_unidadadmin, sno_dedicacion, sno_tipopersonal, sno_tablavacacion, sno_escaladocente, sno_clasificaciondocente, sno_ubicacionfisica WHERE sno_personalnomina.codemp = '0001' AND sno_personalnomina.codnom = '1402' AND sno_personal.codper ILIKE '%%' AND sno_personal.cedper ILIKE '%11233553%' AND sno_personal.nomper ILIKE '%%' AND sno_personal.apeper ILIKE '%%' AND sno_personal.numexpper ILIKE '%%' AND sno_personal.estper = '1' AND sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper AND sno_personalnomina.codemp = sno_subnomina.codemp AND sno_personalnomina.codnom = sno_subnomina.codnom AND sno_personalnomina.codsubnom = sno_subnomina.codsubnom 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_personalnomina.codemp = sno_dedicacion.codemp AND sno_personalnomina.codded = sno_dedicacion.codded AND sno_personalnomina.codemp = sno_tipopersonal.codemp AND sno_personalnomina.codded = sno_tipopersonal.codded AND sno_personalnomina.codtipper = sno_tipopersonal.codtipper AND sno_personalnomina.codemp = sno_tablavacacion.codemp AND sno_personalnomina.codtabvac = sno_tablavacacion.codtabvac AND sno_personalnomina.codemp = sno_escaladocente.codemp AND sno_personalnomina.codescdoc = sno_escaladocente.codescdoc AND sno_personalnomina.codemp = sno_clasificaciondocente.codemp AND sno_personalnomina.codescdoc = sno_clasificaciondocente.codescdoc AND sno_personalnomina.codcladoc = sno_clasificaciondocente.codcladoc AND sno_personalnomina.codemp = sno_ubicacionfisica.codemp AND sno_personalnomina.codubifis = sno_ubicacionfisica.codubifis ORDER BY sno_personalnomina.codper