永洪社区

标题: 8.8.4b版本企业微信导出报表excel报错 [打印本页]

作者: yhdata_58W66IdQ 时间: 2022-5-6 11:56
标题: 8.8.4b版本企业微信导出报表excel报错
8.8.4b版本企业微信导出报表excel报错
报错为文件不存在

作者: yhdata_58W66IdQ 时间: 2022-5-6 11:57
报错信息

作者: 环环 时间: 2022-5-6 12:03
本帖最后由永洪tech-秀秀于 2022-5-6 12:16 编辑

这是导出报告的时候报错吗，该报告能够正常查看这个数据集吗

作者: yhdata_58W66IdQ 时间: 2022-5-6 13:00

永洪tech-秀秀发表于 2022-5-6 12:03
这是导出报告的时候报错吗，该报告能够正常查看这个数据集吗

发现新版本的企业微信有这个问题，偶尔可以导出

作者: 环环 时间: 2022-5-6 13:18
不通过企业微信，直接访问BI的方式这个报告可以正常导出吗。如果直接导出正常，看下是不是文件名中有 "_"、"-"这种符号的，通过企业微信导出就会报错

作者: yhdata_58W66IdQ 时间: 2022-5-6 15:05

永洪tech-秀秀发表于 2022-5-6 13:18
不通过企业微信，直接访问BI的方式这个报告可以正常导出吗。如果直接导出正常，看下是不是文件名中有 "_"、 ...

详细信息：文件“1、油水-yh-631_db.xlsx”不存在。

作者: yhdata_58W66IdQ 时间: 2022-5-6 15:06

yhdata_58W66IdQ 发表于 2022-5-6 15:05
详细信息：文件“1、油水-yh-631_db.xlsx”不存在。

从电脑端导出是正常的，现在发现从企业微信导出会自动加上-yh-631_db.xlsx

作者: 环环 时间: 2022-5-6 15:29
访问的时候会有这么一个文件，麻烦取一下企业微信导出报错时段的日志呢

作者: yhdata_58W66IdQ 时间: 2022-5-6 15:46

永洪tech-秀秀发表于 2022-5-6 15:29
访问的时候会有这么一个文件，麻烦取一下企业微信导出报错时段的日志呢

|-18667033690-966cd0121bbe4946bf064c0eec997543 |-[INFO] |-g5.sv.db.req.ExportDBReq.process0(ExportDBReq.java:129) | Export Excel '/opt/Yonghong8823/Yonghong/temp/excel/1、油水-yh-685_db.xlsx', cost 1258
2022-05-06 15:42:11.497 |-18667033690-966cd0121bbe4946bf064c0eec997543 |-[INFO] |-g5.sv.db.DBReq.auditActions(DBReq.java:372) | 18667033690,输出报告"6、营运培训部/1、油水.db" 输出类型:Excel。
2022-05-06 15:42:11.499 |-18667033690-966cd0121bbe4946bf064c0eec997543 |-[INFO] |-g5.common.audit.PerformanceItem.<init>(PerformanceItem.java:66) | ExportDBReq, id=1、油水20220506154113-1539, sid=区域, cost=1260
2022-05-06 15:42:11.600 |-18667033690-13fb59372275491698118ead6dee41d3 |-[ERROR] |-g5.sv.ServletHelper.service(ServletHelper.java:100) | java.io.IOException: Broken pipe
org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:351) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.appendByteArray(OutputBuffer.java:746) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.append(OutputBuffer.java:675) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:386) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:364) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:96) ~[catalina.jar:9.0.31]
at g5.io.IOUtil.copy(IOUtil.java:466) ~[product-20201105.jar:?]
at g5.io.IOUtil.copy(IOUtil.java:449) ~[product-20201105.jar:?]
at g5.sv.ResProc.procExportFile(ResProc.java:606) ~[product-20201105.jar:?]
at g5.sv.ResProc.service(ResProc.java:97) ~[product-20201105.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:96) [product-20201105.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:397) [product-20201105.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at g5.sv.standardsso.AbstractTokenSSOFilter.doFilter(AbstractTokenSSOFilter.java:57) [product-20201105.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.31]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.31]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.31]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.31]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.31]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.31]
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.31]
at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:?]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:?]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:113) ~[?:?]
at sun.nio.ch.IOUtil.write(IOUtil.java:79) ~[?:?]
at sun.nio.ch.IOUtil.write(IOUtil.java:50) ~[?:?]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:466) ~[?:?]
at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:138) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1279) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:741) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.writeBlocking(SocketWrapperBase.java:561) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.write(SocketWrapperBase.java:505) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.doWrite(Http11OutputBuffer.java:538) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:112) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.Http11OutputBuffer.doWrite(Http11OutputBuffer.java:190) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.Response.doWrite(Response.java:601) ~[tomcat-coyote.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:339) ~[catalina.jar:9.0.31]
... 37 more
2022-05-06 15:42:11.602 |-18667033690-574bb72cdde44fea989314c3f304d347 |-[ERROR] |-g5.sv.ServletHelper.service(ServletHelper.java:100) | 文件“1、油水-yh-685_db.xlsx”不存在。
g5.util.GRTException: 文件“1、油水-yh-685_db.xlsx”不存在。
at g5.sv.ResProc.procExportFile(ResProc.java:545) ~[product-20201105.jar:?]
at g5.sv.ResProc.service(ResProc.java:97) ~[product-20201105.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:96) [product-20201105.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:397) [product-20201105.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at g5.sv.standardsso.AbstractTokenSSOFilter.doFilter(AbstractTokenSSOFilter.java:57) [product-20201105.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.31]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.31]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.31]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.31]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.31]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.31]
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.31]
at java.lang.Thread.run(Thread.java:834) [?:?]
2022-05-06 15:42:11.602 |-18667033690-13fb59372275491698118ead6dee41d3 |-[WARN] |-g5.io.FileSystem.close(FileSystem.java:239) | java.io.IOException: Broken pipe
org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:309) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:272) ~[catalina.jar:9.0.31]
at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:118) ~[catalina.jar:9.0.31]
at g5.io.FileSystem.close(FileSystem.java:225) [product-20201105.jar:?]
at g5.sv.util.WebUtil.copyResource(WebUtil.java:731) [product-20201105.jar:?]
at g5.sv.PortalProc.informUser(PortalProc.java:94) [product-20201105.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:102) [product-20201105.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:397) [product-20201105.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at g5.sv.standardsso.AbstractTokenSSOFilter.doFilter(AbstractTokenSSOFilter.java:57) [product-20201105.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.31]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.31]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.31]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.31]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [catalina.jar:9.0.31]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.31]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.31]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.31]
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.31]
at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: java.io.IOException: Broken pipe
at sun.nio.ch.FileDispatcherImpl.write0(Native Method) ~[?:?]
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) ~[?:?]
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:113) ~[?:?]
at sun.nio.ch.IOUtil.write(IOUtil.java:79) ~[?:?]
at sun.nio.ch.IOUtil.write(IOUtil.java:50) ~[?:?]
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:466) ~[?:?]
at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:138) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1279) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:741) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.flushBlocking(SocketWrapperBase.java:694) ~[tomcat-coyote.jar:9.0.31]
at org.apache.tomcat.util.net.SocketWrapperBase.flush(SocketWrapperBase.java:684) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.Http11OutputBuffer$SocketOutputBuffer.flush(Http11OutputBuffer.java:564) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.filters.ChunkedOutputFilter.flush(ChunkedOutputFilter.java:157) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.Http11OutputBuffer.flush(Http11OutputBuffer.java:217) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.http11.Http11Processor.flush(Http11Processor.java:1142) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.AbstractProcessor.action(AbstractProcessor.java:400) ~[tomcat-coyote.jar:9.0.31]
at org.apache.coyote.Response.action(Response.java:209) ~[tomcat-coyote.jar:9.0.31]
at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:305) ~[catalina.jar:9.0.31]
... 33 more

作者: 环环 时间: 2022-5-6 16:03
之前版本的企业微信都是正常的吧，麻烦再看下当前企业微信的版本呢

作者: yhdata_58W66IdQ 时间: 2022-5-6 16:08

永洪tech-秀秀发表于 2022-5-6 16:03
之前版本的企业微信都是正常的吧，麻烦再看下当前企业微信的版本呢

之前是4.0.3，是正常
企业微信更新后 4.0.6就不行了

作者: 环环 时间: 2022-5-6 16:23
好的，我们先排查一下

作者: 环环 时间: 2022-5-6 17:41
私聊你了，看下消息呢

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