-
-
LaSeineJ 数据达人Lv4
发表于2021-3-11 19:23
悬赏1
已解决
楼主
ROUND((TQXSTJ.TQQCJZDJSL
-
TQXSTJ.TQQCJZDJSLTB)
*
100
/
TQXSTJ.TQQCJZDJSLTB,2)这个表达式在取值的时候，
TQXSTJ.TQQCJZDJSLTB出现为0的情况，就直接报错
有什么办法可以解决这个问题吗，19:22:41 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:41 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:41 查询的数据级次范围：没有做限制。
2021-03-11 19:22:41 001开始多表格各分析区并行计算
2021-03-11 19:22:41 [GRID8(0.0.4.2)]正在生成SQL...
2021-03-11 19:22:41 [GRID8(0.0.4.2)]计算表格GRID8
2021-03-11 19:22:41 [GRID8(0.0.4.2)]生成SQL耗时4毫秒
2021-03-11 19:22:41 [GRID8(0.0.4.2)]当前连接池为【dmdb】，执行SQL:
select * from ( select MAX(a.ZJDL) as C2,MAX(a.QDCCDL) as D2,a.ZZJGBM as B2,a.SJSJ as A2,max(b.DIM_NAME) as mc_B20
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND ( LENGTH(a.ZZJGBM) = 4))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
2021-03-11 19:22:41 [GRID8(0.0.4.2)]SQL执行完毕，查询出11条数据，耗时：16毫秒（开始时间：2021-03-11 19:22:41.908；结束时间：2021-03-11 19:22:41.924）；其中生成SQL耗时4毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：8毫秒；
2021-03-11 19:22:41 002完成多表格的所有分析区并行计算
2021-03-11 19:22:41 执行查询耗时36毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:41 构造结果表耗时48毫秒。
2021-03-11 19:22:41 计算“TQXS-V5”耗时84毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID73(0.0.4.3)]正在生成SQL...
2021-03-11 19:22:42 [GRID73(0.0.4.3)]计算表格GRID73
2021-03-11 19:22:42 [GRID73(0.0.4.3)]生成SQL耗时6毫秒
2021-03-11 19:22:42 [GRID73(0.0.4.3)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQKJYCL) as C2,sum( ROUND(((a.TQQKJYCL-a.TQQKJYCLTB)*100)/a.TQQKJYCLTB,2)) as C3,sum( ROUND(((a.TQQKJYCL-a.TQQKJYCLHB)*100)/a.TQQKJYCLHB,2)) as D3,a.ZZJGBM as B1,a.SJSJ as A1,max(b.DIM_NAME) as mc_B10
from F_JK_JLZB_TQXSTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where ((a.ZZJGBM = '06') AND ((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID73(0.0.4.3)]SQL执行完毕，查询出1条数据，耗时：15毫秒（开始时间：2021-03-11 19:22:42.060；结束时间：2021-03-11 19:22:42.075）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：6毫秒；
2021-03-11 19:22:42 002完成多表格的所有分析区并行计算
2021-03-11 19:22:42 执行查询耗时25毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 构造结果表耗时48毫秒。
2021-03-11 19:22:42 计算“TQXS-V5”耗时73毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID83(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID84(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID53(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID49(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID49(0.0.4.4)]计算表格GRID49
2021-03-11 19:22:42 [GRID49(0.0.4.4)]生成SQL耗时8毫秒
2021-03-11 19:22:42 [GRID84(0.0.4.4)]计算表格GRID84
2021-03-11 19:22:42 [GRID84(0.0.4.4)]生成SQL耗时10毫秒
2021-03-11 19:22:42 [GRID53(0.0.4.4)]计算表格GRID53
2021-03-11 19:22:42 [GRID53(0.0.4.4)]生成SQL耗时10毫秒
2021-03-11 19:22:42 [GRID83(0.0.4.4)]计算表格GRID83
2021-03-11 19:22:42 [GRID83(0.0.4.4)]生成SQL耗时11毫秒
2021-03-11 19:22:42 [GRID49(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQFQCJ_GC_CJYCZCS) as D2,sum(a.TQFQCJ_GC_SJYCZCS) as D3,sum(a.TQFQCJ_GC_DAYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID84(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select MAX(a.TQQCJ_GC_CJYCZCS) as D2,MAX(a.TQQCJ_GC_DAYCZCS) as D3,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID53(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQFQCJ_GR_CJYCZCS) as D2,sum(a.TQFQCJ_GR_SJYCZCS) as D3,sum(a.TQFQCJ_GR_DAYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID83(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQCJ_GR_CJYCZCS) as D2,sum(a.TQQCJ_GR_DAYCZCS) as D3,sum(a.TQQCJ_GR_YXYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID49(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：17毫秒（开始时间：2021-03-11 19:22:42.205；结束时间：2021-03-11 19:22:42.222）；其中生成SQL耗时8毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：5毫秒；
2021-03-11 19:22:42 [GRID53(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：19毫秒（开始时间：2021-03-11 19:22:42.205；结束时间：2021-03-11 19:22:42.224）；其中生成SQL耗时10毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：7毫秒；
2021-03-11 19:22:42 [GRID84(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：20毫秒（开始时间：2021-03-11 19:22:42.204；结束时间：2021-03-11 19:22:42.224）；其中生成SQL耗时10毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：7毫秒；
2021-03-11 19:22:42 [GRID83(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：21毫秒（开始时间：2021-03-11 19:22:42.204；结束时间：2021-03-11 19:22:42.225）；其中生成SQL耗时11毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：6毫秒；
2021-03-11 19:22:42 002完成多表格的所有分析区并行计算
2021-03-11 19:22:42 执行查询耗时38毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 构造结果表耗时51毫秒。
2021-03-11 19:22:42 计算“TQXS-V5”耗时89毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID71(0.0.4.3)]正在生成SQL...
2021-03-11 19:22:42 [GRID71(0.0.4.3)]计算表格GRID71
2021-03-11 19:22:42 [GRID71(0.0.4.3)]生成SQL耗时5毫秒
2021-03-11 19:22:42 [GRID71(0.0.4.3)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQCJXSYCL*100) as C2,sum( ROUND(((a.TQQCJXSYCL-a.TQQCJXSYCLTB)*100)/a.TQQCJXSYCLTB,2)) as C3,sum( ROUND(((a.TQQCJXSYCL-a.TQQCJXSYCLHB)*100)/a.TQQCJXSYCLHB,2)) as D3,a.ZZJGBM as B1,a.SJSJ as A1,max(b.DIM_NAME) as mc_B10
from F_JK_JLZB_TQXSTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where ((a.ZZJGBM = '06') AND ((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
java.lang.RuntimeException: 计算浮动表元 GRID71->A1 (TQXSTJ.SJSJ)时出错：Divide zero
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:41)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2411)
at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:608)
at dm.jdbc.driver.DmdbCSI.prepareSQL(DmdbCSI.java:323)
at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1716)
at dm.jdbc.driver.DmdbStatement_bs.executeInner(DmdbStatement_bs.java:2024)
at dm.jdbc.driver.DmdbStatement_bs.executeQuery(DmdbStatement_bs.java:333)
at dm.jdbc.driver.DmdbStatement.executeQuery(DmdbStatement.java:123)
at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
at com.esen.jdbc.pool.PooledStatement.executeQuery(PooledStatement.java:44)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.queryData(OlapResultMultImpl.java:439)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.doit(OlapResultMultImpl.java:251)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.<init>(OlapResultMultImpl.java:117)
at com.esen.ebibase.rptbase.calc.db.top.CalcOlapResult.calcGroupOlap(CalcOlapResult.java:78)
at com.esen.ebibase.rptbase.calc.impl.GroupOlapEngine.calc(GroupOlapEngine.java:35)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.calcOlap(OLTPResultManager.java:609)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpResult(OLTPResultManager.java:598)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData4AutoOlap(OLTPResultManager.java:156)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData(OLTPResultManager.java:89)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportCalc.getOltpData(FxBaseAnalyseReportCalc.java:507)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.getOltpData(FloatFxqCalc.java:251)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.getOltpData(FloatFxqInnerCalc.java:79)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1173)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1144)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group_A_ds(FloatFxqInnerCalc.java:961)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group(FloatFxqInnerCalc.java:936)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata(FloatFxqInnerCalc.java:907)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_oltp(FloatFxqInnerCalc.java:840)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float(FloatFxqInnerCalc.java:792)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult(FloatFxqInnerCalc.java:148)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.calc(FloatFxqInnerCalc.java:58)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:247)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatRectInFxqResultImpl.processResult(FloatRectInFxqResultImpl.java:56)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.processResult(RectsInFxqResultImpl.java:103)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqResultImpl.processResult(FloatFxqResultImpl.java:112)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:83)
at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)
at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:107)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
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)
Caused by: java.lang.RuntimeException: Divide zero
... 45 more
Caused by: com.esen.jdbc.pool.impl.dm.DMPooledSQLException: Divide zero
... 45 more
页面地址为：【<a errurl=true>/ABI/ebibase/js/reqmgr.do?grid64_startindex=0.0;grid74_startindex=0.0;@p1874=;grid106_pagesize=1000;grid5_pagesize=1000;@p1519=;grid105_startindex=0.0;__t__=1615461697821;@p7179=;grid84_startindex=0.0;taskid=d4c9227ccca24e12a0bbf840ec9cca8c;grid142_pagesize=1000;@p1744=;grid116_pagesize=1000;grid101_pagesize=1000;grid159_pagesize=1000;grid49_pagesize=1000;grid124_pagesize=1000;@p3923=;grid115_startindex=0.0;grid95_pagesize=1000;grid125_startindex=0.0;grid145_startindex=0.0;grid129_pagesize=1000;grid126_pagesize=1000;grid132_pagesize=1000;grid83_pagesize=1000;grid160_pagesize=1000;grid120_startindex=0.0;grid100_startindex=0.0;grid110_startindex=0.0;grid160_startindex=0.0;@p2139=202103;grid104_pagesize=1000;grid130_startindex=0.0;grid162_pagesize=1000;grid83_startindex=0.0;grid73_startindex=0.0;grid70_pagesize=1000;grid63_startindex=0.0;grid121_pagesize=1000;grid8_pagesize=1000;grid53_startindex=0.0;grid97_pagesize=1000;@p4026=;@p3853=;grid109_pagesize=1000;grid122_pagesize=1000;@dateDay=;grid131_pagesize=1000;grid147_startindex=0.0;grid113_pagesize=1000;grid127_startindex=0.0;@p7405=;grid96_pagesize=1000;@p4139=;grid95_startindex=0.0;grid128_pagesize=1000;grid107_startindex=0.0;@p8971=;grid147_pagesize=1000;@p5221=;@p9149=;@p5466=;grid116_startindex=0.0;grid112_pagesize=1000;grid10_startindex=0.0;grid129_startindex=0.0;@p4926=;grid71_pagesize=1000;grid74_pagesize=1000;@p9935=;@p6426=;grid109_startindex=0.0;grid88_startindex=0.0;@p4242=;grid80_pagesize=1000;grid99_startindex=0.0;grid119_pagesize=1000;@p2975=;exttype=rpttpl;@p3703=;@p9243=;@p4472=;grid158_startindex=0.0;grid103_pagesize=1000;grid149_startindex=0.0;grid144_pagesize=1000;@p8392=;grid132_startindex=0.0;grid142_startindex=0.0;grid158_pagesize=1000;grid97_startindex=0.0;grid100_pagesize=1000;grid162_startindex=0.0;grid122_startindex=0.0;grid143_pagesize=1000;grid76_pagesize=1000;grid118_startindex=0.0;grid128_startindex=0.0;grid71_startindex=0.0;@p8423=;grid125_pagesize=1000;grid108_startindex=0.0;grid84_pagesize=1000;@p5269=;@p7689=;@p3526=;@p6593=;grid105_pagesize=1000;grid123_pagesize=1000;@p1574=;grid10_pagesize=1000;grid103_startindex=0.0;grid50_startindex=0.0;grid123_startindex=0.0;grid8_startindex=0.0;grid102_pagesize=1000;@p9970=;grid113_startindex=0.0;grid133_startindex=0.0;grid70_startindex=0.0;grid80_startindex=0.0;grid143_startindex=0.0;grid53_pagesize=1000;grid148_pagesize=1000;grid107_pagesize=1000;olddesignid=EANA$2$2$1$d4c9227ccca24e12a0bbf840ec9cca8c$0b5bf304fb684297acedf62cb95eaf31.rpttpl;grid110_pagesize=1000;grid145_pagesize=1000;_olddesignid_=EANA$2$2$1$d4c9227ccca24e12a0bbf840ec9cca8c$0b5bf304fb684297acedf62cb95eaf31.rpttpl;@p5809=;grid72_startindex=0.0;grid111_startindex=0.0;grid99_pagesize=1000;grid101_startindex=0.0;@p3745=;@p3625=;grid64_pagesize=1000;@p8870=;grid115_pagesize=1000;grid121_startindex=0.0;grid131_startindex=0.0;@p7663=;grid102_startindex=0.0;grid112_startindex=0.0;@p4666=;grid118_pagesize=1000;@p3218=;grid146_pagesize=1000;@p3219=;grid73_pagesize=1000;grid127_pagesize=1000;grid49_startindex=0.0;grid88_pagesize=1000;grid104_startindex=0.0;group=EANA$1$58aa3206547e4d02966d4a6eba3cf438;grid7_startindex=0.0;grid124_startindex=0.0;grid117_startindex=0.0;grid130_pagesize=1000;grid144_startindex=0.0;@ins=;grid5_startindex=0.0;grid117_pagesize=1000;grid96_startindex=0.0;grid76_startindex=0.0;grid72_pagesize=1000;@p1381=;grid106_startindex=0.0;grid159_startindex=0.0;grid119_startindex=0.0;grid126_startindex=0.0;grid111_pagesize=1000;grid120_pagesize=1000;grid146_startindex=0.0;grid98_startindex=0.0;grid50_pagesize=1000;@p6261=;grid7_pagesize=1000;@p2336=;@p1126=;@p1808=;@p4511=;grid133_pagesize=1000;grid108_pagesize=1000;grid148_startindex=0.0;@p6012=;@p4076=;@p6258=;grid63_pagesize=1000;@p6136=;grid149_pagesize=1000;@p2570=;@p7460=2021;grid98_pagesize=1000;@ins_s=;@ins_e=;HHH316=0;HHH563=0;HHH586=0;HHH430=0;action=drill;drillParams="drillType=7;customDimension=;drillCaption=;numblocks=;taskid=;srcrptid=EANA$2$2$2$d4c9227ccca24e12a0bbf840ec9cca8c$3d82c0ed30a448a9896c73138c5ea775.rpttpl;srccells=;drillToDetail=;drillToBbh=;drillLevel=;_olddesignid_=;_ignoreDrillPath=false;_ignoreSubExpand=true;_showposition=cellleft";bi_calc_dont_save_result=true;hiddencalcparams=true;drillWay=2;areaparams="HHH89#@dateStr=20210307&HHH9#@dateStr=20210307&HHH735#@dateStr=20210307&HHH324#@dateStr=20210307&HHH119#@dateStr=20210307&HHH120#@dateStr=20210307&HHH121#@dateStr=20210307&HHH5#@dateStr=20210307&HHH382#@dateStr=20210307&HHH381#@dateStr=20210307&HHH341#@dateStr=20210307&";comparams=;_srcrptid=EANA$2$2$2$d4c9227ccca24e12a0bbf840ec9cca8c$3d82c0ed30a448a9896c73138c5ea775.rpttpl;_srcgridid=WidgetParamDate54;_srccell=WidgetParamDate54</a>】
JavaScript StackTrace:
Error: 计算浮动表元 GRID71->A1 (TQXSTJ.SJSJ)时出错：Divide zero
--detailmessage--
2021-03-11 19:22:41 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:41 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:41 查询的数据级次范围：没有做限制。
2021-03-11 19:22:41 001开始多表格各分析区并行计算
2021-03-11 19:22:41 [GRID8(0.0.4.2)]正在生成SQL...
2021-03-11 19:22:41 [GRID8(0.0.4.2)]计算表格GRID8
2021-03-11 19:22:41 [GRID8(0.0.4.2)]生成SQL耗时4毫秒
2021-03-11 19:22:41 [GRID8(0.0.4.2)]当前连接池为【dmdb】，执行SQL:
select * from ( select MAX(a.ZJDL) as C2,MAX(a.QDCCDL) as D2,a.ZZJGBM as B2,a.SJSJ as A2,max(b.DIM_NAME) as mc_B20
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND ( LENGTH(a.ZZJGBM) = 4))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
2021-03-11 19:22:41 [GRID8(0.0.4.2)]SQL执行完毕，查询出11条数据，耗时：16毫秒（开始时间：2021-03-11 19:22:41.908；结束时间：2021-03-11 19:22:41.924）；其中生成SQL耗时4毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：8毫秒；
2021-03-11 19:22:41 002完成多表格的所有分析区并行计算
2021-03-11 19:22:41 执行查询耗时36毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:41 构造结果表耗时48毫秒。
2021-03-11 19:22:41 计算“TQXS-V5”耗时84毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID73(0.0.4.3)]正在生成SQL...
2021-03-11 19:22:42 [GRID73(0.0.4.3)]计算表格GRID73
2021-03-11 19:22:42 [GRID73(0.0.4.3)]生成SQL耗时6毫秒
2021-03-11 19:22:42 [GRID73(0.0.4.3)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQKJYCL) as C2,sum( ROUND(((a.TQQKJYCL-a.TQQKJYCLTB)*100)/a.TQQKJYCLTB,2)) as C3,sum( ROUND(((a.TQQKJYCL-a.TQQKJYCLHB)*100)/a.TQQKJYCLHB,2)) as D3,a.ZZJGBM as B1,a.SJSJ as A1,max(b.DIM_NAME) as mc_B10
from F_JK_JLZB_TQXSTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where ((a.ZZJGBM = '06') AND ((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID73(0.0.4.3)]SQL执行完毕，查询出1条数据，耗时：15毫秒（开始时间：2021-03-11 19:22:42.060；结束时间：2021-03-11 19:22:42.075）；其中生成SQL耗时6毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：6毫秒；
2021-03-11 19:22:42 002完成多表格的所有分析区并行计算
2021-03-11 19:22:42 执行查询耗时25毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 构造结果表耗时48毫秒。
2021-03-11 19:22:42 计算“TQXS-V5”耗时73毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID83(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID84(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID53(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID49(0.0.4.4)]正在生成SQL...
2021-03-11 19:22:42 [GRID49(0.0.4.4)]计算表格GRID49
2021-03-11 19:22:42 [GRID49(0.0.4.4)]生成SQL耗时8毫秒
2021-03-11 19:22:42 [GRID84(0.0.4.4)]计算表格GRID84
2021-03-11 19:22:42 [GRID84(0.0.4.4)]生成SQL耗时10毫秒
2021-03-11 19:22:42 [GRID53(0.0.4.4)]计算表格GRID53
2021-03-11 19:22:42 [GRID53(0.0.4.4)]生成SQL耗时10毫秒
2021-03-11 19:22:42 [GRID83(0.0.4.4)]计算表格GRID83
2021-03-11 19:22:42 [GRID83(0.0.4.4)]生成SQL耗时11毫秒
2021-03-11 19:22:42 [GRID49(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQFQCJ_GC_CJYCZCS) as D2,sum(a.TQFQCJ_GC_SJYCZCS) as D3,sum(a.TQFQCJ_GC_DAYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID84(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select MAX(a.TQQCJ_GC_CJYCZCS) as D2,MAX(a.TQQCJ_GC_DAYCZCS) as D3,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID53(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQFQCJ_GR_CJYCZCS) as D2,sum(a.TQFQCJ_GR_SJYCZCS) as D3,sum(a.TQFQCJ_GR_DAYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID83(0.0.4.4)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQCJ_GR_CJYCZCS) as D2,sum(a.TQQCJ_GR_DAYCZCS) as D3,sum(a.TQQCJ_GR_YXYCZCS) as D4,a.SJSJ as B1,a.ZZJGBM as A1,max(b.DIM_NAME) as mc_A11
from F_JK_JLZB_DQYCTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where (((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))) AND (a.ZZJGBM = '06'))
group by a.ZZJGBM,a.SJSJ ) as temp_ limit 1000
2021-03-11 19:22:42 [GRID49(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：17毫秒（开始时间：2021-03-11 19:22:42.205；结束时间：2021-03-11 19:22:42.222）；其中生成SQL耗时8毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：5毫秒；
2021-03-11 19:22:42 [GRID53(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：19毫秒（开始时间：2021-03-11 19:22:42.205；结束时间：2021-03-11 19:22:42.224）；其中生成SQL耗时10毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：7毫秒；
2021-03-11 19:22:42 [GRID84(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：20毫秒（开始时间：2021-03-11 19:22:42.204；结束时间：2021-03-11 19:22:42.224）；其中生成SQL耗时10毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：7毫秒；
2021-03-11 19:22:42 [GRID83(0.0.4.4)]SQL执行完毕，查询出1条数据，耗时：21毫秒（开始时间：2021-03-11 19:22:42.204；结束时间：2021-03-11 19:22:42.225）；其中生成SQL耗时11毫秒；初始获取连接耗时：1毫秒；查询准备总耗时：3毫秒；执行查询sql耗时：6毫秒；
2021-03-11 19:22:42 002完成多表格的所有分析区并行计算
2021-03-11 19:22:42 执行查询耗时38毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 构造结果表耗时51毫秒。
2021-03-11 19:22:42 计算“TQXS-V5”耗时89毫秒。（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 开始计算报表：TQXS-V5（内存情况：FREE=3.4G TOTAL=6.4G MAX=26.7G）
2021-03-11 19:22:42 引用的主题表： 自动覆盖率, 台区线损统计, JK_JLZB_DQYCTJ_R, PC_DQYCTJ, f_dim_qg_xzqh_day, dim_qg_xzqh, 自动抄表率, 台区线损分布统计, 自动抄表率1, 供电所经纬度
2021-03-11 19:22:42 查询的数据级次范围：没有做限制。
2021-03-11 19:22:42 001开始多表格各分析区并行计算
2021-03-11 19:22:42 [GRID71(0.0.4.3)]正在生成SQL...
2021-03-11 19:22:42 [GRID71(0.0.4.3)]计算表格GRID71
2021-03-11 19:22:42 [GRID71(0.0.4.3)]生成SQL耗时5毫秒
2021-03-11 19:22:42 [GRID71(0.0.4.3)]当前连接池为【dmdb】，执行SQL:
select * from ( select sum(a.TQQCJXSYCL*100) as C2,sum( ROUND(((a.TQQCJXSYCL-a.TQQCJXSYCLTB)*100)/a.TQQCJXSYCLTB,2)) as C3,sum( ROUND(((a.TQQCJXSYCL-a.TQQCJXSYCLHB)*100)/a.TQQCJXSYCLHB,2)) as D3,a.ZZJGBM as B1,a.SJSJ as A1,max(b.DIM_NAME) as mc_B10
from F_JK_JLZB_TQXSTJ_R a
left join v_tr_yx_gywd_gddw b
on (a.ZZJGBM=b.DIM_ID)
where ((a.ZZJGBM = '06') AND ((a.SJSJ>=to_date('20210307','YYYYMMDD') and a.SJSJ<to_date('20210308','YYYYMMDD'))))
group by a.SJSJ,a.ZZJGBM ) as temp_ limit 1000
java.lang.RuntimeException: 计算浮动表元 GRID71->A1 (TQXSTJ.SJSJ)时出错：Divide zero
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:41)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2411)
at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:608)
at dm.jdbc.driver.DmdbCSI.prepareSQL(DmdbCSI.java:323)
at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1716)
at dm.jdbc.driver.DmdbStatement_bs.executeInner(DmdbStatement_bs.java:2024)
at dm.jdbc.driver.DmdbStatement_bs.executeQuery(DmdbStatement_bs.java:333)
at dm.jdbc.driver.DmdbStatement.executeQuery(DmdbStatement.java:123)
at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
at com.esen.jdbc.pool.PooledStatement.executeQuery(PooledStatement.java:44)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.queryData(OlapResultMultImpl.java:439)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.doit(OlapResultMultImpl.java:251)
at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.<init>(OlapResultMultImpl.java:117)
at com.esen.ebibase.rptbase.calc.db.top.CalcOlapResult.calcGroupOlap(CalcOlapResult.java:78)
at com.esen.ebibase.rptbase.calc.impl.GroupOlapEngine.calc(GroupOlapEngine.java:35)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.calcOlap(OLTPResultManager.java:609)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpResult(OLTPResultManager.java:598)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData4AutoOlap(OLTPResultManager.java:156)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData(OLTPResultManager.java:89)
at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportCalc.getOltpData(FxBaseAnalyseReportCalc.java:507)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.getOltpData(FloatFxqCalc.java:251)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.getOltpData(FloatFxqInnerCalc.java:79)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1173)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1144)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group_A_ds(FloatFxqInnerCalc.java:961)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata_group(FloatFxqInnerCalc.java:936)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_autoolap_processdata(FloatFxqInnerCalc.java:907)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float_oltp(FloatFxqInnerCalc.java:840)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_float(FloatFxqInnerCalc.java:792)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult(FloatFxqInnerCalc.java:148)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.calc(FloatFxqInnerCalc.java:58)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:247)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatRectInFxqResultImpl.processResult(FloatRectInFxqResultImpl.java:56)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.processResult(RectsInFxqResultImpl.java:103)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqResultImpl.processResult(FloatFxqResultImpl.java:112)
at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:83)
at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)
at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:107)
at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
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)
Caused by: java.lang.RuntimeException: Divide zero
... 45 more
Caused by: com.esen.jdbc.pool.impl.dm.DMPooledSQLException: Divide zero
... 45 more
页面地址为：【<a errurl=true>/ABI/ebibase/js/reqmgr.do?grid64_startindex=0.0;grid74_startindex=0.0;@p1874=;grid106_pagesize=1000;grid5_pagesize=1000;@p1519=;grid105_startindex=0.0;__t__=1615461697821;@p7179=;grid84_startindex=0.0;taskid=d4c9227ccca24e12a0bbf840ec9cca8c;grid142_pagesize=1000;@p1744=;grid116_pagesize=1000;grid101_pagesize=1000;grid159_pagesize=1000;grid49_pagesize=1000;grid124_pagesize=1000;@p3923=;grid115_startindex=0.0;grid95_pagesize=1000;grid125_startindex=0.0;grid145_startindex=0.0;grid129_pagesize=1000;grid126_pagesize=1000;grid132_pagesize=1000;grid83_pagesize=1000;grid160_pagesize=1000;grid120_startindex=0.0;grid100_startindex=0.0;grid110_startindex=0.0;grid160_startindex=0.0;@p2139=202103;grid104_pagesize=1000;grid130_startindex=0.0;grid162_pagesize=1000;grid83_startindex=0.0;grid73_startindex=0.0;grid70_pagesize=1000;grid63_startindex=0.0;grid121_pagesize=1000;grid8_pagesize=1000;grid53_startindex=0.0;grid97_pagesize=1000;@p4026=;@p3853=;grid109_pagesize=1000;grid122_pagesize=1000;@dateDay=;grid131_pagesize=1000;grid147_startindex=0.0;grid113_pagesize=1000;grid127_startindex=0.0;@p7405=;grid96_pagesize=1000;@p4139=;grid95_startindex=0.0;grid128_pagesize=1000;grid107_startindex=0.0;@p8971=;grid147_pagesize=1000;@p5221=;@p9149=;@p5466=;grid116_startindex=0.0;grid112_pagesize=1000;grid10_startindex=0.0;grid129_startindex=0.0;@p4926=;grid71_pagesize=1000;grid74_pagesize=1000;@p9935=;@p6426=;grid109_startindex=0.0;grid88_startindex=0.0;@p4242=;grid80_pagesize=1000;grid99_startindex=0.0;grid119_pagesize=1000;@p2975=;exttype=rpttpl;@p3703=;@p9243=;@p4472=;grid158_startindex=0.0;grid103_pagesize=1000;grid149_startindex=0.0;grid144_pagesize=1000;@p8392=;grid132_startindex=0.0;grid142_startindex=0.0;grid158_pagesize=1000;grid97_startindex=0.0;grid100_pagesize=1000;grid162_startindex=0.0;grid122_startindex=0.0;grid143_pagesize=1000;grid76_pagesize=1000;grid118_startindex=0.0;grid128_startindex=0.0;grid71_startindex=0.0;@p8423=;grid125_pagesize=1000;grid108_startindex=0.0;grid84_pagesize=1000;@p5269=;@p7689=;@p3526=;@p6593=;grid105_pagesize=1000;grid123_pagesize=1000;@p1574=;grid10_pagesize=1000;grid103_startindex=0.0;grid50_startindex=0.0;grid123_startindex=0.0;grid8_startindex=0.0;grid102_pagesize=1000;@p9970=;grid113_startindex=0.0;grid133_startindex=0.0;grid70_startindex=0.0;grid80_startindex=0.0;grid143_startindex=0.0;grid53_pagesize=1000;grid148_pagesize=1000;grid107_pagesize=1000;olddesignid=EANA$2$2$1$d4c9227ccca24e12a0bbf840ec9cca8c$0b5bf304fb684297acedf62cb95eaf31.rpttpl;grid110_pagesize=1000;grid145_pagesize=1000;_olddesignid_=EANA$2$2$1$d4c9227ccca24e12a0bbf840ec9cca8c$0b5bf304fb684297acedf62cb95eaf31.rpttpl;@p5809=;grid72_startindex=0.0;grid111_startindex=0.0;grid99_pagesize=1000;grid101_startindex=0.0;@p3745=;@p3625=;grid64_pagesize=1000;@p8870=;grid115_pagesize=1000;grid121_startindex=0.0;grid131_startindex=0.0;@p7663=;grid102_startindex=0.0;grid112_startindex=0.0;@p4666=;grid118_pagesize=1000;@p3218=;grid146_pagesize=1000;@p3219=;grid73_pagesize=1000;grid127_pagesize=1000;grid49_startindex=0.0;grid88_pagesize=1000;grid104_startindex=0.0;group=EANA$1$58aa3206547e4d02966d4a6eba3cf438;grid7_startindex=0.0;grid124_startindex=0.0;grid117_startindex=0.0;grid130_pagesize=1000;grid144_startindex=0.0;@ins=;grid5_startindex=0.0;grid117_pagesize=1000;grid96_startindex=0.0;grid76_startindex=0.0;grid72_pagesize=1000;@p1381=;grid106_startindex=0.0;grid159_startindex=0.0;grid119_startindex=0.0;grid126_startindex=0.0;grid111_pagesize=1000;grid120_pagesize=1000;grid146_startindex=0.0;grid98_startindex=0.0;grid50_pagesize=1000;@p6261=;grid7_pagesize=1000;@p2336=;@p1126=;@p1808=;@p4511=;grid133_pagesize=1000;grid108_pagesize=1000;grid148_startindex=0.0;@p6012=;@p4076=;@p6258=;grid63_pagesize=1000;@p6136=;grid149_pagesize=1000;@p2570=;@p7460=2021;grid98_pagesize=1000;@ins_s=;@ins_e=;HHH316=0;HHH563=0;HHH586=0;HHH430=0;action=drill;drillParams="drillType=7;customDimension=;drillCaption=;numblocks=;taskid=;srcrptid=EANA$2$2$2$d4c9227ccca24e12a0bbf840ec9cca8c$3d82c0ed30a448a9896c73138c5ea775.rpttpl;srccells=;drillToDetail=;drillToBbh=;drillLevel=;_olddesignid_=;_ignoreDrillPath=false;_ignoreSubExpand=true;_showposition=cellleft";bi_calc_dont_save_result=true;hiddencalcparams=true;drillWay=2;areaparams="HHH89#@dateStr=20210307&HHH9#@dateStr=20210307&HHH735#@dateStr=20210307&HHH324#@dateStr=20210307&HHH119#@dateStr=20210307&HHH120#@dateStr=20210307&HHH121#@dateStr=20210307&HHH5#@dateStr=20210307&HHH382#@dateStr=20210307&HHH381#@dateStr=20210307&HHH341#@dateStr=20210307&";comparams=;_srcrptid=EANA$2$2$2$d4c9227ccca24e12a0bbf840ec9cca8c$3d82c0ed30a448a9896c73138c5ea775.rpttpl;_srcgridid=WidgetParamDate54;_srccell=WidgetParamDate54</a>】
at Object.throwError (http://192.168.1.202:8080/ABI/eui/eui.js:2628:19)
at CalcReqTask.AbstractReqObj.onqueryobjfinish (http://192.168.1.202:8080/ABI/eui/core/objs.js:1:37682)
at QueryObj._AbstractReqObj_onQueryFinish (http://192.168.1.202:8080/ABI/eui/core/objs.js:1:38671)
at QueryObj._onreadystatechange (http://192.168.1.202:8080/ABI/eui/core/ajax.js:1:2798)
at XMLHttpRequest.hp.onreadystatechange (http://192.168.1.202:8080/ABI/eui/core/ajax.js:1:3329)
