-
wentong.li 数据达人Lv4
发表于2020-9-13 01:59
悬赏1
已解决
将分析表中的箭头放在容器中就不会有报错了。
感谢楼主分享
19个回答
wentong.li 发表于 2020-9-13 12:07
请问是怎么回事呢?
可以发一下详情嘛
-
wentong.li 数据达人Lv4
就爱喝奶茶 发表于 2020-9-13 13:09
你这个压缩包没有任何内容呢。建议你克隆一份分析表,一个一个表格删除来排查问题 ...
SQL
Q
Q
R
APP
APP
APP
提示
For input string: "0416564941406"
2020-09-13 13:12:42 开始计算报表:zjzb(内存情况:FREE=201.9M TOTAL=428M MAX=1.8G)
2020-09-13 13:12:42 引用的主题表: DW_SC_RW
2020-09-13 13:12:42 查询的数据级次范围:没有做限制。
2020-09-13 13:12:42 001开始多表格各分析区并行计算
2020-09-13 13:12:42 [GRID5(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID1(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID8(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID4(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID3(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID2(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID9(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID11(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID12(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID10(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID13(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID15(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID16(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID14(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID3(0.0.2.3)]计算表格GRID3
2020-09-13 13:12:42 [GRID3(0.0.2.3)]生成SQL耗时564毫秒
2020-09-13 13:12:42 [GRID13(0.0.2.3)]计算表格GRID13
2020-09-13 13:12:42 [GRID14(0.0.2.3)]计算表格GRID14
2020-09-13 13:12:42 [GRID13(0.0.2.3)]生成SQL耗时539毫秒
2020-09-13 13:12:42 [GRID14(0.0.2.3)]生成SQL耗时537毫秒
2020-09-13 13:12:42 [GRID10(0.0.2.3)]计算表格GRID10
2020-09-13 13:12:42 [GRID10(0.0.2.3)]生成SQL耗时549毫秒
2020-09-13 13:12:42 [GRID10(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '温度循环') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID3(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊手修')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID10(0.0.2.3)]SQL执行完毕,查询出1条数据,耗时:682毫秒(开始时间:2020-09-13 13:12:42.154;结束时间:2020-09-13 13:12:42.836);其中生成SQL耗时549毫秒;初始获取连接耗时:80毫秒;查询准备总耗时:81毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID13(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '精装') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID14(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '随机振动') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID3(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:703毫秒(开始时间:2020-09-13 13:12:42.136;结束时间:2020-09-13 13:12:42.839);其中生成SQL耗时564毫秒;初始获取连接耗时:5毫秒;查询准备总耗时:136毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID14(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:676毫秒(开始时间:2020-09-13 13:12:42.164;结束时间:2020-09-13 13:12:42.840);其中生成SQL耗时537毫秒;初始获取连接耗时:5毫秒;查询准备总耗时:137毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID13(0.0.2.3)]SQL执行完毕,查询出1条数据,耗时:679毫秒(开始时间:2020-09-13 13:12:42.162;结束时间:2020-09-13 13:12:42.841);其中生成SQL耗时539毫秒;初始获取连接耗时:135毫秒;查询准备总耗时:137毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID1(0.0.2.3)]计算表格GRID1
2020-09-13 13:12:42 [GRID16(0.0.2.3)]计算表格GRID16
2020-09-13 13:12:42 [GRID1(0.0.2.3)]生成SQL耗时713毫秒
2020-09-13 13:12:42 [GRID16(0.0.2.3)]生成SQL耗时683毫秒
2020-09-13 13:12:42 [GRID15(0.0.2.3)]计算表格GRID15
2020-09-13 13:12:42 [GRID15(0.0.2.3)]生成SQL耗时685毫秒
2020-09-13 13:12:42 [GRID15(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '老炼') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID16(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.SC = '交付验收') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID1(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID16(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:689毫秒(开始时间:2020-09-13 13:12:42.164;结束时间:2020-09-13 13:12:42.853);其中生成SQL耗时683毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID15(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:692毫秒(开始时间:2020-09-13 13:12:42.162;结束时间:2020-09-13 13:12:42.854);其中生成SQL耗时685毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID1(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:721毫秒(开始时间:2020-09-13 13:12:42.134;结束时间:2020-09-13 13:12:42.855);其中生成SQL耗时713毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID11(0.0.2.3)]计算表格GRID11
2020-09-13 13:12:42 [GRID11(0.0.2.3)]生成SQL耗时703毫秒
2020-09-13 13:12:42 [GRID11(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '无线') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID11(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:707毫秒(开始时间:2020-09-13 13:12:42.153;结束时间:2020-09-13 13:12:42.860);其中生成SQL耗时703毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID8(0.0.2.3)]计算表格GRID8
2020-09-13 13:12:42 [GRID8(0.0.2.3)]生成SQL耗时727毫秒
2020-09-13 13:12:42 [GRID9(0.0.2.3)]计算表格GRID9
2020-09-13 13:12:42 [GRID9(0.0.2.3)]生成SQL耗时713毫秒
2020-09-13 13:12:42 [GRID8(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '温冲') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID2(0.0.2.3)]计算表格GRID2
2020-09-13 13:12:42 [GRID2(0.0.2.3)]生成SQL耗时729毫秒
2020-09-13 13:12:42 [GRID9(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '常温调试') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID8(0.0.2.3)]SQL执行完毕,查询出2条数据,耗时:732毫秒(开始时间:2020-09-13 13:12:42.135;结束时间:2020-09-13 13:12:42.867);其中生成SQL耗时727毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID9(0.0.2.3)]SQL执行完毕,查询出3条数据,耗时:718毫秒(开始时间:2020-09-13 13:12:42.151;结束时间:2020-09-13 13:12:42.869);其中生成SQL耗时713毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]计算表格GRID5
2020-09-13 13:12:42 [GRID5(0.0.2.3)]生成SQL耗时736毫秒
2020-09-13 13:12:42 [GRID4(0.0.2.3)]计算表格GRID4
2020-09-13 13:12:42 [GRID4(0.0.2.3)]生成SQL耗时735毫秒
2020-09-13 13:12:42 [GRID2(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.SC as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊交检')
group by a.ZJ,a.SC
order by a.ZJ nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID2(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:735毫秒(开始时间:2020-09-13 13:12:42.137;结束时间:2020-09-13 13:12:42.872);其中生成SQL耗时729毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '手工焊')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID4(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '交调试')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID4(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:741毫秒(开始时间:2020-09-13 13:12:42.135;结束时间:2020-09-13 13:12:42.876);其中生成SQL耗时735毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:742毫秒(开始时间:2020-09-13 13:12:42.134;结束时间:2020-09-13 13:12:42.876);其中生成SQL耗时736毫秒;初始获取连接耗时:0毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID12(0.0.2.3)]计算表格GRID12
2020-09-13 13:12:42 [GRID12(0.0.2.3)]生成SQL耗时736毫秒
2020-09-13 13:12:42 [GRID12(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '有机粘接') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID12(0.0.2.3)]SQL执行完毕,查询出2条数据,耗时:742毫秒(开始时间:2020-09-13 13:12:42.153;结束时间:2020-09-13 13:12:42.895);其中生成SQL耗时736毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:4毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 002完成多表格的所有分析区并行计算
2020-09-13 13:12:42 执行查询耗时850毫秒。(内存情况:FREE=163.9M TOTAL=428M MAX=1.8G)
java.lang.NumberFormatException: For input string: "0416564941406"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.parseInt(Integer.java:615)
at com.esen.ebibase.rptbase.widget.WidgetGraphLine.getPoints(WidgetGraphLine.java:50)
at com.esen.ebibase.rptbase.widget.WidgetGraphLine.sizeChange(WidgetGraphLine.java:151)
at com.esen.ebibase.rptbase.widget.WidgetObject.setTop(WidgetObject.java:806)
at com.esen.ebibase.rptbase.widget.WidgetObject.setTop(WidgetObject.java:810)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.autoMoveWidget(WidgetContainerAdjust.java:254)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjustWidgetsByOrgWidget(WidgetContainerAdjust.java:178)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjustChildWidgets(WidgetContainerAdjust.java:157)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:87)
at com.esen.ebibase.rptbase.widget.WidgetContainer.adjust(WidgetContainer.java:134)
at com.esen.ebibase.rptbase.widget.WidgetLayout.adjust(WidgetLayout.java:523)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.init(WidgetContainerAdjust.java:284)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:85)
at com.esen.ebibase.rptbase.widget.WidgetContainer.adjust(WidgetContainer.java:134)
at com.esen.ebibase.rptbase.widget.WidgetPageLayout.adjust(WidgetPageLayout.java:253)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.init(WidgetContainerAdjust.java:284)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:85)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.adjust(RptTplBuilder.java:913)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.build(RptTplBuilder.java:212)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.ensureReportBuilt(RptTplBuilder.java:1704)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.getReport(RptTplBuilder.java:1714)
at com.esen.ebibase.rptbase.calc.impl.ReportCalcResultAbsImpl.getResultObject(ReportCalcResultAbsImpl.java:143)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc_makeAnaObjResult(ReportCalc_calc_abs.java:304)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc(ReportCalc_calc_abs.java:137)
at com.esen.ebibase.req.RequestTask_Calc.calc(RequestTask_Calc.java:98)
at com.esen.ebibase.req.RequestTask_Calc.innerRun(RequestTask_Calc.java:66)
at com.esen.ebibase.req.RequestTask_Calc_Abstract.doRun(RequestTask_Calc_Abstract.java:59)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:86)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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)
页面地址为:【/abi/ebibase/js/reqmgr.do?action=calc;rptid=EANA$2$2$1$029e5acaa95748f68a9715752d7aabe9$421a3ade66414f1d84cf95a4aa7c6269.rpttpl】
JavaScript StackTrace:
Error: For input string: "0416564941406"
--detailmessage--
2020-09-13 13:12:42 开始计算报表:zjzb(内存情况:FREE=201.9M TOTAL=428M MAX=1.8G)
2020-09-13 13:12:42 引用的主题表: DW_SC_RW
2020-09-13 13:12:42 查询的数据级次范围:没有做限制。
2020-09-13 13:12:42 001开始多表格各分析区并行计算
2020-09-13 13:12:42 [GRID5(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID1(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID8(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID4(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID3(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID2(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID9(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID11(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID12(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID10(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID13(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID15(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID16(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID14(0.0.2.3)]正在生成SQL...
2020-09-13 13:12:42 [GRID3(0.0.2.3)]计算表格GRID3
2020-09-13 13:12:42 [GRID3(0.0.2.3)]生成SQL耗时564毫秒
2020-09-13 13:12:42 [GRID13(0.0.2.3)]计算表格GRID13
2020-09-13 13:12:42 [GRID14(0.0.2.3)]计算表格GRID14
2020-09-13 13:12:42 [GRID13(0.0.2.3)]生成SQL耗时539毫秒
2020-09-13 13:12:42 [GRID14(0.0.2.3)]生成SQL耗时537毫秒
2020-09-13 13:12:42 [GRID10(0.0.2.3)]计算表格GRID10
2020-09-13 13:12:42 [GRID10(0.0.2.3)]生成SQL耗时549毫秒
2020-09-13 13:12:42 [GRID10(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '温度循环') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID3(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊手修')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID10(0.0.2.3)]SQL执行完毕,查询出1条数据,耗时:682毫秒(开始时间:2020-09-13 13:12:42.154;结束时间:2020-09-13 13:12:42.836);其中生成SQL耗时549毫秒;初始获取连接耗时:80毫秒;查询准备总耗时:81毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID13(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '精装') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID14(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '随机振动') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID3(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:703毫秒(开始时间:2020-09-13 13:12:42.136;结束时间:2020-09-13 13:12:42.839);其中生成SQL耗时564毫秒;初始获取连接耗时:5毫秒;查询准备总耗时:136毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID14(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:676毫秒(开始时间:2020-09-13 13:12:42.164;结束时间:2020-09-13 13:12:42.840);其中生成SQL耗时537毫秒;初始获取连接耗时:5毫秒;查询准备总耗时:137毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID13(0.0.2.3)]SQL执行完毕,查询出1条数据,耗时:679毫秒(开始时间:2020-09-13 13:12:42.162;结束时间:2020-09-13 13:12:42.841);其中生成SQL耗时539毫秒;初始获取连接耗时:135毫秒;查询准备总耗时:137毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID1(0.0.2.3)]计算表格GRID1
2020-09-13 13:12:42 [GRID16(0.0.2.3)]计算表格GRID16
2020-09-13 13:12:42 [GRID1(0.0.2.3)]生成SQL耗时713毫秒
2020-09-13 13:12:42 [GRID16(0.0.2.3)]生成SQL耗时683毫秒
2020-09-13 13:12:42 [GRID15(0.0.2.3)]计算表格GRID15
2020-09-13 13:12:42 [GRID15(0.0.2.3)]生成SQL耗时685毫秒
2020-09-13 13:12:42 [GRID15(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '老炼') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID16(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.SC = '交付验收') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID1(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID16(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:689毫秒(开始时间:2020-09-13 13:12:42.164;结束时间:2020-09-13 13:12:42.853);其中生成SQL耗时683毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID15(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:692毫秒(开始时间:2020-09-13 13:12:42.162;结束时间:2020-09-13 13:12:42.854);其中生成SQL耗时685毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID1(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:721毫秒(开始时间:2020-09-13 13:12:42.134;结束时间:2020-09-13 13:12:42.855);其中生成SQL耗时713毫秒;初始获取连接耗时:3毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID11(0.0.2.3)]计算表格GRID11
2020-09-13 13:12:42 [GRID11(0.0.2.3)]生成SQL耗时703毫秒
2020-09-13 13:12:42 [GRID11(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '无线') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID11(0.0.2.3)]SQL执行完毕,查询出0条数据,耗时:707毫秒(开始时间:2020-09-13 13:12:42.153;结束时间:2020-09-13 13:12:42.860);其中生成SQL耗时703毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID8(0.0.2.3)]计算表格GRID8
2020-09-13 13:12:42 [GRID8(0.0.2.3)]生成SQL耗时727毫秒
2020-09-13 13:12:42 [GRID9(0.0.2.3)]计算表格GRID9
2020-09-13 13:12:42 [GRID9(0.0.2.3)]生成SQL耗时713毫秒
2020-09-13 13:12:42 [GRID8(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '温冲') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID2(0.0.2.3)]计算表格GRID2
2020-09-13 13:12:42 [GRID2(0.0.2.3)]生成SQL耗时729毫秒
2020-09-13 13:12:42 [GRID9(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '常温调试') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID8(0.0.2.3)]SQL执行完毕,查询出2条数据,耗时:732毫秒(开始时间:2020-09-13 13:12:42.135;结束时间:2020-09-13 13:12:42.867);其中生成SQL耗时727毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID9(0.0.2.3)]SQL执行完毕,查询出3条数据,耗时:718毫秒(开始时间:2020-09-13 13:12:42.151;结束时间:2020-09-13 13:12:42.869);其中生成SQL耗时713毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]计算表格GRID5
2020-09-13 13:12:42 [GRID5(0.0.2.3)]生成SQL耗时736毫秒
2020-09-13 13:12:42 [GRID4(0.0.2.3)]计算表格GRID4
2020-09-13 13:12:42 [GRID4(0.0.2.3)]生成SQL耗时735毫秒
2020-09-13 13:12:42 [GRID2(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.SC as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊交检')
group by a.ZJ,a.SC
order by a.ZJ nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID2(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:735毫秒(开始时间:2020-09-13 13:12:42.137;结束时间:2020-09-13 13:12:42.872);其中生成SQL耗时729毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:5毫秒;执行查询sql耗时:1毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '手工焊')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID4(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.SC) as B1,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '交调试')
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
group by a.ZJ) b
where ((a.A1=b.A1)) )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID4(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:741毫秒(开始时间:2020-09-13 13:12:42.135;结束时间:2020-09-13 13:12:42.876);其中生成SQL耗时735毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID5(0.0.2.3)]SQL执行完毕,查询出5条数据,耗时:742毫秒(开始时间:2020-09-13 13:12:42.134;结束时间:2020-09-13 13:12:42.876);其中生成SQL耗时736毫秒;初始获取连接耗时:0毫秒;查询准备总耗时:3毫秒;执行查询sql耗时:3毫秒;
2020-09-13 13:12:42 [GRID12(0.0.2.3)]计算表格GRID12
2020-09-13 13:12:42 [GRID12(0.0.2.3)]生成SQL耗时736毫秒
2020-09-13 13:12:42 [GRID12(0.0.2.3)]当前连接池为【dw】,执行SQL:
select row_.*,rownum from ( select a.B1 as B1,b.B2 as B2,b.B3 as B3,a.A1 as A1
from (
select MAX(a.TS) as B1,a.ZJ as A1
from DW_SC_RW a
where ((a.TS = '有机粘接') AND (a.SC = '回流焊'))
group by a.ZJ) a
,(
select sum(a.JHZ) as B2,sum(a.WCZ) as B3,a.ZJ as A1
from DW_SC_RW a
where (a.SC = '回流焊')
group by a.ZJ) b
where ((a.A1=b.A1))
order by a.A1 nulls first )row_ where rownum <= 1000
2020-09-13 13:12:42 [GRID12(0.0.2.3)]SQL执行完毕,查询出2条数据,耗时:742毫秒(开始时间:2020-09-13 13:12:42.153;结束时间:2020-09-13 13:12:42.895);其中生成SQL耗时736毫秒;初始获取连接耗时:1毫秒;查询准备总耗时:4毫秒;执行查询sql耗时:2毫秒;
2020-09-13 13:12:42 002完成多表格的所有分析区并行计算
2020-09-13 13:12:42 执行查询耗时850毫秒。(内存情况:FREE=163.9M TOTAL=428M MAX=1.8G)
java.lang.NumberFormatException: For input string: "0416564941406"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.parseInt(Integer.java:615)
at com.esen.ebibase.rptbase.widget.WidgetGraphLine.getPoints(WidgetGraphLine.java:50)
at com.esen.ebibase.rptbase.widget.WidgetGraphLine.sizeChange(WidgetGraphLine.java:151)
at com.esen.ebibase.rptbase.widget.WidgetObject.setTop(WidgetObject.java:806)
at com.esen.ebibase.rptbase.widget.WidgetObject.setTop(WidgetObject.java:810)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.autoMoveWidget(WidgetContainerAdjust.java:254)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjustWidgetsByOrgWidget(WidgetContainerAdjust.java:178)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjustChildWidgets(WidgetContainerAdjust.java:157)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:87)
at com.esen.ebibase.rptbase.widget.WidgetContainer.adjust(WidgetContainer.java:134)
at com.esen.ebibase.rptbase.widget.WidgetLayout.adjust(WidgetLayout.java:523)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.init(WidgetContainerAdjust.java:284)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:85)
at com.esen.ebibase.rptbase.widget.WidgetContainer.adjust(WidgetContainer.java:134)
at com.esen.ebibase.rptbase.widget.WidgetPageLayout.adjust(WidgetPageLayout.java:253)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.init(WidgetContainerAdjust.java:284)
at com.esen.ebibase.npf.impl.WidgetContainerAdjust.adjust(WidgetContainerAdjust.java:85)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.adjust(RptTplBuilder.java:913)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.build(RptTplBuilder.java:212)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.ensureReportBuilt(RptTplBuilder.java:1704)
at com.esen.ebibase.rpttpl.analyse.RptTplBuilder.getReport(RptTplBuilder.java:1714)
at com.esen.ebibase.rptbase.calc.impl.ReportCalcResultAbsImpl.getResultObject(ReportCalcResultAbsImpl.java:143)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc_makeAnaObjResult(ReportCalc_calc_abs.java:304)
at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc(ReportCalc_calc_abs.java:137)
at com.esen.ebibase.req.RequestTask_Calc.calc(RequestTask_Calc.java:98)
at com.esen.ebibase.req.RequestTask_Calc.innerRun(RequestTask_Calc.java:66)
at com.esen.ebibase.req.RequestTask_Calc_Abstract.doRun(RequestTask_Calc_Abstract.java:59)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:86)
at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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)
页面地址为:【/abi/ebibase/js/reqmgr.do?action=calc;rptid=EANA$2$2$1$029e5acaa95748f68a9715752d7aabe9$421a3ade66414f1d84cf95a4aa7c6269.rpttpl】
at Object.throwError (http://localhost:8080/abi/eui/eui.js:2598:19)
at CalcReqTask.AbstractReqObj.onqueryobjfinish (http://localhost:8080/abi/eui/core/objs.js:1:37325)
at QueryObj._AbstractReqObj_onQueryFinish (http://localhost:8080/abi/eui/core/objs.js:1:38297)
at QueryObj._onreadystatechange (http://localhost:8080/abi/eui/core/ajax.js:1:2888)
at XMLHttpRequest.hp.onreadystatechange (http://localhost:8080/abi/eui/core/ajax.js:1:3419)
wentong.li 发表于 2020-9-14 09:53
附件为表样
看报错详情是GRID12可能有问题,建议一个个拿出来单独计算排查一下
-
wentong.li 数据达人Lv4
表样