31/10/2016 09:58:51 ***** ERROR DE SISTEMA: ***** mbarrios ***** ERROR->Invalid query: ERROR: las expresiones de SELECT DISTINCT ON deben coincidir con las expresiones iniciales de ORDER BY LINE 1: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hper... ^ Whole query: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hperiodo.fechasper as char(10)),6,2)) sno_hperiodo.anocur, substr(cast(sno_hperiodo.fechasper as char(10)),6,2) as mes FROM sno_hperiodo, sno_hnomina, sno_periodo WHERE sno_hnomina.espnom='0' AND sno_periodo.cerper= 1 AND sno_hperiodo.codemp=sno_hnomina.codemp AND sno_hperiodo.codnom=sno_hnomina.codnom AND sno_hperiodo.codemp=sno_periodo.codemp AND sno_hperiodo.codnom=sno_periodo.codnom AND sno_hperiodo.codperi=sno_periodo.codperi AND (substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) NOT IN (SELECT LPAD(cast(mescurper as char(2)),2,'0') FROM sno_fideiperiodo WHERE sno_hperiodo.codemp=sno_fideiperiodo.codemp AND sno_hperiodo.codnom=sno_fideiperiodo.codnom AND sno_hperiodo.anocur=sno_fideiperiodo.anocurper)) AND sno_hperiodo.codemp='0001' GROUP BY sno_hperiodo.anocur, sno_hperiodo.fechasper ORDER BY sno_hperiodo.anocur, sno_hperiodo.fechasper, sno_hperiodo.codperi 31/10/2016 09:59:04 ***** ERROR DE SISTEMA: ***** mbarrios ***** ERROR->Invalid query: ERROR: las expresiones de SELECT DISTINCT ON deben coincidir con las expresiones iniciales de ORDER BY LINE 1: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hper... ^ Whole query: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hperiodo.fechasper as char(10)),6,2)) sno_hperiodo.anocur, substr(cast(sno_hperiodo.fechasper as char(10)),6,2) as mes FROM sno_hperiodo, sno_hnomina, sno_periodo WHERE sno_hnomina.espnom='0' AND sno_periodo.cerper= 1 AND sno_hperiodo.codemp=sno_hnomina.codemp AND sno_hperiodo.codnom=sno_hnomina.codnom AND sno_hperiodo.codemp=sno_periodo.codemp AND sno_hperiodo.codnom=sno_periodo.codnom AND sno_hperiodo.codperi=sno_periodo.codperi AND (substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) NOT IN (SELECT LPAD(cast(mescurper as char(2)),2,'0') FROM sno_fideiperiodo WHERE sno_hperiodo.codemp=sno_fideiperiodo.codemp AND sno_hperiodo.codnom=sno_fideiperiodo.codnom AND sno_hperiodo.anocur=sno_fideiperiodo.anocurper)) AND sno_hperiodo.codemp='0001' GROUP BY sno_hperiodo.anocur, sno_hperiodo.fechasper ORDER BY sno_hperiodo.anocur, sno_hperiodo.fechasper, sno_hperiodo.codperi 31/10/2016 11:52:32 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: las expresiones de SELECT DISTINCT ON deben coincidir con las expresiones iniciales de ORDER BY LINE 1: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hper... ^ Whole query: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hperiodo.fechasper as char(10)),6,2)) sno_hperiodo.anocur, substr(cast(sno_hperiodo.fechasper as char(10)),6,2) as mes FROM sno_hperiodo, sno_hnomina, sno_periodo WHERE sno_hnomina.espnom='0' AND sno_periodo.cerper= 1 AND sno_hperiodo.codemp=sno_hnomina.codemp AND sno_hperiodo.codnom=sno_hnomina.codnom AND sno_hperiodo.codemp=sno_periodo.codemp AND sno_hperiodo.codnom=sno_periodo.codnom AND sno_hperiodo.codperi=sno_periodo.codperi AND (substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) NOT IN (SELECT LPAD(cast(mescurper as char(2)),2,'0') FROM sno_fideiperiodo WHERE sno_hperiodo.codemp=sno_fideiperiodo.codemp AND sno_hperiodo.codnom=sno_fideiperiodo.codnom AND sno_hperiodo.anocur=sno_fideiperiodo.anocurper)) AND sno_hperiodo.codemp='0001' GROUP BY sno_hperiodo.anocur, sno_hperiodo.fechasper ORDER BY sno_hperiodo.anocur, sno_hperiodo.fechasper, sno_hperiodo.codperi 31/10/2016 11:52:52 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: las expresiones de SELECT DISTINCT ON deben coincidir con las expresiones iniciales de ORDER BY LINE 1: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hper... ^ Whole query: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hperiodo.fechasper as char(10)),6,2)) sno_hperiodo.anocur, substr(cast(sno_hperiodo.fechasper as char(10)),6,2) as mes FROM sno_hperiodo, sno_hnomina, sno_periodo WHERE sno_hnomina.espnom='0' AND sno_periodo.cerper= 1 AND sno_hperiodo.codemp=sno_hnomina.codemp AND sno_hperiodo.codnom=sno_hnomina.codnom AND sno_hperiodo.codemp=sno_periodo.codemp AND sno_hperiodo.codnom=sno_periodo.codnom AND sno_hperiodo.codperi=sno_periodo.codperi AND (substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) NOT IN (SELECT LPAD(cast(mescurper as char(2)),2,'0') FROM sno_fideiperiodo WHERE sno_hperiodo.codemp=sno_fideiperiodo.codemp AND sno_hperiodo.codnom=sno_fideiperiodo.codnom AND sno_hperiodo.anocur=sno_fideiperiodo.anocurper)) AND sno_hperiodo.codemp='0001' GROUP BY sno_hperiodo.anocur, sno_hperiodo.fechasper ORDER BY sno_hperiodo.anocur, sno_hperiodo.fechasper, sno_hperiodo.codperi 31/10/2016 13:09:44 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Invalid query: ERROR: las expresiones de SELECT DISTINCT ON deben coincidir con las expresiones iniciales de ORDER BY LINE 1: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hper... ^ Whole query: SELECT DISTINCT ON (sno_hperiodo.anocur,substr(cast(sno_hperiodo.fechasper as char(10)),6,2)) sno_hperiodo.anocur, substr(cast(sno_hperiodo.fechasper as char(10)),6,2) as mes FROM sno_hperiodo, sno_hnomina, sno_periodo WHERE sno_hnomina.espnom='0' AND sno_periodo.cerper= 1 AND sno_hperiodo.codemp=sno_hnomina.codemp AND sno_hperiodo.codnom=sno_hnomina.codnom AND sno_hperiodo.codemp=sno_periodo.codemp AND sno_hperiodo.codnom=sno_periodo.codnom AND sno_hperiodo.codperi=sno_periodo.codperi AND (substr(cast(sno_hperiodo.fecdesper as char(10)),6,2) NOT IN (SELECT LPAD(cast(mescurper as char(2)),2,'0') FROM sno_fideiperiodo WHERE sno_hperiodo.codemp=sno_fideiperiodo.codemp AND sno_hperiodo.codnom=sno_fideiperiodo.codnom AND sno_hperiodo.anocur=sno_fideiperiodo.anocurper)) AND sno_hperiodo.codemp='0001' GROUP BY sno_hperiodo.anocur, sno_hperiodo.fechasper ORDER BY sno_hperiodo.anocur, sno_hperiodo.fechasper, sno_hperiodo.codperi 31/10/2016 14:30:53 ***** ERROR DE SISTEMA: ***** ysantiago ***** 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, CXP000000003503). 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','CXP000000003503','----------','23216615', '05','B','2016-10-31','LIQUIDACION DE PRESTACIONES SOCIALES POR SUBROGACION LABRA NORTE 80, C.A (EJE SAN AGUSTIN EGRESO) FI 11-01-2016 FE 30-09-2016','E', 65221.66,'',0,'CXPSOP','-','----','0', '','SOPA','','0') 31/10/2016 16:49:30 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo MÉTODO->uf_registrar_nomina_en_historico ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_hnomina» DETAIL: Ya existe la llave (codemp, codnom, anocurnom, peractnom)=(0001, 1509, 2016, 021). Whole query: INSERT INTO sno_hnomina(codemp,codnom,desnom,tippernom,despernom,anocurnom,fecininom,peractnom,numpernom, tipnom,subnom,racnom,adenom,espnom,ctnom,ctmetnom,diabonvacnom,diareivacnom,diainivacnom, diatopvacnom,diaincvacnom,consulnom,descomnom,codpronom,codbennom,conaponom,cueconnom, notdebnom,numvounom,perresnom,recdocnom,recdocapo,tipdocnom,tipdocapo,conpernom,conpronom, titrepnom, codorgcestic,confidnom,recdocfid,tipdocfid,codbenfid,cueconfid, divcon, informa, recdocpagperche,tipdocpagperche,estctaalt,racobrnom,nomliq,hojtienom,cestiksuel,nomespfid) VALUES ('0001','1509','ALUMBRADO PUBLICO','1', 'QUINCENAL','2016','2016-01-01','021', '24','2','0','0','0', '0','0','','0','0', '0','0','0','OCP', 'B','----------','0000000001','OCP', '','0','0','000','0', '0','','','0','0', '','','OC','0','', '','','0',' ', '1','00003', '0','0','0', '0','0','') 31/10/2016 16:49:30 ***** ERROR DE SISTEMA: ***** rhernandez ***** CLASE->Cierre Periodo MÉTODO->uf_registrar_nomina_en_historico ERROR->Invalid query: ERROR: llave duplicada viola restricción de unicidad «pk_sno_hnomina» DETAIL: Ya existe la llave (codemp, codnom, anocurnom, peractnom)=(0001, 1509, 2016, 021). Whole query: INSERT INTO sno_hnomina(codemp,codnom,desnom,tippernom,despernom,anocurnom,fecininom,peractnom,numpernom, tipnom,subnom,racnom,adenom,espnom,ctnom,ctmetnom,diabonvacnom,diareivacnom,diainivacnom, diatopvacnom,diaincvacnom,consulnom,descomnom,codpronom,codbennom,conaponom,cueconnom, notdebnom,numvounom,perresnom,recdocnom,recdocapo,tipdocnom,tipdocapo,conpernom,conpronom, titrepnom, codorgcestic,confidnom,recdocfid,tipdocfid,codbenfid,cueconfid, divcon, informa, recdocpagperche,tipdocpagperche,estctaalt,racobrnom,nomliq,hojtienom,cestiksuel,nomespfid) VALUES ('0001','1509','ALUMBRADO PUBLICO','1', 'QUINCENAL','2016','2016-01-01','021', '24','2','0','0','0', '0','0','','0','0', '0','0','0','OCP', 'B','----------','0000000001','OCP', '','0','0','000','0', '0','','','0','0', '','','OC','0','', '','','0',' ', '1','00003', '0','0','0', '0','0','') 31/10/2016 18:14:16 ***** ERROR DE SISTEMA: ***** rhernandez ***** ERROR->Error de Anidamiento en Concepto 0000000001. 31/10/2016 18:26:04 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Nómina MÉTODO->uf_insert_nomina ERROR->Invalid query: ERROR: el valor es demasiado largo para el tipo character varying(20) Whole query: INSERT INTO sno_nomina(codemp,codnom,desnom,tippernom,despernom,anocurnom,fecininom,peractnom,numpernom,tipnom, subnom,racnom,adenom,espnom,ctnom,ctmetnom,diabonvacnom,diareivacnom,diainivacnom,diatopvacnom, diaincvacnom,consulnom,descomnom,codpronom,codbennom,conaponom,cueconnom,notdebnom,numvounom,recdocnom,tipdocnom,recdocapo,tipdocapo,perresnom,conpernom,conpronom,titrepnom,codorgcestic,confidnom,recdocfid,tipdocfid,codbenfid,cueconfid,divcon,informa,recdocpagperche,tipdocpagperche,estctaalt,racobrnom,nomliq,hojtienom,cestiksuel) VALUES ('0001','1707','BONIFICACION DE FIN DE AÑO 2016','2','BONIFICACION DE FIN DE AÑO 2016','2016','2016-11-01','001',12,'4',0,1,0,0,0, '','0','0','0','0', '0','OC','B','----------','0000000001','OCP', '','0','0','1','00015','0', '','000','0','0','','','OC','0','','----------','','0', ' ' ,'0' ,'', '0','0','0','0','0') 31/10/2016 20:06:14 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Concepto MÉTODO->uf_select_guard_status ERROR->Invalid query: ERROR: no existe la columna «apliconst» LINE 1: ... WHERE codemp='0001' AND codnom='1600' AND apliconst=... ^ Whole query: SELECT codconc FROM sno_concepto WHERE codemp='0001' AND codnom='1600' AND apliconst='1' 31/10/2016 20:06:22 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Concepto MÉTODO->uf_select_guard_status ERROR->Invalid query: ERROR: no existe la columna «apliconst» LINE 1: ... WHERE codemp='0001' AND codnom='1600' AND apliconst=... ^ Whole query: SELECT codconc FROM sno_concepto WHERE codemp='0001' AND codnom='1600' AND apliconst='1' 31/10/2016 20:06:22 ***** ERROR DE SISTEMA: ***** mramirez ***** CLASE->Concepto MÉTODO->uf_load_concepto ERROR->Invalid query: ERROR: no existe la columna «apliconst» LINE 1: ... WHERE codemp='0001' AND codnom='1600' AND apliconst=... ^ Whole query: SELECT 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,estcla, intingcon, spi_cuenta, poringcon, repacucon, repconsunicon, consunicon,repconsuniconc, consuniconc, quirepcon, frevarcon, asifidper, asifidpat, persalnor, aplresenc, conperenc,codente, guarrepcon, aplidiasadd,prorat,sueintfid, apliconst, (SELECT descripcion_ente FROM sno_entes WHERE codigo_ente = codente) as nombre_ente, (SELECT nompro FROM rpc_proveedor WHERE codemp='0001' AND rpc_proveedor.cod_pro=sno_concepto.codprov) as proveedor, (SELECT nombene FROM rpc_beneficiario WHERE codemp='0001' AND rpc_beneficiario.ced_bene=sno_concepto.cedben) as beneficiario, (SELECT denominacion FROM scg_cuentas WHERE codemp='0001' AND scg_cuentas.sc_cuenta=sno_concepto.cueconcon) as dencuecon, (SELECT denominacion FROM spi_cuentas WHERE codemp='0001' AND spi_cuentas.spi_cuenta=sno_concepto.spi_cuenta) as dencueing, (SELECT denominacion FROM scg_cuentas WHERE codemp='0001' AND scg_cuentas.sc_cuenta=sno_concepto.cueconpatcon) as dencueconpat, (SELECT denestpro1 FROM spg_ep1 WHERE spg_ep1.codemp='0001' AND spg_ep1.codestpro1=sno_concepto.codestpro1 AND spg_ep1.estcla = sno_concepto.estcla) as denestpro1, (SELECT denestpro2 FROM spg_ep2 WHERE spg_ep2.codemp='0001' AND spg_ep2.codestpro1=sno_concepto.codestpro1 AND spg_ep2.codestpro2=sno_concepto.codestpro2 AND spg_ep2.estcla = sno_concepto.estcla ) as denestpro2, (SELECT denestpro3 FROM spg_ep3 WHERE spg_ep3.codemp='0001' AND spg_ep3.codestpro1=sno_concepto.codestpro1 AND spg_ep3.codestpro2=sno_concepto.codestpro2 AND spg_ep3.codestpro3=sno_concepto.codestpro3 AND spg_ep3.estcla = sno_concepto.estcla) as denestpro3, (SELECT denestpro4 FROM spg_ep4 WHERE spg_ep4.codemp='0001' AND spg_ep4.codestpro1=sno_concepto.codestpro1 AND spg_ep4.codestpro2=sno_concepto.codestpro2 AND spg_ep4.codestpro3=sno_concepto.codestpro3 AND spg_ep4.codestpro4=sno_concepto.codestpro4 AND spg_ep4.estcla = sno_concepto.estcla) as denestpro4, (SELECT denestpro5 FROM spg_ep5 WHERE spg_ep5.codemp='0001' AND spg_ep5.codestpro1=sno_concepto.codestpro1 AND spg_ep5.codestpro2=sno_concepto.codestpro2 AND spg_ep5.codestpro3=sno_concepto.codestpro3 AND spg_ep5.codestpro4=sno_concepto.codestpro4 AND spg_ep5.codestpro5=sno_concepto.codestpro5 AND spg_ep5.estcla = sno_concepto.estcla) as denestpro5, '' as denprecon, '' as dencueprepat FROM sno_concepto WHERE codemp='0001' AND codnom='1600' AND codconc='0000009010' 31/10/2016 20:46:47 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** ERROR->CONSTANTE CT[0000003006] Nó Válido. Utilizado en el Concepto 0000002001 31/10/2016 20:46:47 ***** ERROR DE SISTEMA: ***** ccarrasquel ***** ERROR->CONSTANTE CT[0000003006] Nó Válido. Utilizado en el Concepto 0000002001