25/07/2021 01:11:08 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_c_procesos
METODO: consulta_clientesInvalid query: ERROR: column c.id_cliente_origen does not exist
LINE 14: WHERE c.id_cliente_origen='179'
^
Whole query: SELECT c.*,tc.*,z.*,cc.*,v.*,cu.*,p.despai,e.desest,m.denmun,pa.denpar,ciu.desciu,
rut.codcliente as codruta, rut.nombre_cliente as nombreruta
FROM cxc_clientes c LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
LEFT JOIN cxc_vendedores v ON v.id_vend = c.id_vend
LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest
LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
LEFT JOIN scv_ciudades ciu ON ciu.codpai = c.codpai AND ciu.codest = c.codest AND ciu.codciu = c.codciu
LEFT JOIN cxc_clientes rut ON rut.id_cliente = c.id_ruta
WHERE c.id_cliente_origen='179'
25/07/2021 12:26:16 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** La cuenta Presupuestaria 30199010101 no esta registrada en la estructura indicada ---------------------------------------------------------------------------------------------------------------------------------
25/07/2021 12:26:16 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR-> No se registraron los detalles presupuestarioLa cuenta Presupuestaria 30199010101 no esta registrada en la estructura indicada ---------------------------------------------------------------------------------------------------------------------------------
25/07/2021 16:44:13 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_c_procesos
METODO: insertar_documentoInvalid query: ERROR: duplicate key value violates unique constraint "cxc_documento_codemp_key"
DETAIL: Key (codemp, codtipdoc, numdoc)=(0001, NC, 1) already exists.
Whole query: LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
SELECT reset_sequencia('cxc_documento','id_doc');
INSERT INTO cxc_documento(
codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact,
estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc,
saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc,
descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1,
codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc,
id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,
fecreg,
usureg, horareg
)
VALUES ('0001','0002','0002','NC','00000001','00000001','','142','P','USD','3548283.85','DEV','2021-07-25','0.00','0','0','177414192.5','28386270.8','0','177414192.5','205800463.3','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','0','2021-07-25','ADMINISTRADOR','16:44'); ; SELECT lastval() AS valor_id;
25/07/2021 16:46:26 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_c_procesos
METODO: insertar_documentoInvalid query: ERROR: insert or update on table "cxc_documento" violates foreign key constraint "fk_cxc_documento_cxc_factura"
DETAIL: Key (id_fact)=(142) is not present in table "cxc_factura".
Whole query: LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
SELECT reset_sequencia('cxc_documento','id_doc');
INSERT INTO cxc_documento(
codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact,
estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc,
saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc,
descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1,
codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc,
id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,
fecreg,
usureg, horareg
)
VALUES ('0001','0002','0002','NC','00000001','00000001','','142','P','USD','3548283.85','DEV','2021-07-25','0.00','0','0','177414192.5','28386270.8','0','177414192.5','205800463.3','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','0','2021-07-25','ADMINISTRADOR','16:46'); ; SELECT lastval() AS valor_id;
25/07/2021 20:47:16 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** NO TIENE PERMISO
25/07/2021 20:48:10 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** NO TIENE PERMISO
25/07/2021 20:54:54 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 20:56:39 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 20:59:15 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:01:17 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:02:09 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:08:18 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:08:44 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:15:54 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: invalid input syntax for type date: ""
LINE 1: ...r FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
^
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:20 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Dia Feriado MÉTODO->uf_select_diaferiado ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT fecfer FROM sno_diaferiado WHERE codemp='0001' AND fecfer=''
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Vacación MÉTODO->uf_load_periodo ERROR->Invalid query: ERROR: current transaction is aborted, commands ignored until end of transaction block
Whole query: SELECT codperi,fecdesper,fechasper FROM sno_hperiodo WHERE codemp='0001' AND codnom='1002' AND '2008-12-16'>=fecdesper AND '2008-12-16'<=fechasper
25/07/2021 21:18:21 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:27:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:33:30 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:34:48 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:35:28 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.
25/07/2021 21:37:23 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR->Ocurrio un error al generar las vacaciones.