永洪社区

标题: 实时大屏报错提醒 [打印本页]

作者: efrick 时间: 2022-3-10 08:13
标题: 实时大屏报错提醒
大屏看板在数据实时刷新时，不可避免会出现各种报错(刷新时底层数据没处理完，等)。像这种情况应该如何隐藏报错。
添加了下列两个内置参数都设置为true，是否正确。

_RESULT_NOT_EMPTY_	Boolean	报表实时刷新时，如果执行的结果为空时，从缓存获取数据，以免出现空数据的现象
_WARNING2HINT_	Boolean	当报表出现错误弹框时，报表不弹出dialog进行提示（弹出后需要手动点击），改为hint进行提示

作者: yanieye 时间: 2022-3-10 08:13

efrick 发表于 2022-3-23 08:23
jar trace 如何添加？

请登录永洪的工单系统 http://online.yonghongtech.com/index.php/Home/Index/login.html 提交工单。
如果没有工单系统的账号，请联系对应的永洪商务人员。

作者: efrick 时间: 2022-3-10 08:22
或者说如何避免大屏定时刷新时，出现弹窗

作者: 永洪tech-Bella 时间: 2022-3-10 09:28
应该是可用的呢，添加参数然后观察下情况呢

作者: efrick 时间: 2022-3-10 10:30

永洪tech-Bella 发表于 2022-3-10 09:28
应该是可用的呢，添加参数然后观察下情况呢

添加后仍有报错弹出

作者: 永洪tech-Bella 时间: 2022-3-10 11:12

efrick 发表于 2022-3-10 10:30
添加后仍有报错弹出

看下添加的参数以及弹出报错的截图呢
另外产品版本是多少

作者: efrick 时间: 2022-3-10 13:15

永洪tech-Bella 发表于 2022-3-10 11:12
看下添加的参数以及弹出报错的截图呢
另外产品版本是多少

版本904

作者: 美滋滋 时间: 2022-3-10 13:19
本帖最后由美滋滋于 2022-3-10 13:20 编辑

我的理解:系统日志信息中包含 INFO,WARING,ERROR三个等级的信息，而_WARNING2HINT_ 这个参数只能将waring类的错误信息屏蔽，不弹窗，如果是ERROR级别的错误，仍旧会弹窗所以我觉得当出现错误时，最好的方法还是确定错误根本原因，然后解决问题。

作者: 永洪tech-Bella 时间: 2022-3-10 13:20

efrick 发表于 2022-3-10 13:15
版本904

好的，我们再看下

作者: 永洪tech-Bella 时间: 2022-3-10 13:42

永洪tech-Bella 发表于 2022-3-10 13:20
好的，我们再看下

感谢您的反馈，我们已定位该问题已经修复过，建议您升级到90最新版本（9061），以及之后的长期维护版本。
理论上，配置_WARNING2HINT_参数即可将这类弹框报错，转换为hint提示

作者: efrick 时间: 2022-3-11 11:47

美滋滋发表于 2022-3-10 13:19
我的理解:系统日志信息中包含 INFO,WARING,ERROR三个等级的信息，而_WARNING2HINT_ 这个参数只能将waring类 ...

报错如下
[2022-03-11 11:06:29.052] |-[INFO] |-[88344e2779b14d3fb88ba40afe7f4755] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202102.3e0b934f1e1.zb]', for job key: 'Job@10.96.119.93_5625007', in 1ms, prepare: 1ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625007,__none__/__none__,10.96.119.93>{executed: 16, pending: 9[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb,采购大屏-市场行情及平均采购价/F_202008.3e0b934f1cc.zb, more...]}]
[2022-03-11 11:06:29.052] |-[INFO] |-[88344e2779b14d3fb88ba40afe7f4755] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202103.3e0b934f1d4.zb, 采购大屏-市场行情及平均采购价/F_202109.3e0b934f1da.zb]', for job key: 'Job@10.96.119.93_5625007', in 1ms, prepare: 1ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625007,__none__/__none__,10.96.119.93>{executed: 19, pending: 6[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202008.3e0b934f1cc.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.052] |-[INFO] |-[88344e2779b14d3fb88ba40afe7f4755] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202112.3e0b934f1de.zb]', for job key: 'Job@10.96.119.93_5625007', in 0ms, prepare: 0ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625007,__none__/__none__,10.96.119.93>{executed: 20, pending: 5[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202008.3e0b934f1cc.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.052] |-[INFO] |-[88344e2779b14d3fb88ba40afe7f4755] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb]', for job key: 'Job@10.96.119.93_5625007', in 0ms, prepare: 0ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625007,__none__/__none__,10.96.119.93>{executed: 17, pending: 8[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202008.3e0b934f1cc.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.052] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202106.3e0b934f1d7.zb]', for job key: 'Job@10.96.119.93_5625011', in 0ms, prepare: 0ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625011,__none__/__none__,10.96.119.93>{executed: 17, pending: 8[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.052] |-[WARN] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:313)] |-[Failed to add map result for job 'Job@10.96.119.93_5625011', null]
java.lang.NullPointerException: null
at g5.dc.data.mr.MRAggrQuery.addRed(MRAggrQuery.java:434) ~[product-20211208.jar:?]
at g5.dc.data.mr.MRQuery.red(MRQuery.java:626) ~[product-20211208.jar:?]
at g5.dc.data.mr.RedQueryTask.exec(RedQueryTask.java:72) ~[product-20211208.jar:?]
at g5.dc.mr.GRedTask.add(GRedTask.java:295) [product-20211208.jar:?]
at g5.dc.mr.s.MapResultSProc$RedRunnable.run0(MapResultSProc.java:206) [product-20211208.jar:?]
at g5.dc.mr.s.MapResultSProc$RedRunnable.run(MapResultSProc.java:133) [product-20211208.jar:?]
at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:190) [product-20211208.jar:?]
at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:315) [product-20211208.jar:?]
[2022-03-11 11:06:29.052] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202102.3e0b934f1e1.zb, 采购大屏-市场行情及平均采购价/F_202112.3e0b934f1de.zb]', for job key: 'Job@10.96.119.93_5625011', in 1ms, prepare: 1ms, lock: 0ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625011,__none__/__none__,10.96.119.93>{executed: 19, pending: 6[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.053] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.grid.impl.DynamicStringSeg.convert(DynamicStringSeg.java:137)] |-[Slow DefStringSeg is used!]
[2022-03-11 11:06:29.053] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.AbsSetting.getBoolean(AbsSetting.java:359)] |-[boolean value does not exist: db.memory.debug]
[2022-03-11 11:06:29.053] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.complete(GRedTask.java:429)] |-[Dequeued a reduce key: Reduce-Job@10.96.119.93_5625011.]
[2022-03-11 11:06:29.053] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.c.RedResultCProc.serial0(RedResultCProc.java:75)] |-[Send reduce result to Client: 10.96.119.93, with rows: 0, for job key: Job@10.96.119.93_5625011]
[2022-03-11 11:06:29.054] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202103.3e0b934f1d4.zb]', for job key: 'Job@10.96.119.93_5625011', in 2ms, prepare: 0ms, lock: 0ms, execute: 2ms. ____________________
RedQueryTask<Job@10.96.119.93_5625011,__none__/__none__,10.96.119.93>{executed: 20, pending: 5[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb, more...]}]
[2022-03-11 11:06:29.054] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GRedTask.add(GRedTask.java:323)] |-[Host '10.96.119.93' executed REDUCE task on '[采购大屏-市场行情及平均采购价/F_202006.3e0b934f1ca.zb]', for job key: 'Job@10.96.119.93_5625011', in 3ms, prepare: 1ms, lock: 2ms, execute: 0ms. ____________________
RedQueryTask<Job@10.96.119.93_5625011,__none__/__none__,10.96.119.93>{executed: 21, pending: 4[采购大屏-市场行情及平均采购价/F_202004.3e0b934f1c8.zb,采购大屏-市场行情及平均采购价/F_202011.3e0b934f1d0.zb,采购大屏-市场行情及平均采购价/F_202110.3e0b934f1db.zb, more...]}]
[2022-03-11 11:06:29.054] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.dc.mr.GJob$JobCompleted.run0(GJob.java:519)] |-[Host '10.96.119.93' executed JOB 'JobCompleted@Thread[Thread-3441314,5,main]', for job key: 'Job@10.96.119.93_5625011', cost 2092ms.]
[2022-03-11 11:06:29.054] |-[INFO] |-[] |-[system] |-[g5.rpc.NettyClient$1.operationComplete(NettyClient.java:126)] |-[[Send ASync] success. channel is [id: 0xd6e06c2c, L:/10.96.119.93:35238 - R:/10.96.119.90:5083], proc is g5.dc.mr.c.UpdateTaskCProc@672d68c2(10.96.119.93->10.96.119.90)_0d8390aa, retry is 0, cost 0 ms]
[2022-03-11 11:06:29.054] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.gqry.GQuery.getPreGrid(GQuery.java:1489)] |-[g5.gqry.MaterialGQuery@22f260b5 execute one query 'g5.qry.cloud.CloudQuery@44a99ee8', result 'null', detail 'false', hit cache 'false', size '0', occupied 2093ms. ]
[2022-03-11 11:06:29.055] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.gqry.GQuery.getPreGrid(GQuery.java:1491)] |-[=====the cache key==== g5.gqry.MaterialGQuery@22f260b5, dataCacheKey=采购大屏-市场行情及平均采购价@1646945704713^ver1646945704713_SEP_true^年月00包材颜色控制00false2'行情价'行情价00Sum0行情价BinaryNode[a:[BCol<料品名称>], b:瓦楞纸, op:=]BinaryNode[a:[BCol<date>], b:202003, op:>=]QCI:<4,,_MAX_ROWS_:200000>, where=null]
[2022-03-11 11:06:29.055] |-[INFO] |-[] |-[system] |-[g5.rpc.NettyClient$1.operationComplete(NettyClient.java:126)] |-[[Send ASync] success. channel is [id: 0xcd6c6c32, L:/10.96.119.93:35062 - R:/10.96.119.90:5083], proc is g5.rpc.c.QueryCProc@199109db(10.96.119.93->10.96.119.90)_18d079b3, retry is 0, cost 1 ms]
[2022-03-11 11:06:29.055] |-[WARN] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.gqry.GQuery.getGrid(GQuery.java:1124)] |-[Execute one query 'g5.gqry.MaterialGQuery@22f260b5' with error: 'null', occupied 2094ms. Related Dashboard: '采购驾驶舱20220311081105-135' Related Query: '市场行情及平均采购价' Related Element: '图表7' Run user: '15031771'
Caused by: g5.util.GRTException null]
g5.util.GRTException: null
at g5.gqry.MaterialGQuery.getPreGrid1(MaterialGQuery.java:420) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getPreGrid0(GQuery.java:1297) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getPreGrid(GQuery.java:1447) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getGrid(GQuery.java:1055) [product-20211208.jar:?]
at g5.gqry.exec.AExecutor.createBase(AExecutor.java:529) [product-20211208.jar:?]
at g5.gqry.exec.DirectExecutor.getGrid(DirectExecutor.java:35) [product-20211208.jar:?]
at g5.aqry.comp.DefBaseExecutor.getGrid(DefBaseExecutor.java:36) [product-20211208.jar:?]
at g5.aqry.AQuery.initGrid0(AQuery.java:699) [product-20211208.jar:?]
at g5.aqry.AQuery.initGrid(AQuery.java:615) [product-20211208.jar:?]
at g5.aqry.AQuery.getGrid0(AQuery.java:594) [product-20211208.jar:?]
at g5.aqry.AQuery.getGrid(AQuery.java:565) [product-20211208.jar:?]
at g5.aqry.CQuery.<init>(CQuery.java:84) [product-20211208.jar:?]
at g5.db.qry.ChartEQuery.getCurrentChartGrid(ChartEQuery.java:315) [product-20211208.jar:?]
at g5.db.qry.ChartEQuery.getData0(ChartEQuery.java:192) [product-20211208.jar:?]
at g5.db.qry.EQuery.getData(EQuery.java:328) [product-20211208.jar:?]
at g5.db.qry.EQuery.getData(EQuery.java:317) [product-20211208.jar:?]
at g5.db.RTDashboard.execData(RTDashboard.java:1627) [product-20211208.jar:?]
at g5.db.RTDashboard.execData(RTDashboard.java:1534) [product-20211208.jar:?]
at g5.db.impl.DBTool.execData(DBTool.java:3410) [product-20211208.jar:?]
at g5.db.impl.DBTool.executeElem(DBTool.java:3441) [product-20211208.jar:?]
at g5.sv.db.req.UpdateElemReq.process1(UpdateElemReq.java:94) [product-20211208.jar:?]
at g5.sv.db.req.UpdateElemReq.process0(UpdateElemReq.java:62) [product-20211208.jar:?]
at g5.sv.Req.process(Req.java:37) [product-20211208.jar:?]
at g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1049) [product-20211208.jar:?]
at g5.sv.db.DBProc.procReq(DBProc.java:982) [product-20211208.jar:?]
at g5.sv.db.DBProc.service(DBProc.java:112) [product-20211208.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:99) [product-20211208.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:420) [product-20211208.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at g5.sv.standardsso.AbstractTokenSSOFilter.doFilter(AbstractTokenSSOFilter.java:59) [product-20211208.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:123) [product-20211208.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at com.yonghongtech.filter.ParamFilter.doFilter(ParamFilter.java:73) [customer.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at com.yonghongtech.filter.DBTokenFilter.doFilter(DBTokenFilter.java:73) [customer.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.37]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.37]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.37]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.37]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.37]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote.jar:9.0.37]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.37]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.37]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.37]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.37]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.37]
at java.lang.Thread.run(Thread.java:834) [?:?]
[2022-03-11 11:06:29.056] |-[INFO] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.aqry.AQuery.getGrid(AQuery.java:571)] |-[Execute one AQuery 'g5.aqry.AQuery@598f5e8e', result 'null', occupied 2113ms.]
[2022-03-11 11:06:29.056] |-[WARN] |-[ef8cbdf908544bd8ae2f4f4850da2511] |-[15031771] |-[g5.db.RTDashboard.execData(RTDashboard.java:1657)] |-[null
[Related resource]: Dashboard: '采购驾驶舱' Element: '图表7' Query: '市场行情及平均采购价' Column: 'null']
g5.util.GRTException: null
at g5.gqry.MaterialGQuery.getPreGrid1(MaterialGQuery.java:420) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getPreGrid0(GQuery.java:1297) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getPreGrid(GQuery.java:1447) ~[product-20211208.jar:?]
at g5.gqry.GQuery.getGrid(GQuery.java:1055) ~[product-20211208.jar:?]
at g5.gqry.exec.AExecutor.createBase(AExecutor.java:529) ~[product-20211208.jar:?]
at g5.gqry.exec.DirectExecutor.getGrid(DirectExecutor.java:35) ~[product-20211208.jar:?]
at g5.aqry.comp.DefBaseExecutor.getGrid(DefBaseExecutor.java:36) ~[product-20211208.jar:?]
at g5.aqry.AQuery.initGrid0(AQuery.java:699) ~[product-20211208.jar:?]
at g5.aqry.AQuery.initGrid(AQuery.java:615) ~[product-20211208.jar:?]
at g5.aqry.AQuery.getGrid0(AQuery.java:594) ~[product-20211208.jar:?]
at g5.aqry.AQuery.getGrid(AQuery.java:565) ~[product-20211208.jar:?]
at g5.aqry.CQuery.<init>(CQuery.java:84) ~[product-20211208.jar:?]
at g5.db.qry.ChartEQuery.getCurrentChartGrid(ChartEQuery.java:315) ~[product-20211208.jar:?]
at g5.db.qry.ChartEQuery.getData0(ChartEQuery.java:192) ~[product-20211208.jar:?]
at g5.db.qry.EQuery.getData(EQuery.java:328) ~[product-20211208.jar:?]
at g5.db.qry.EQuery.getData(EQuery.java:317) ~[product-20211208.jar:?]
at g5.db.RTDashboard.execData(RTDashboard.java:1627) [product-20211208.jar:?]
at g5.db.RTDashboard.execData(RTDashboard.java:1534) [product-20211208.jar:?]
at g5.db.impl.DBTool.execData(DBTool.java:3410) [product-20211208.jar:?]
at g5.db.impl.DBTool.executeElem(DBTool.java:3441) [product-20211208.jar:?]
at g5.sv.db.req.UpdateElemReq.process1(UpdateElemReq.java:94) [product-20211208.jar:?]
at g5.sv.db.req.UpdateElemReq.process0(UpdateElemReq.java:62) [product-20211208.jar:?]
at g5.sv.Req.process(Req.java:37) [product-20211208.jar:?]
at g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1049) [product-20211208.jar:?]
at g5.sv.db.DBProc.procReq(DBProc.java:982) [product-20211208.jar:?]
at g5.sv.db.DBProc.service(DBProc.java:112) [product-20211208.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:99) [product-20211208.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:420) [product-20211208.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at g5.sv.standardsso.AbstractTokenSSOFilter.doFilter(AbstractTokenSSOFilter.java:59) [product-20211208.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:123) [product-20211208.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at com.yonghongtech.filter.ParamFilter.doFilter(ParamFilter.java:73) [customer.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at com.yonghongtech.filter.DBTokenFilter.doFilter(DBTokenFilter.java:73) [customer.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.37]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.37]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.37]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.37]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.37]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.37]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote.jar:9.0.37]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.37]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.37]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.37]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.37]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.37]
at java.lang.Thread.run(Thread.java:834) [?:?]

作者: efrick 时间: 2022-3-11 13:04

永洪tech-Bella 发表于 2022-3-10 13:42
感谢您的反馈，我们已定位该问题已经修复过，建议您升级到90最新版本（9061），以及之后的长期维护版本。 ...

麻烦看一下这个报错是怎么产生的呢

作者: 永洪tech-Bella 时间: 2022-3-11 13:07

efrick 发表于 2022-3-11 13:04
麻烦看一下这个报错是怎么产生的呢

什么情况出现的这个报错呢？偶然还是必现呢。报错的时候，数据集正常吗？

作者: efrick 时间: 2022-3-11 15:27

永洪tech-Bella 发表于 2022-3-11 13:07
什么情况出现的这个报错呢？偶然还是必现呢。报错的时候，数据集正常吗？ ...

我们这个数据集是一个小时刷新一次，大屏展现10s刷新一次，不定时出现该报错因为10s刷新一次暂时还没确定报错出现时界面上组件是否有错误提示，刷新后就没有报错了但是错误消息不能隐藏。

作者: 永洪tech-Bella 时间: 2022-3-11 15:35

efrick 发表于 2022-3-11 15:27
我们这个数据集是一个小时刷新一次，大屏展现10s刷新一次，不定时出现该报错因为10s刷新一次暂时还没确 ...

目前日志太少，无法判断。可以确认下出现报错的时间，是否是入集市任务执行的时间，如果是，可能是旧的集市文件删除了，新的还未生成，导致查不到对应集市数据。可以提供报错这段时间所有节点的日志看下。（bi.log，集群节点情况，以及对应的任务名）
另外就是可以试下用增量入集市的方式替换直接同步，看下能否缓解这个问题

作者: efrick 时间: 2022-3-14 10:28

永洪tech-Bella 发表于 2022-3-11 15:35
目前日志太少，无法判断。可以确认下出现报错的时间，是否是入集市任务执行的时间，如果是，可能是旧的集 ...

报错时间并非任务运行时间任务运行结束时间为 11:04:34 报错为 11：06 任务运行方式为我们定开的增量导入方式。所有节点提供 11:00 - 11:10时间段 bi.log 可以吗

作者: efrick 时间: 2022-3-14 13:15
本帖最后由 efrick 于 2022-3-15 17:22 编辑

永洪tech-Bella 发表于 2022-3-11 15:35
目前日志太少，无法判断。可以确认下出现报错的时间，是否是入集市任务执行的时间，如果是，可能是旧的集 ...

日志如下

作者: 永洪tech-cc 时间: 2022-3-14 13:21
可以的，麻烦把任务名，报告名也发一下，谢谢！

作者: efrick 时间: 2022-3-14 13:48

永洪tech-cc 发表于 2022-3-14 13:21
可以的，麻烦把任务名，报告名也发一下，谢谢！

报告名称：采购驾驶舱调度任务名称：
1.全量入集市_大宗原物料缺口每小时整点过30s 同步一次调度方式：增量导入数据
2.自定义增量_市场行情及平均采购价每天04:55同步一次调度方式：定开增量导入通过时间控制

作者: efrick 时间: 2022-3-15 17:22

永洪tech-cc 发表于 2022-3-14 13:21
可以的，麻烦把任务名，报告名也发一下，谢谢！

您好，有发现问题点么

作者: 永洪tech-Lerry 时间: 2022-3-16 09:43

efrick 发表于 2022-3-15 17:22
您好，有发现问题点么

您好，这边正在帮您处理中，麻烦您稍微等下，能麻烦您提供一下您本地产品的jar包么，路径是产品安装目录/Yonghong/product/product.jar。

作者: efrick 时间: 2022-3-17 08:22

永洪tech-Lerry 发表于 2022-3-16 09:43
您好，这边正在帮您处理中，麻烦您稍微等下，能麻烦您提供一下您本地产品的jar包么，路径是产品安装目录/ ...

麻烦提供一下邮件地址呢

作者: yanieye 时间: 2022-3-17 09:20
如果数据集市的数据是每小时更新一下，大屏似乎没有必要每10秒刷新一次。
把大屏的刷新时间调整为每5分钟刷新一次看看？

作者: efrick 时间: 2022-3-17 09:32

yanieye 发表于 2022-3-17 09:20
如果数据集市的数据是每小时更新一下，大屏似乎没有必要每10秒刷新一次。
把大屏的刷新时间调整为每5分钟刷 ...

这个是刷新展现内容需求就是需要10s刷新呢。例如： A组件展现数据 a、b、c相关内容。每十秒展现其中一个值

作者: Yonghongtech-zx 时间: 2022-3-17 13:15
您好，这边正在分析日志，解决后给您答复。另外如果组件10s刷新是必要的，可以适当调整下入集市的更新时间，缩小两者之间的差距，看是否可以缓解。

作者: efrick 时间: 2022-3-17 14:22

Yonghongtech-zx 发表于 2022-3-17 13:15
您好，这边正在分析日志，解决后给您答复。另外如果组件10s刷新是必要的，可以适当调整下入集市的更新时间 ...

数据入集市要几分钟我们一个小时执行一次页面上是针对这1个小时内的数据进行10s刷新展现

作者: 永洪tech-Lerry 时间: 2022-3-17 16:07

efrick 发表于 2022-3-17 08:22
麻烦提供一下邮件地址呢

私信您邮箱了。

作者: efrick 时间: 2022-3-22 13:31

永洪tech-Lerry 发表于 2022-3-17 16:07
私信您邮箱了。

您好，有看到问题点么。或者 904上能修复 _WARNING2HINT_ _RESULT_NOT_EMPTY_这两个参数么

作者: 永洪tech-Lerry 时间: 2022-3-22 13:40

efrick 发表于 2022-3-22 13:31
您好，有看到问题点么。或者 904上能修复 _WARNING2HINT_ _RESULT_NOT_EMPTY_这两个参数么 ...

工程师正在本地分析中，预计需要一段时间，尽快给您答复。

作者: Fiona 时间: 2022-3-22 16:07
您好，这个问题需要在产品代码中jar trace，再次复现后拿日志再分析。
如果您购买了永洪的售后服务的话，请登录http://online.yonghongtech.com/index.php/Home/Index/login.html平台，提交工单，进行后续的track。谢谢！

作者: efrick 时间: 2022-3-23 08:23

Fiona 发表于 2022-3-22 16:07
您好，这个问题需要在产品代码中jar trace，再次复现后拿日志再分析。
如果您购买了永洪的售后服务的话，请 ...

jar trace 如何添加？

欢迎光临永洪社区 (https://club.yonghongtech.com/)