24/11/2021 00:06:46 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->Despacho MÉTODO->uf_siv_insert_dt_despacho ERROR->Invalid query: ERROR: invalid input syntax for type double precision: "2e-08.00" LINE 1: ... '15.0000','0.0000','15.000','15.000','0.000','2e-08.00'... ^ Whole query: INSERT INTO siv_dt_despacho(codemp,numorddes,codart,numreg,codalm,unidad,canorisolsep,canmayori,candetori,canart,canmay,candet,preuniart, monsubart,montotart,canpenart,orden) VALUES ('0001','000000000005638','00000000000000003144','1','0000000028','D','15.000', '15.0000','0.0000','15.000','15.000','0.000','2e-08.00','0.00','0.00','0.000','4') 24/11/2021 00:09:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->despacho MÉTODO->uf_siv_obtener_dt_solicitud_II ERROR->Invalid query: ERROR: function round(double precision, integer) does not exist LINE 3: round(siv_articulo.precompa,2) AS precompa, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Whole query: SELECT siv_articulo.denart,siv_articulo.sc_cuenta,siv_articulo.ctlcaja, siv_articulo.codtipcont,siv_articulo.canuni,siv_articulo.contvacio, round(siv_articulo.precompa,2) AS precompa, (SELECT unidad FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS unidad, (SELECT denunimed FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS denunimed, (SELECT tipart FROM siv_tipoarticulo WHERE siv_articulo.codtipart=siv_tipoarticulo.codtipart) AS tipart FROM siv_articulo LEFT JOIN rpc_proveedor ON siv_articulo.cod_pro=rpc_proveedor.cod_pro WHERE siv_articulo.codemp='0001' AND siv_articulo.codart='00000000000001014858' 24/11/2021 00:09:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->despacho MÉTODO->uf_siv_obtener_dt_solicitud_II ERROR->Invalid query: ERROR: function round(double precision, integer) does not exist LINE 3: round(siv_articulo.precompa,2) AS precompa, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Whole query: SELECT siv_articulo.denart,siv_articulo.sc_cuenta,siv_articulo.ctlcaja, siv_articulo.codtipcont,siv_articulo.canuni,siv_articulo.contvacio, round(siv_articulo.precompa,2) AS precompa, (SELECT unidad FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS unidad, (SELECT denunimed FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS denunimed, (SELECT tipart FROM siv_tipoarticulo WHERE siv_articulo.codtipart=siv_tipoarticulo.codtipart) AS tipart FROM siv_articulo LEFT JOIN rpc_proveedor ON siv_articulo.cod_pro=rpc_proveedor.cod_pro WHERE siv_articulo.codemp='0001' AND siv_articulo.codart='00000000000000003023' 24/11/2021 00:09:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->despacho MÉTODO->uf_siv_obtener_dt_solicitud_II ERROR->Invalid query: ERROR: function round(double precision, integer) does not exist LINE 3: round(siv_articulo.precompa,2) AS precompa, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Whole query: SELECT siv_articulo.denart,siv_articulo.sc_cuenta,siv_articulo.ctlcaja, siv_articulo.codtipcont,siv_articulo.canuni,siv_articulo.contvacio, round(siv_articulo.precompa,2) AS precompa, (SELECT unidad FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS unidad, (SELECT denunimed FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS denunimed, (SELECT tipart FROM siv_tipoarticulo WHERE siv_articulo.codtipart=siv_tipoarticulo.codtipart) AS tipart FROM siv_articulo LEFT JOIN rpc_proveedor ON siv_articulo.cod_pro=rpc_proveedor.cod_pro WHERE siv_articulo.codemp='0001' AND siv_articulo.codart='00000000000000003024' 24/11/2021 00:09:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->despacho MÉTODO->uf_siv_obtener_dt_solicitud_II ERROR->Invalid query: ERROR: function round(double precision, integer) does not exist LINE 3: round(siv_articulo.precompa,2) AS precompa, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Whole query: SELECT siv_articulo.denart,siv_articulo.sc_cuenta,siv_articulo.ctlcaja, siv_articulo.codtipcont,siv_articulo.canuni,siv_articulo.contvacio, round(siv_articulo.precompa,2) AS precompa, (SELECT unidad FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS unidad, (SELECT denunimed FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS denunimed, (SELECT tipart FROM siv_tipoarticulo WHERE siv_articulo.codtipart=siv_tipoarticulo.codtipart) AS tipart FROM siv_articulo LEFT JOIN rpc_proveedor ON siv_articulo.cod_pro=rpc_proveedor.cod_pro WHERE siv_articulo.codemp='0001' AND siv_articulo.codart='00000000000000003144' 24/11/2021 00:09:14 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->despacho MÉTODO->uf_siv_obtener_dt_solicitud_II ERROR->Invalid query: ERROR: function round(double precision, integer) does not exist LINE 3: round(siv_articulo.precompa,2) AS precompa, ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Whole query: SELECT siv_articulo.denart,siv_articulo.sc_cuenta,siv_articulo.ctlcaja, siv_articulo.codtipcont,siv_articulo.canuni,siv_articulo.contvacio, round(siv_articulo.precompa,2) AS precompa, (SELECT unidad FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS unidad, (SELECT denunimed FROM siv_unidadmedida WHERE siv_articulo.codunimed=siv_unidadmedida.codunimed) AS denunimed, (SELECT tipart FROM siv_tipoarticulo WHERE siv_articulo.codtipart=siv_tipoarticulo.codtipart) AS tipart FROM siv_articulo LEFT JOIN rpc_proveedor ON siv_articulo.cod_pro=rpc_proveedor.cod_pro WHERE siv_articulo.codemp='0001' AND siv_articulo.codart='00000000000000003022'