20/03/2021 02:44:05 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: insertar_cotizapedidoInvalid query: ERROR: invalid input syntax for integer: "GEN"
LINE 49: ...'','','','00:00:00','00:00:00','18','123','2','1','GEN','2',...
^
Whole query:
SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
INSERT INTO cxc_cotiza_pedidos(
codemp,
numcotped,
codproc,
id_cliente,
id_transp,
estcotped,
id_condpago,
id_vend,
codmon,
tascam,
codsuc,
feccotped,
fecvencotped,
porcdesc,
montodesc,
saldo,
subtot,
iva,
otros,
total,
baseimp,
descrip,
coment,
coduniadm,
codestpro1,
codestpro2,
codestpro3,
codestpro4,
codestpro5,
estcla,
aero_matricula,
aero_codequip,
aero_vuelo,
aero_aperturacompuerta,
aero_cierrecompuerta,
nav_id_buque, nav_codpai_bandera, nav_id_agente_naviero, nav_id_agente_aduanal,
nav_id_tipo_carga, nav_id_operador_portuario, nav_fec_zarpe,
nav_eslora, nav_viaje, nav_fec_arribo, nav_nrobultos, nav_bl_nro,
nav_peso, nav_arqueo_bruto, nav_consignatario, nav_desc_carga,
fecreg,
usureg,
horareg
)
VALUES ('0001','00000002','PED','87','10','EMI','7','1','USD','1820000','0001','2021-03-20','2021-03-20','0.00','0','0','4186000000','669760000','0','4855760000','4186000000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','','','','00:00:00','00:00:00','18','123','2','1','GEN','2','--','189.8','33445','--','1200','222888','2189','27011','Edgar Quintero
C.I.- Edgar Quintero','Carga de Prueba','2021-03-20','ADMINISTRADOR','02:44'); ; SELECT lastval() AS valor_id;
20/03/2021 02:45:50 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: insertar_cotizapedidoInvalid query: ERROR: invalid input syntax for integer: "GEN"
LINE 49: ...'','','','00:00:00','00:00:00','18','123','2','1','GEN','2',...
^
Whole query:
SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
INSERT INTO cxc_cotiza_pedidos(
codemp,
numcotped,
codproc,
id_cliente,
id_transp,
estcotped,
id_condpago,
id_vend,
codmon,
tascam,
codsuc,
feccotped,
fecvencotped,
porcdesc,
montodesc,
saldo,
subtot,
iva,
otros,
total,
baseimp,
descrip,
coment,
coduniadm,
codestpro1,
codestpro2,
codestpro3,
codestpro4,
codestpro5,
estcla,
aero_matricula,
aero_codequip,
aero_vuelo,
aero_aperturacompuerta,
aero_cierrecompuerta,
nav_id_buque, nav_codpai_bandera, nav_id_agente_naviero, nav_id_agente_aduanal,
nav_id_tipo_carga, nav_id_operador_portuario, nav_fec_zarpe,
nav_eslora, nav_viaje, nav_fec_arribo, nav_nrobultos, nav_bl_nro,
nav_peso, nav_arqueo_bruto, nav_consignatario, nav_desc_carga,
fecreg,
usureg,
horareg
)
VALUES ('0001','00000002','PED','87','10','EMI','7','1','USD','1820000','0001','2021-03-20','2021-03-20','0.00','0','0','4186000000','669760000','0','4855760000','4186000000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','','','','00:00:00','00:00:00','18','123','2','1','GEN','2','--','189.8','33445','--','1200','222888','2189','27011','Edgar Quintero
C.I.- Edgar Quintero','Carga de Prueba','2021-03-20','ADMINISTRADOR','02:45'); ; SELECT lastval() AS valor_id;
20/03/2021 02:56:15 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: insertar_cotizapedidoInvalid query: ERROR: invalid input syntax for type date: "--"
LINE 49: ...00:00:00','00:00:00','18','123','2','1','GEN','2','--','189....
^
Whole query:
SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
INSERT INTO cxc_cotiza_pedidos(
codemp,
numcotped,
codproc,
id_cliente,
id_transp,
estcotped,
id_condpago,
id_vend,
codmon,
tascam,
codsuc,
feccotped,
fecvencotped,
porcdesc,
montodesc,
saldo,
subtot,
iva,
otros,
total,
baseimp,
descrip,
coment,
coduniadm,
codestpro1,
codestpro2,
codestpro3,
codestpro4,
codestpro5,
estcla,
aero_matricula,
aero_codequip,
aero_vuelo,
aero_aperturacompuerta,
aero_cierrecompuerta,
nav_id_buque, nav_codpai_bandera, nav_id_agente_naviero, nav_id_agente_aduanal,
nav_id_tipo_carga, nav_id_operador_portuario, nav_fec_zarpe,
nav_eslora, nav_viaje, nav_fec_arribo, nav_nrobultos, nav_bl_nro,
nav_peso, nav_arqueo_bruto, nav_consignatario, nav_desc_carga,
fecreg,
usureg,
horareg
)
VALUES ('0001','00000002','PED','87','10','EMI','7','1','USD','1820000','0001','2021-03-20','2021-03-20','0.00','0','0','4186000000','669760000','0','4855760000','4186000000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','','','','00:00:00','00:00:00','18','123','2','1','GEN','2','--','189.8','33445','--','1200','222888','2189','27011','Edgar Quintero
C.I.- Edgar Quintero','Carga de Prueba','2021-03-20','ADMINISTRADOR','02:56'); ; SELECT lastval() AS valor_id;
20/03/2021 02:56:45 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: insertar_cotizapedidoInvalid query: ERROR: invalid input syntax for type date: "--"
LINE 49: ...00:00:00','00:00:00','18','123','2','1','GEN','2','--','189....
^
Whole query:
SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
INSERT INTO cxc_cotiza_pedidos(
codemp,
numcotped,
codproc,
id_cliente,
id_transp,
estcotped,
id_condpago,
id_vend,
codmon,
tascam,
codsuc,
feccotped,
fecvencotped,
porcdesc,
montodesc,
saldo,
subtot,
iva,
otros,
total,
baseimp,
descrip,
coment,
coduniadm,
codestpro1,
codestpro2,
codestpro3,
codestpro4,
codestpro5,
estcla,
aero_matricula,
aero_codequip,
aero_vuelo,
aero_aperturacompuerta,
aero_cierrecompuerta,
nav_id_buque, nav_codpai_bandera, nav_id_agente_naviero, nav_id_agente_aduanal,
nav_id_tipo_carga, nav_id_operador_portuario, nav_fec_zarpe,
nav_eslora, nav_viaje, nav_fec_arribo, nav_nrobultos, nav_bl_nro,
nav_peso, nav_arqueo_bruto, nav_consignatario, nav_desc_carga,
fecreg,
usureg,
horareg
)
VALUES ('0001','00000002','PED','87','10','EMI','7','1','USD','1820000','0001','2021-03-20','2021-03-20','0.00','0','0','4186000000','669760000','0','4855760000','4186000000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','','','','00:00:00','00:00:00','18','123','2','1','GEN','2','--','189.8','33445','--','1200','222888','2189','27011','Edgar Quintero
C.I.- Edgar Quintero','Carga de Prueba','2021-03-20','ADMINISTRADOR','02:56'); ; SELECT lastval() AS valor_id;