问题描述：

在服务编排中使用集成脚本，直接更新数据库的字段。使用 execute_update报错。

求求各位大神给予解答~~

1、集成脚本如下：

    //更新出库数量的pod值
    var sql="update t_im_saloutbillentry@scm set fk_sn_podqty = ?, fk_sn_confirmqty= ? where  fid=? and fmaterialid =?";
    var params = [1, 1, "1681957671885889536", "1660160151803419648"];
    var types =[BIGINT, BIGINT, VARCHAR, VARCHAR];
    var affected = execute_update(ierp, sql, params, types);
return affected;

2、报错信息

数据更新失败，原因是：ERROR: operator does not exist: bigint = character varying
  建议：No operator matches the given name and argument types. You might need to add explicit type casts.
  位置：85

提示：上述异常由“当前账套(self)”数据源抛出。若需要更详细的日志分析报错，请在连接配置“自身链接(self)”所对应的系统中获取更多日志。

DubboServerHandler-172.27.12.73:20880-thread-463/traceId:5a4f905f46ec3050/time:1683776317098

错误码：SQL_UPDATE_FAILURE@DatabaseErrorkd.isc.iscb.util.except.IscBizException: 
	at kd.isc.iscb.util.db.DbUtil.executeUpdate(DbUtil.java:635)
	at kd.isc.iscb.util.connector.s.ExecuteUpdate.call(ExecuteUpdate.java:45)
	at kd.isc.iscb.util.script.statement.Invocation.call(Invocation.java:66)
	at kd.isc.iscb.util.script.statement.Invocation.eval(Invocation.java:47)
	at kd.isc.iscb.util.script.Util.eval(Util.java:115)
	at kd.isc.iscb.util.script.feature.op.store.Assign$MultiAssign.eval(Assign.java:77)
	at kd.isc.iscb.util.script.Util.eval(Util.java:115)
	at kd.isc.iscb.util.script.statement.Block.eval(Block.java:43)
	at kd.isc.iscb.util.script.statement.Block.eval(Block.java:36)
	at kd.isc.iscb.util.script.Util.eval(Util.java:115)
	at kd.isc.iscb.util.script.parser.Program.eval(Program.java:71)
	at kd.isc.iscb.util.script.Script.eval(Script.java:280)
	at kd.isc.iscb.util.script.Script.eval(Script.java:264)
	at kd.isc.iscb.formplugin.dc.ScriptExecuteFormPlugin$1.invoke(ScriptExecuteFormPlugin.java:194)
	at kd.isc.iscb.platform.core.trace.TraceStack.trace(TraceStack.java:50)
	at kd.isc.iscb.platform.core.trace.TraceStack.trace(TraceStack.java:33)
	at kd.isc.iscb.formplugin.dc.ScriptExecuteFormPlugin.execute(ScriptExecuteFormPlugin.java:184)
	at kd.isc.iscb.formplugin.dc.ScriptExecuteFormPlugin.executeScript(ScriptExecuteFormPlugin.java:166)
	at kd.isc.iscb.formplugin.dc.ScriptExecuteFormPlugin.handleScript(ScriptExecuteFormPlugin.java:137)
	at kd.isc.iscb.formplugin.tools.AbstractScriptEditorFormPlugin.customEvent(AbstractScriptEditorFormPlugin.java:141)
	at kd.bos.form.plugin.FormViewPluginProxy.lambda$fireCustomEvent$11(FormViewPluginProxy.java:279)
	at kd.bos.form.plugin.FormViewPluginProxy.invokeMethod(FormViewPluginProxy.java:163)
	at kd.bos.form.plugin.FormViewPluginProxy.fireCustomEvent(FormViewPluginProxy.java:277)
	at kd.bos.mvc.form.FormController.customEvent(FormController.java:524)
	at sun.reflect.GeneratedMethodAccessor5394.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:278)
	at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:222)
	at kd.bos.mservice.form.FormServiceImpl.invokeMethod(FormServiceImpl.java:1561)
	at kd.bos.mservice.form.FormServiceImpl.invokeAction(FormServiceImpl.java:988)
	at kd.bos.mservice.form.FormServiceImpl.batchInvokeAction(FormServiceImpl.java:647)
	at sun.reflect.GeneratedMethodAccessor535.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at kd.bos.service.DispatchServiceImpl.invoke(DispatchServiceImpl.java:47)
	at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java)
	at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46)
	at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72)
	at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53)
	at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:66)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at kd.bos.mservice.rpc.dubbo.filter.RequestContextFilter.lambda$invokeProviderSide$0(RequestContextFilter.java:159)
	at kd.bos.mservice.rpc.dubbo.debug.DubboDebugUtil.invoke(DubboDebugUtil.java:46)
	at kd.bos.mservice.rpc.dubbo.filter.RequestContextFilter.invokeProviderSide(RequestContextFilter.java:150)
	at kd.bos.mservice.rpc.dubbo.filter.RequestContextFilter.invoke(RequestContextFilter.java:64)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:23)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at kd.bos.mservice.rpc.dubbo.filter.ProviderMetricFilter.invoke(ProviderMetricFilter.java:94)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at kd.bos.mservice.rpc.dubbo.filter.trace.ProviderSpanFilter.invoke(ProviderSpanFilter.java:84)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at kd.bos.mservice.circuitbreaker.filter.dubbo.CircuitbreakerFilter.lambda$invoke$0(CircuitbreakerFilter.java:34)
	at kd.bos.mservice.circuitbreaker.noop.NoopCircuitbreaker.call(NoopCircuitbreaker.java:43)
	at kd.bos.mservice.circuitbreaker.filter.dubbo.CircuitbreakerFilter.invoke(CircuitbreakerFilter.java:33)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at kd.bos.mservice.rpc.dubbo.filter.ThreadLifeCycleFilter.invoke(ThreadLifeCycleFilter.java:30)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:70)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:132)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38)
	at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
	at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:75)
	at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:102)
	at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:264)
	at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)
	at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable._run(ChannelEventRunnable.java:105)
	at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:67)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
  建议：No operator matches the given name and argument types. You might need to add explicit type casts.
  位置：85

提示：上述异常由“当前账套(self)”数据源抛出。若需要更详细的日志分析报错，请在连接配置“自身链接(self)”所对应的系统中获取更多日志。

	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
	at kd.bos.ksql.shell.KDPreparedStatement.executeUpdate(KDPreparedStatement.java:392)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
	at kd.bos.util.jdbcproxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:41)
	at kd.bos.util.jdbcproxy.PreparedStatementProxy.executeUpdate(PreparedStatementProxy.java:41)
	at kd.bos.trace.instrument.jdbc.PreparedStatementAOP.executeUpdate(PreparedStatementAOP.java:65)
	at kd.bos.db.tx.DelegatePreparedStatement.executeUpdate(DelegatePreparedStatement.java:45)
	at kd.isc.iscb.platform.core.connector.self.SelfPreparedStatement.executeUpdate(SelfPreparedStatement.java:117)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at kd.isc.iscb.platform.core.connector.JdbcConnectionWrapper$1.invoke(JdbcConnectionWrapper.java:562)
	at com.sun.proxy.$Proxy87.executeUpdate(Unknown Source)
	at kd.isc.iscb.util.db.DbUtil.executeUpdate(DbUtil.java:633)
	... 79 more

产品问题脚本使用 execute_update 函数报错 bigint = character varying

20 产品问题 脚本使用 execute_update 函数报错 bigint = character varying

恭喜您！

产品问题
脚本使用 execute_update 函数报错 bigint = character varying

20 产品问题脚本使用 execute_update 函数报错 bigint = character varying