错误如下
mservice-fi:(conn=3232237) Unknown error 1054
RequestContext: tenantId=cmhk-ierp, accountId=772929891338290176
SQL: /*ORM*/ SELECT T2.faccttableid,T1.fvalue,T1.faccountpart,T1.flosscarryto,T1.fcopyfrom,T1.FOrgID,T1.fdpropertyid2,T1.fdpropertyid3,T1.fdpropertyid4,T1.fdpropertyid5,T1.fdpropertyid6,T1.fdpropertyid7,T1.fdpropertyid8,T1.fdpropertyid9,T1.fdpropertyid10,T1.fdpropertyid1,T1.FModelID,T1.FDimensionID,T1.FMemberID,T1.FDisablerID,T1.fparentid,T1.fmodifierid,T1.fcreatorid,T1.fentryrate,T2.fdataresource,T2.facctformula,T1.fislosscarry,T1.fexchange,T1.fshareall,T1.FIsYearEndCarried,T1.FIsRelateOrg,T1.FIsParticipMerge,T1.FDataType,T1.FDrCRDirect,T1.FAccountType,T1.FAccountUse,T1.fsimplename,T1.FSeq,T1.FIsSysMember,T1.FDescription,T1.FAggOprt,T1.FStorageType,T1.FDisableDate,T1.fisleaf,T1.flevel,T1.flongnumber,T1.fmasterid,T1.fmodifytime,T1.fcreatetime,T1.fenable,T1.fstatus,T1.fname,T1.fnumber,T1.FId FROM T_BCM_StructOfAccount T1 LEFT JOIN T_BCM_StructOfAccount_S T2 ON T1.FId = T2.FId WHERE T1.FId= ?
Parameters: [983127256563979264]
Key: btnok
TraceId:2e6b501d48b97065
Instance:mservice-fi-4401078016
发生时间:Sun Oct 11 15:52:03 GMT+08:00 2020
===================================================
调用堆栈:
java.sql.SQLException: (conn=3232237) Unknown error 1054
RequestContext: tenantId=cmhk-ierp, accountId=772929891338290176
SQL: /*ORM*/ SELECT T2.faccttableid,T1.fvalue,T1.faccountpart,T1.flosscarryto,T1.fcopyfrom,T1.FOrgID,T1.fdpropertyid2,T1.fdpropertyid3,T1.fdpropertyid4,T1.fdpropertyid5,T1.fdpropertyid6,T1.fdpropertyid7,T1.fdpropertyid8,T1.fdpropertyid9,T1.fdpropertyid10,T1.fdpropertyid1,T1.FModelID,T1.FDimensionID,T1.FMemberID,T1.FDisablerID,T1.fparentid,T1.fmodifierid,T1.fcreatorid,T1.fentryrate,T2.fdataresource,T2.facctformula,T1.fislosscarry,T1.fexchange,T1.fshareall,T1.FIsYearEndCarried,T1.FIsRelateOrg,T1.FIsParticipMerge,T1.FDataType,T1.FDrCRDirect,T1.FAccountType,T1.FAccountUse,T1.fsimplename,T1.FSeq,T1.FIsSysMember,T1.FDescription,T1.FAggOprt,T1.FStorageType,T1.FDisableDate,T1.fisleaf,T1.flevel,T1.flongnumber,T1.fmasterid,T1.fmodifytime,T1.fcreatetime,T1.fenable,T1.fstatus,T1.fname,T1.fnumber,T1.FId FROM T_BCM_StructOfAccount T1 LEFT JOIN T_BCM_StructOfAccount_S T2 ON T1.FId = T2.FId WHERE T1.FId= ?
Parameters: [983127256563979264]
at kd.bos.db.AbstractDBImpl.rethrow(AbstractDBImpl.java:400)
at kd.bos.db.XDBImpl.query(XDBImpl.java:167)
at kd.bos.db.AbstractDBImpl.query(AbstractDBImpl.java:140)
at kd.bos.db.DB.lambda$query$1(DB.java:185)
at kd.bos.db.DB.executeSqlBuilder(DB.java:200)
at kd.bos.db.DB.query(DB.java:184)
at kd.bos.orm.dataentity.DataManagerImplement.doExecute(DataManagerImplement.java:2274)
at kd.bos.orm.dataentity.DataManagerImplement.executeReader(DataManagerImplement.java:2254)
at kd.bos.orm.dataentity.DataManagerImplement.select(DataManagerImplement.java:2141)
at kd.bos.orm.dataentity.DataManagerImplement.readToDataSet(DataManagerImplement.java:1867)
at kd.bos.orm.dataentity.DataManagerImplement.read(DataManagerImplement.java:1399)
at kd.bos.orm.dataentity.DataManagerImplement.read(DataManagerImplement.java:1283)
at kd.bos.data.BusinessDataReader.load(BusinessDataReader.java:65)
at kd.bos.data.BusinessDataReader.loadFromCache(BusinessDataReader.java:147)
at kd.bos.data.BusinessDataReader.loadFromCache(BusinessDataReader.java:96)
at kd.bos.mvc.form.FormDataModel.loadReferenceDataBatch(FormDataModel.java:130)
at kd.bos.entity.property.BasedataProp.setFieldValue(BasedataProp.java:444)
at kd.bos.entity.datamodel.AbstractFormDataModel.setValuePrivate(AbstractFormDataModel.java:1655)
at kd.bos.entity.datamodel.AbstractFormDataModel.setValue(AbstractFormDataModel.java:1568)
at kd.bos.entity.datamodel.AbstractFormDataModel.setValue(AbstractFormDataModel.java:1532)
at kd.fi.bcm.formplugin.database.BasedataEditSingleMemberF7.closedCallBack(BasedataEditSingleMemberF7.java:187)
at kd.bos.mvc.form.FormController.formClosedCallBack(FormController.java:592)
at kd.bos.mservice.form.FormServiceImpl.closeCallBack(FormServiceImpl.java:236)
at sun.reflect.GeneratedMethodAccessor1249.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:53)
at sun.reflect.GeneratedMethodAccessor582.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at kd.bos.mservice.rpc.dubbo.debug.LocalDebugProxy$1.lambda$invoke$0(LocalDebugProxy.java:61)
at kd.bos.mservice.rpc.dubbo.debug.DubboDebugUtil.invoke(DubboDebugUtil.java:49)
at kd.bos.mservice.rpc.dubbo.debug.LocalDebugProxy$1.invoke(LocalDebugProxy.java:58)
at com.sun.proxy.$Proxy40.invoke(Unknown Source)
at kd.bos.servicehelper.DispatchServiceHelper.invokeBOSService(DispatchServiceHelper.java:96)
at kd.bos.mvc.form.FormView.closeClientForm(FormView.java:752)
at kd.bos.mvc.form.FormView.onClose(FormView.java:702)
at kd.bos.mvc.form.FormView.close(FormView.java:698)
at kd.fi.bcm.formplugin.dimension.SingleMemberF7Plugin.exitAndReturn(SingleMemberF7Plugin.java:605)
at kd.fi.bcm.formplugin.dimension.SingleMemberF7Plugin.click(SingleMemberF7Plugin.java:629)
at kd.bos.form.control.Button.fireClick(Button.java:182)
at kd.bos.form.control.Button.click(Button.java:135)
at sun.reflect.GeneratedMethodAccessor1250.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:947)
at kd.bos.mservice.form.FormServiceImpl.invokeAction(FormServiceImpl.java:451)
at kd.bos.mservice.form.FormServiceImpl.batchInvokeAction(FormServiceImpl.java:313)
at sun.reflect.GeneratedMethodAccessor598.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:53)
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:64)
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:136)
at kd.bos.mservice.rpc.dubbo.debug.DubboDebugUtil.invoke(DubboDebugUtil.java:49)
at kd.bos.mservice.rpc.dubbo.filter.RequestContextFilter.invokeProviderSide(RequestContextFilter.java:130)
at kd.bos.mservice.rpc.dubbo.filter.RequestContextFilter.invoke(RequestContextFilter.java:55)
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:75)
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:33)
at kd.bos.mservice.circuitbreaker.noop.NoopCircuitbreaker.call(NoopCircuitbreaker.java:33)
at kd.bos.mservice.circuitbreaker.filter.dubbo.CircuitbreakerFilter.invoke(CircuitbreakerFilter.java:32)
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
at kd.bos.mservice.rpc.dubbo.filter.ThreadLifeCycleFilter.invoke(ThreadLifeCycleFilter.java:20)
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:113)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:89)
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:196)
at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)
at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:92)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLSyntaxErrorException: (conn=3232237) Unknown error 1054
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:273)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)
at kd.bos.ksql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:341)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at kd.bos.util.jdbcproxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:36)
at kd.bos.util.jdbcproxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:36)
at kd.bos.trace.instrument.jdbc.PreparedStatementAOP.executeQuery(PreparedStatementAOP.java:49)
at kd.bos.xdb.XDBExecutor.doQuery(XDBExecutor.java:182)
at kd.bos.xdb.XDBExecutor.query(XDBExecutor.java:159)
at kd.bos.xdb.ext.ExtXDB.query(ExtXDB.java:35)
at kd.bos.db.XDBImpl.query(XDBImpl.java:150)
... 95 more
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Unknown error 1054
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
... 107 more
Caused by: java.sql.SQLException: Unknown error 1054
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1674)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1536)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1499)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
... 108 more
分析
没有打印参数信息,在网上找了一些其他资料:
- 参数为数值,写成了没带引号的非数字参数 ,ffield=abcd;
- 在select中的查询字段不存在 ,select t1.fentryrate from t_bcm_xxx;
结论
经排查,问题2引发了上述报错。
版权声明:本文为hu00848原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。