06/02/2022 18:56:19  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  schema "sno_personal" does not exist
LINE 1: ...01'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2021'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2021'     AND ( sno_hpersonalnomina.codnom='1001'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_personal.codubifis '3020'    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_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/02/2022 18:56:38  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  schema "sno_personal" does not exist
LINE 1: ...01'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2021'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2021'     AND ( sno_hpersonalnomina.codnom='1001'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_personal.codubifis '3020'    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_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/02/2022 18:57:24  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  schema "sno_personal" does not exist
LINE 1: ...01'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_person...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2021'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2021'     AND ( sno_hpersonalnomina.codnom='1001'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_personal.codubifis '3020'    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_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper 

06/02/2022 18:59:19  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->Report MÉTODO->uf_retencionarc_personal ERROR->Invalid query: ERROR:  schema "sno_hpersonalnomina" does not exist
LINE 1: ...01'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_hperso...
                                                             ^
Whole query: SELECT sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper   FROM sno_personal, sno_personalisr, sno_hpersonalnomina, sno_hperiodo  WHERE sno_personal.codemp = '0001'    AND sno_hperiodo.anocur = '2021'    AND SUBSTR(cast(sno_hperiodo.fecdesper as char(10)),1,4) = '2021'     AND ( sno_hpersonalnomina.codnom='1001'  OR  sno_hpersonalnomina.codnom='1002'  ) AND sno_hpersonalnomina.codubifis '3020'    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_personalisr.codemp    AND sno_personal.codper = sno_personalisr.codper    AND sno_personal.codemp = sno_hpersonalnomina.codemp    AND sno_personal.codper = sno_hpersonalnomina.codper  GROUP BY sno_personal.codper, sno_personal.nacper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper ORDER BY sno_personal.codper