-
-
bigeye0517 小试身手Lv3
发表于2020-10-30 09:30
悬赏1
已解决
bigeye0517 发表于 2020-10-30 09:38
昨天还没有问题了,今天上午查看时就出问题了。
更换报表和统计图所在容器试试。
关贴总结:
检查表样设置,是由于两张数据表重叠导致。
9个回答
-
bigeye0517 小试身手Lv3
报警信息,如下,最后一行报警信息循环很多很多次
2020-10-30 09:20:40 开始计算报表:ICOS_MTBA_SHOW_monthly(内存情况:FREE=208.5M TOTAL=1.2G MAX=4.3G)
2020-10-30 09:20:40 引用的主题表: INSPECTION_MTBA, INSPECTION_ALARM
2020-10-30 09:20:40 查询的数据级次范围:没有做限制。
2020-10-30 09:20:40 001开始多表格各分析区并行计算
2020-10-30 09:20:40 [GRID7(0.0.2.2)]正在生成SQL...
2020-10-30 09:20:40 [GRID13(0.0.6.2)]正在生成SQL...
2020-10-30 09:20:40 [GRID7(0.0.2.2)]计算表格GRID7
2020-10-30 09:20:40 [GRID7(0.0.2.2)]生成SQL耗时3毫秒
2020-10-30 09:20:40 [GRID7(0.0.2.2)]当前连接池为【equipment_data】,执行SQL:
select top 1000 B2 as B2,A2 as A2,A2_sortn as A2_sortn
from (
select count(a.alarm) as B2,a.alarm as A2,row_number() over ( order by count(a.alarm) desc) as A2_sortn
from inspection_alarm a
where ((a.machine_no = 'BIS-12 ') AND (year(a.[time])=2020))
group by a.alarm) a
where (A2_sortn<=5)
order by A2_sortn
2020-10-30 09:20:40 [GRID13(0.0.6.2)]计算表格GRID13
2020-10-30 09:20:40 [GRID13(0.0.6.2)]生成SQL耗时4毫秒
2020-10-30 09:20:40 [GRID13(0.0.6.2)]当前连接池为【equipment_data】,执行SQL:
select top 1000 sum(year(a.[date])) as B2,sum(a.run_time) as C2,avg(a.utilization)*100 as E2,sum(a.alarm_count) as F2,a.machine_no as A2
from inspection_mtba a
where (year(a.[date])=2020)
group by a.machine_no
order by a.machine_no
2020-10-30 09:20:40 [GRID13(0.0.6.2)]SQL执行完毕,查询出16条数据,耗时:9毫秒(开始时间:2020-10-30 09:20:40.051;结束时间:2020-10-30 09:20:40.060);其中生成SQL耗时4毫秒;初始获取连接耗时:0毫秒;查询准备总耗时:2毫秒;执行查询sql耗时:3毫秒;
2020-10-30 09:20:40 [GRID7(0.0.2.2)]SQL执行完毕,查询出5条数据,耗时:15毫秒(开始时间:2020-10-30 09:20:40.051;结束时间:2020-10-30 09:20:40.066);其中生成SQL耗时3毫秒;初始获取连接耗时:0毫秒;查询准备总耗时:1毫秒;执行查询sql耗时:11毫秒;
2020-10-30 09:20:40 002完成多表格的所有分析区并行计算
java.lang.StackOverflowError
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportExpHelper.isVarCellNeedCalcInReport(FxBaseAnalyseReportExpHelper.java:381)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportExpHelper.getDouble(FxBaseAnalyseReportExpHelper.java:198)
at com.esen.util.exp.ExpVarImpl.toDouble(ExpVarImpl.java:56)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.getDouble(RectsInFxqResultImpl.java:331)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportExpHelper.getDouble(FxBaseAnalyseReportExpHelper.java:211)
at com.esen.util.exp.ExpVarImpl.toDouble(ExpVarImpl.java:56)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.getDouble(RectsInFxqResultImpl.java:331)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportExpHelper.getDouble(FxBaseAnalyseReportExpHelper.java:211)
at com.esen.util.exp.ExpVarImpl.toDouble(ExpVarImpl.java:56)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.getDouble(RectsInFxqResultImpl.java:331)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportExpHelper.getDouble(FxBaseAnalyseReportExpHelper.java:211)
at com.esen.util.exp.ExpVarImpl.toDouble(ExpVarImpl.java:56)
本帖最后由 xxxl 于 2020-10-30 10:19 编辑
bigeye0517 发表于 2020-10-30 09:38
昨天还没有问题了,今天上午查看时就出问题了。
更换报表和统计图所在容器试试。
关贴总结:
检查表样设置,是由于两张数据表重叠导致。


