24/10/2017 07:46:49 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000061, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 07:56:08 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000061, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 07:58:02 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000061, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 07:58:50 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000061, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 07:59:39 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000061, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 08:00:17 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000095, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 08:01:55 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000064, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1700' 24/10/2017 08:08:14 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hcargo ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_hcargo» DETAIL: Ya existe la llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1700, 0000000000, 2017, 020). Whole query: INSERT INTO sno_hcargo (codemp,codnom,anocur,codperi,codcar,descar) SELECT codemp,codnom,'2017' AS anocur,'020' AS codperi,codcar,descar FROM sno_cargo WHERE codemp='0001' AND codnom='1700' 24/10/2017 08:20:05 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1702, 0000000069, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1702' 24/10/2017 08:21:27 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1702, 0000000095, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1702' 24/10/2017 08:22:46 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1703, 0000000038, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1703' 24/10/2017 08:24:14 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1705, 0000001018, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1705' 24/10/2017 08:25:27 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1706, 0000000043, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1706' 24/10/2017 08:26:44 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1707, 0000000001, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1707' 24/10/2017 08:28:23 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1708, 0000124586, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1708' 24/10/2017 08:29:59 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1710, 0055456670, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1710' 24/10/2017 08:30:53 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1726, 0000000671, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1726' 24/10/2017 08:32:48 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1739, 0000000069, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1739' 24/10/2017 09:36:22 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1731, 0000000680, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1731' 24/10/2017 09:38:27 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1731, 0000000680, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1731' 24/10/2017 09:42:58 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1701, 0000000016, 2017, 020) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'020' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1701' 24/10/2017 09:44:51 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1501, 0000000016, 2017, 001) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'001' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1501' 24/10/2017 09:45:45 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1501, 0000000016, 2017, 001) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'001' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1501' 24/10/2017 09:46:20 ***** ERROR DE SISTEMA: ***** RSUAREZ ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hpersonalnomina ERROR->Invalid query: ERROR: inserción o actualización en la tabla «sno_hpersonalnomina» viola la llave foránea «fk_sno_hper_sno_hcarg_sno_hcar» DETAIL: La llave (codemp, codnom, codcar, anocur, codperi)=(0001, 1501, 0000000016, 2017, 001) no está presente en la tabla «sno_hcargo». Whole query: INSERT INTO sno_hpersonalnomina (codemp, codnom, anocur, codperi, codper,codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper,codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper,cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep, salnorper,estencper,obsrecper ) SELECT codemp, codnom, '2017' AS anocur,'001' AS codperi, codper, codsubnom, codtab, codasicar, codgra, codpas, sueper, horper, minorguniadm, ofiuniadm, uniuniadm, depuniadm, prouniadm, pagbanper, codban, codcueban, tipcuebanper, codcar, fecingper, staper, cueaboper, fecculcontr, codded, codtipper, quivacper, codtabvac, sueintper, pagefeper, sueproper, codage, fecegrper, fecsusper, cauegrper, codescdoc, codcladoc, codubifis, tipcestic, conjub, catjub, codclavia, codunirac, pagtaqper, fecascper, grado, descasicar, coddep,salnorper,estencper,obsrecper FROM sno_personalnomina WHERE codemp='0001' AND codnom='1501' 24/10/2017 11:07:31 ***** ERROR DE SISTEMA: ***** yrea ***** CLASE->Solicitud MÉTODO->uf_insert_solicitud ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_cxp_solicitudes» DETAIL: Ya existe la llave (codemp, numsol)=(0001, CXP000000004875). Whole query: INSERT INTO cxp_solicitudes (codemp, numsol, cod_pro, ced_bene, codfuefin, tipproben, fecemisol, consol, estprosol, monsol, obssol, estaprosol,procede,numordpagmin,codtipfon,repcajchi,nombenaltcre,tipsolpag,codmon,tascam) VALUES ('0001','CXP000000004875','0040732592','----------', '05','P','2017-10-24','FACT. 03261, 03262, 03263 ADQUISICIÓN DE MATERIAL DE OFICINA, LIMPIEZA Y ALIMENTOS','E', 444403942.66,'',0,'CXPSOP','-','----','0', '','SOPA','','0') 24/10/2017 14:06:38 ***** ERROR DE SISTEMA: ***** ytremont ***** CLASE->Solicitud MÉTODO->uf_insert_solicitud ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_cxp_solicitudes» DETAIL: Ya existe la llave (codemp, numsol)=(0001, CXP000000004884). Whole query: INSERT INTO cxp_solicitudes (codemp, numsol, cod_pro, ced_bene, codfuefin, tipproben, fecemisol, consol, estprosol, monsol, obssol, estaprosol,procede,numordpagmin,codtipfon,repcajchi,nombenaltcre,tipsolpag,codmon,tascam) VALUES ('0001','CXP000000004884','----------','0000000001', '05','B','2017-10-24','BONIFICACION FIN DE AÑO EMPLEADOS CONTRATADO - ENERO A DICIEMBRE 2017.','E', 171665533.24,'',0,'CXPSOP','-','----','0', '','SOPA','','0')