02/08/2019 10:09:44 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hclasificacionobrero ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «sno_hclasificacionobrero_pkey» DETAIL: Ya existe la llave (codemp, grado, codnom, anocur, codperi, anovig)=(0001, 0000, 3000, 2019, 007, 1900). Whole query: INSERT INTO sno_hclasificacionobrero (codemp, grado, codnom, anocur, codperi, suemin, suemax, tipcla, obscla, anovig, nrogac) SELECT codemp, grado, '3000' AS codnom, '2019' AS anocur, '007' AS codperi, suemin, suemax, tipcla, obscla, anovig, nrogac FROM sno_clasificacionobrero 02/08/2019 10:11:08 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hclasificacionobrero ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «sno_hclasificacionobrero_pkey» DETAIL: Ya existe la llave (codemp, grado, codnom, anocur, codperi, anovig)=(0001, 0001, 3000, 2019, 007, 2019). Whole query: INSERT INTO sno_hclasificacionobrero (codemp, grado, codnom, anocur, codperi, suemin, suemax, tipcla, obscla, anovig, nrogac) SELECT codemp, grado, '3000' AS codnom, '2019' AS anocur, '007' AS codperi, suemin, suemax, tipcla, obscla, anovig, nrogac FROM sno_clasificacionobrero 02/08/2019 10:11:29 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hconcepto ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_hconcepto» DETAIL: Ya existe la llave (codemp, codnom, codconc, anocur, codperi)=(0001, 3000, 0000000001, 2019, 007). Whole query: INSERT INTO sno_hconcepto (codemp, codnom, anocur, codperi, codconc, nomcon, titcon, sigcon, forcon, glocon, acumaxcon, valmincon, valmaxcon, concon, cueprecon, cueconcon, aplisrcon, sueintcon, intprocon, codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, forpatcon, cueprepatcon, cueconpatcon, titretempcon, titretpatcon, valminpatcon, valmaxpatcon, codprov, cedben, conprenom, sueintvaccon, aplarccon, conprocon, repacucon, repconsunicon, consunicon, estcla, intingcon, spi_cuenta, poringcon, quirepcon, asifidper, asifidpat, frevarcon,persalnor,aplresenc,conperenc,codente,guarrepcon,aplidiasadd,repconsuniconc,consuniconc,prorat,sueintfid, apliconst ) SELECT codemp,codnom,'2019' AS anocur,'007' AS codperi,codconc,nomcon,titcon, sigcon,forcon,glocon,acumaxcon,valmincon,valmaxcon,concon,cueprecon,cueconcon,aplisrcon,sueintcon, intprocon, codestpro1, codestpro2, codestpro3, codestpro4, codestpro5, forpatcon, cueprepatcon, cueconpatcon,titretempcon,titretpatcon,valminpatcon, valmaxpatcon,codprov,cedben,conprenom,sueintvaccon,aplarccon, conprocon, repacucon, repconsunicon, consunicon, estcla,intingcon, spi_cuenta, poringcon, quirepcon, asifidper, asifidpat, frevarcon, persalnor,aplresenc,conperenc, codente,guarrepcon, aplidiasadd,repconsuniconc,consuniconc,prorat,sueintfid, apliconst FROM sno_concepto WHERE codemp='0001' AND codnom='3000' 02/08/2019 10:12:18 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo2 MÉTODO->uf_insert_hconstante ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_hconstante» DETAIL: Ya existe la llave (codemp, codnom, codcons, anocur, codperi)=(0001, 3000, 0000000001, 2019, 007). Whole query: INSERT INTO sno_hconstante (codemp, codnom, anocur, codperi, codcons, nomcon, unicon, equcon, topcon, valcon, reicon, tipnumcon,conespseg,esttopmod,conperenc ) SELECT codemp,codnom,'2019' AS anocur, '007' AS codperi,codcons, nomcon,unicon,equcon,topcon,valcon,reicon,tipnumcon,conespseg,esttopmod,conperenc FROM sno_constante WHERE codemp='0001' AND codnom='3000'