[亿信BI4.6] 导出EXCEL停滞 10%

您好,尝试重新导出还有这个问题吗?

有

尝试了，调整服务器的内存，好像是受JVM的内存限制，调整jvm16G时，系统出现了点异常，bi的系统监控 那块报错了

系统监控报了什么错?调高了内存导出好了没?调内存不能超过服务器的内存总量,还需要预留一些别的应用的内存空间

本帖最后由 K-tim 于 2021-8-27 16:58 编辑

你说的这些都考虑过 了，，提问时太仓促了，没有说明情况。
tomcat 启动里调整了 xms值到16G系统监控会报错，然后调低8G又恢复正常了，但导出还是不行

点击详细信息看看

Xms是初始化内存,你还要调Xmx最大内存吧

详细里面没有报错异常，就是导的很慢，一直停着

2021-08-27 17:32:13.752 构造导出用的报表...
2021-08-27 17:32:13.752 构造报表完毕，正在导出报表:产品检验仓库对接表...
2021-08-27 17:32:13.752 开始计算报表：TEST02（内存情况：FREE=3.6G TOTAL=7.9G MAX=7.9G）
2021-08-27 17:32:13.752 引用的主题表：TEST_ST_TXM_WCB
2021-08-27 17:32:13.752 查询的数据级次范围：没有做限制。
2021-08-27 17:32:13.752 001开始多表格各分析区并行计算
2021-08-27 17:32:13.767 [GRID7(0.0.30.2)]正在生成SQL...
2021-08-27 17:32:13.767 [GRID7(0.0.30.2)]计算表格GRID7
2021-08-27 17:32:13.767 [GRID7(0.0.30.2)]生成SQL耗时0毫秒
2021-08-27 17:32:13.783 [GRID7(0.0.30.2)]执行SQL:
   select row_.*,rownum from ( select max(a.BDYY) as AC2,a.HCLBZ as AB2,a.SCBZ as AA2,a.JYY as R2,a.RKMD_CKLSH as Q2,a.RKMD_YWRQ as O2,a.N20_QB as M2,a.ORDER_XSQY as L2,a.ORDER_KZ5 as K2,a.ORDER_USER0001 as J2,a.COLOR as I2,a.ORDER_PM as H2,a.ORDER_PINSIDENO as F2,a.RKMD_ORDERID as E2,a.RKMD_CPBH as D2,a.ORDER_KZ13 as C2,a.ORDER_KHMC as B2,a.ORDER_KH as A2
   from TEST_ST_TXM_WCB a
   where (a.RKMD_YWRQ BETWEEN '2021-08-01 17:31:49' AND '2021-08-31 17:31:54')
   group by a.ORDER_KH,a.ORDER_KHMC,a.ORDER_KZ13,a.RKMD_CPBH,a.RKMD_ORDERID,a.ORDER_PINSIDENO,a.ORDER_PM,a.COLOR,a.ORDER_USER0001,a.ORDER_KZ5,a.ORDER_XSQY,a.N20_QB,a.RKMD_YWRQ,a.RKMD_CKLSH,a.JYY,a.SCBZ,a.HCLBZ )row_ where rownum <= 50000
2021-08-27 17:32:14.111 [GRID7(0.0.30.2)]SQL执行完毕，查询出16,900条数据，耗时：344毫秒（开始时间：2021-08-27 17:32:13.767；结束时间：2021-08-27 17:32:14.111）；其中生成SQL耗时0毫秒；初始获取连接耗时：16毫秒；分步临时表耗时：0毫秒；查询准备总耗时：16毫秒；执行查询sql耗时：312毫秒；
2021-08-27 17:32:14.111 [GRID7(0.0.30.2)]正在生成SQL...
2021-08-27 17:32:14.127 [GRID7(0.0.30.2)]计算表格GRID7
2021-08-27 17:32:14.127 [GRID7(0.0.30.2)]生成SQL耗时16毫秒
2021-08-27 17:32:14.127 [GRID7(0.0.30.2)]执行SQL:
   select row_.*,rownum from ( select max(a.BH) as S2,sum(nvl(a.A,0)) as T2,sum(nvl(a.B,0)) as U2,sum(nvl(a.FP,0)) as V2,max(a.AJC) as W2,max(a.RKMD_KZ5) as Z2,a.JYY as R2,a.RKMD_CKLSH as Q2,a.RKMD_YWRQ as O2,a.N20_QB as M2,a.ORDER_XSQY as L2,a.ORDER_KZ5 as K2,a.ORDER_USER0001 as J2,a.COLOR as I2,a.ORDER_PM as H2,a.ORDER_PINSIDENO as F2,a.RKMD_ORDERID as E2,a.RKMD_CPBH as D2,a.ORDER_KZ13 as C2,a.ORDER_KHMC as B2,a.ORDER_KH as A2
   from TEST_ST_TXM_WCB a
   where (a.RKMD_YWRQ BETWEEN '2021-08-01 17:31:49' AND '2021-08-31 17:31:54')
   group by a.ORDER_KH,a.ORDER_KHMC,a.ORDER_KZ13,a.RKMD_CPBH,a.RKMD_ORDERID,a.ORDER_PINSIDENO,a.ORDER_PM,a.COLOR,a.ORDER_USER0001,a.ORDER_KZ5,a.ORDER_XSQY,a.N20_QB,a.RKMD_YWRQ,a.RKMD_CKLSH,a.JYY )row_ where rownum <= 50000
2021-08-27 17:32:14.517 [GRID7(0.0.30.2)]SQL执行完毕，查询出16,896条数据，耗时：406毫秒（开始时间：2021-08-27 17:32:14.111；结束时间：2021-08-27 17:32:14.517）；其中生成SQL耗时16毫秒；初始获取连接耗时：0毫秒；分步临时表耗时：0毫秒；查询准备总耗时：0毫秒；执行查询sql耗时：359毫秒；
2021-08-27 17:32:14.517 [GRID7(0.0.30.2)]正在生成SQL...
2021-08-27 17:32:14.517 [GRID7(0.0.30.2)]计算表格GRID7
2021-08-27 17:32:14.517 [GRID7(0.0.30.2)]生成SQL耗时0毫秒
2021-08-27 17:32:14.517 [GRID7(0.0.30.2)]执行SQL:
   select row_.*,rownum from ( select max( SUBSTR(a.RKMD_YWRQ,1,10)) as P2,a.RKMD_YWRQ as O2,a.N20_QB as M2,a.ORDER_XSQY as L2,a.ORDER_KZ5 as K2,a.ORDER_USER0001 as J2,a.COLOR as I2,a.ORDER_PM as H2,a.ORDER_PINSIDENO as F2,a.RKMD_ORDERID as E2,a.RKMD_CPBH as D2,a.ORDER_KZ13 as C2,a.ORDER_KHMC as B2,a.ORDER_KH as A2
   from TEST_ST_TXM_WCB a
   where (a.RKMD_YWRQ BETWEEN '2021-08-01 17:31:49' AND '2021-08-31 17:31:54')
   group by a.ORDER_KH,a.ORDER_KHMC,a.ORDER_KZ13,a.RKMD_CPBH,a.RKMD_ORDERID,a.ORDER_PINSIDENO,a.ORDER_PM,a.COLOR,a.ORDER_USER0001,a.ORDER_KZ5,a.ORDER_XSQY,a.N20_QB,a.RKMD_YWRQ )row_ where rownum <= 50000
2021-08-27 17:32:15.002 [GRID7(0.0.30.2)]SQL执行完毕，查询出16,889条数据，耗时：485毫秒（开始时间：2021-08-27 17:32:14.517；结束时间：2021-08-27 17:32:15.002）；其中生成SQL耗时0毫秒；初始获取连接耗时：0毫秒；分步临时表耗时：0毫秒；查询准备总耗时：0毫秒；执行查询sql耗时：453毫秒；
2021-08-27 17:32:15.017 [GRID7(0.0.30.2)]正在生成SQL...
2021-08-27 17:32:15.017 [GRID7(0.0.30.2)]计算表格GRID7
2021-08-27 17:32:15.017 [GRID7(0.0.30.2)]生成SQL耗时0毫秒
2021-08-27 17:32:15.017 [GRID7(0.0.30.2)]执行SQL:
   select row_.*,rownum from ( select max(a.ORDER_BZYQ) as N2,a.N20_QB as M2,a.ORDER_XSQY as L2,a.ORDER_KZ5 as K2,a.ORDER_USER0001 as J2,a.COLOR as I2,a.ORDER_PM as H2,a.ORDER_PINSIDENO as F2,a.RKMD_ORDERID as E2,a.RKMD_CPBH as D2,a.ORDER_KZ13 as C2,a.ORDER_KHMC as B2,a.ORDER_KH as A2
   from TEST_ST_TXM_WCB a
   where (a.RKMD_YWRQ BETWEEN '2021-08-01 17:31:49' AND '2021-08-31 17:31:54')
   group by a.ORDER_KH,a.ORDER_KHMC,a.ORDER_KZ13,a.RKMD_CPBH,a.RKMD_ORDERID,a.ORDER_PINSIDENO,a.ORDER_PM,a.COLOR,a.ORDER_USER0001,a.ORDER_KZ5,a.ORDER_XSQY,a.N20_QB )row_ where rownum <= 50000
2021-08-27 17:32:15.330 [GRID7(0.0.30.2)]SQL执行完毕，查询出14,898条数据，耗时：313毫秒（开始时间：2021-08-27 17:32:15.017；结束时间：2021-08-27 17:32:15.330）；其中生成SQL耗时0毫秒；初始获取连接耗时：0毫秒；分步临时表耗时：0毫秒；查询准备总耗时：0毫秒；执行查询sql耗时：297毫秒；
2021-08-27 17:32:15.345 [GRID7(0.0.30.2)]正在生成SQL...
2021-08-27 17:32:15.345 [GRID7(0.0.30.2)]计算表格GRID7
2021-08-27 17:32:15.345 [GRID7(0.0.30.2)]生成SQL耗时0毫秒
2021-08-27 17:32:15.345 [GRID7(0.0.30.2)]执行SQL:
   select row_.*,rownum from ( select max(a.ORDER_NUM) as G2,a.ORDER_PINSIDENO as F2,a.RKMD_ORDERID as E2,a.RKMD_CPBH as D2,a.ORDER_KZ13 as C2,a.ORDER_KHMC as B2,a.ORDER_KH as A2
   from TEST_ST_TXM_WCB a
   where (a.RKMD_YWRQ BETWEEN '2021-08-01 17:31:49' AND '2021-08-31 17:31:54')
   group by a.ORDER_KH,a.ORDER_KHMC,a.ORDER_KZ13,a.RKMD_CPBH,a.RKMD_ORDERID,a.ORDER_PINSIDENO )row_ where rownum <= 50000
2021-08-27 17:32:15.595 [GRID7(0.0.30.2)]SQL执行完毕，查询出14,898条数据，耗时：250毫秒（开始时间：2021-08-27 17:32:15.345；结束时间：2021-08-27 17:32:15.595）；其中生成SQL耗时0毫秒；初始获取连接耗时：0毫秒；分步临时表耗时：0毫秒；查询准备总耗时：0毫秒；执行查询sql耗时：250毫秒；

那是单纯得慢嘛?等一段时间能导出嘛?