09/08/2021 21:17:38 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Metodo LPH MÉTODO->uf_listado_gendisk ERROR->Invalid query: ERROR: more than one row returned by a subquery used as an expression Whole query: SELECT sno_hpersonalnomina.codper, sno_tipopersonal.tipperobr as codtipper, sno_personal.cedper, sno_personal.apeper, sno_personal.nomper, sno_hpersonalnomina.sueper, sno_hpersonalnomina.sueintper, sno_personal.nacper, sno_personal.fecnacper, sno_personal.sexper, sno_personal.fecingper, sno_personal.fecegrper, sno_hpersonalnomina.fecegrper AS fecegrnom, sno_personal.estper, sno_personal.cuecajahoper, sno_personal.edocivper, sno_hpersonalnomina.minorguniadm,sno_hpersonalnomina.ofiuniadm, sno_hpersonalnomina.uniuniadm,sno_hpersonalnomina.depuniadm,sno_hpersonalnomina.prouniadm,sno_hpersonalnomina.codcueban,sno_hpersonalnomina.codban, (SELECT SUM(valsal) FROM sno_hsalida, sno_hperiodo WHERE sno_hsalida.codconc IN ('') AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND sno_hsalida.tipsal='A' AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper) as sueintbanavih, (SELECT tipnom FROM sno_hnomina WHERE 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) as tipnom, (SELECT despernom FROM sno_hnomina WHERE 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) as despernom, (SELECT SUM(valsal) FROM sno_hsalida, sno_hperiodo WHERE (sno_hsalida.tipsal='P1' OR sno_hsalida.tipsal='V3' OR sno_hsalida.tipsal='W3' OR sno_hsalida.tipsal='Q1') AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper) as personal, (SELECT SUM(valsal) FROM sno_hsalida, sno_hperiodo WHERE (sno_hsalida.tipsal='P2' OR sno_hsalida.tipsal='V4' OR sno_hsalida.tipsal='W4' OR sno_hsalida.tipsal='Q2') AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper) as patron, (SELECT SUM(valsal) FROM sno_hsalida, sno_hperiodo WHERE (sno_hsalida.tipsal='P1' OR sno_hsalida.tipsal='V3' OR sno_hsalida.tipsal='W3' OR sno_hsalida.tipsal='Q1') AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) ) as totalpersonal, (SELECT SUM(valsal) FROM sno_hsalida, sno_hperiodo WHERE (sno_hsalida.tipsal='P2' OR sno_hsalida.tipsal='V4' OR sno_hsalida.tipsal='W4' OR sno_hsalida.tipsal='Q2') AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) ) as totalpatron, (SELECT DISTINCT acuemp FROM sno_hconceptopersonal, sno_hsalida, sno_hperiodo WHERE sno_hsalida.codemp = sno_hconceptopersonal.codemp AND sno_hsalida.codnom = sno_hconceptopersonal.codnom AND sno_hsalida.anocur = sno_hconceptopersonal.anocur AND sno_hsalida.codperi = sno_hconceptopersonal.codperi AND sno_hsalida.codconc = sno_hconceptopersonal.codconc AND sno_hsalida.codper = sno_hconceptopersonal.codper AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) GROUP BY sno_hpersonalnomina.codper, acuemp) as acumulado, (SELECT DISTINCT acuiniemp FROM sno_hconceptopersonal, sno_hsalida, sno_hperiodo WHERE sno_hsalida.codemp = sno_hconceptopersonal.codemp AND sno_hsalida.codnom = sno_hconceptopersonal.codnom AND sno_hsalida.anocur = sno_hconceptopersonal.anocur AND sno_hsalida.codperi = sno_hconceptopersonal.codperi AND sno_hsalida.codconc = sno_hconceptopersonal.codconc AND sno_hsalida.codper = sno_hconceptopersonal.codper AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) GROUP BY sno_hpersonalnomina.codper, acuiniemp) as acumuladoinicial, sum(sno_hpersonalnomina.sueintper) AS sueintpertot FROM sno_personal, sno_hpersonalnomina, sno_hsalida, sno_tipopersonal, sno_hperiodo WHERE sno_hpersonalnomina.codemp='0001' AND sno_hpersonalnomina.codnom>='0001' AND sno_hpersonalnomina.codnom<='0001' AND sno_hpersonalnomina.anocur='2021' AND sno_hpersonalnomina.codperi>='013' AND sno_hpersonalnomina.codperi<='013' AND (sno_hpersonalnomina.staper='1' OR sno_hpersonalnomina.staper='2') AND sno_hsalida.codnom>='0001' AND sno_hsalida.codnom<='0001' AND sno_hsalida.anocur='2021' AND sno_hsalida.codperi>='013' AND sno_hsalida.codperi<='013' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)>='07' AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),6,2)<='07' AND (sno_hsalida.codconc='0000008030' OR sno_hsalida.codconc='0000008220' ) AND sno_hsalida.codemp = sno_hperiodo.codemp AND sno_hsalida.codnom = sno_hperiodo.codnom AND sno_hsalida.anocur = sno_hperiodo.anocur AND sno_hsalida.codperi = sno_hperiodo.codperi AND sno_hpersonalnomina.codemp = sno_hsalida.codemp AND sno_hpersonalnomina.codnom = sno_hsalida.codnom AND sno_hpersonalnomina.anocur = sno_hsalida.anocur AND sno_hpersonalnomina.codperi = sno_hsalida.codperi AND sno_hpersonalnomina.codper = sno_hsalida.codper AND sno_personal.codemp = sno_hpersonalnomina.codemp AND sno_personal.codper = sno_hpersonalnomina.codper AND sno_hpersonalnomina.codemp = sno_tipopersonal.codemp AND sno_hpersonalnomina.codtipper = sno_tipopersonal.codtipper GROUP BY sno_hpersonalnomina.codemp, sno_hpersonalnomina.anocur, sno_hpersonalnomina.codnom, sno_hpersonalnomina.codperi, sno_hpersonalnomina.codper, sno_personal.cedper, sno_personal.apeper, sno_personal.nomper, sno_personal.nacper, sno_personal.fecnacper, sno_personal.sexper, sno_personal.fecingper, sno_personal.fecegrper, sno_personal.estper, sno_personal.cuecajahoper, sno_hpersonalnomina.fecegrper,sno_personal.edocivper,sno_hpersonalnomina.minorguniadm, sno_hpersonalnomina.ofiuniadm, sno_hpersonalnomina.uniuniadm,sno_hpersonalnomina.depuniadm,sno_hpersonalnomina.prouniadm, sno_hpersonalnomina.codcueban,sno_hpersonalnomina.codban, sno_hpersonalnomina.sueper, sno_hpersonalnomina.sueintper,sno_tipopersonal.tipperobr,sno_hperiodo.fecdesper ORDER BY sno_hpersonalnomina.codper