找文章 / 找答案
精选问答 更多内容

[报错信息处理] 8.8.4b版本企业微信导出报表excel报错

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 11:56:47 |阅读模式 打印 上一主题 下一主题
8.8.4b版本企业微信导出报表excel报错
报错为文件不存在

回复

使用道具 举报

精彩评论12

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 11:57:20
报错信息
0ac8daaeea1a4870b28a2bed86fa1b4.png
回复

使用道具 举报

环环白银三 显示全部楼层 发表于 2022-5-6 12:03:08
本帖最后由 永洪tech-秀秀 于 2022-5-6 12:16 编辑

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

使用道具 举报

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 13:00:04
永洪tech-秀秀 发表于 2022-5-6 12:03
这是导出报告的时候报错吗,该报告能够正常查看这个数据集吗

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

使用道具 举报

环环白银三 显示全部楼层 发表于 2022-5-6 13:18:34
不通过企业微信,直接访问BI的方式这个报告可以正常导出吗。如果直接导出正常,看下是不是文件名中有 "_"、"-"这种符号的,通过企业微信导出就会报错
回复

使用道具 举报

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 15:05:35
永洪tech-秀秀 发表于 2022-5-6 13:18
不通过企业微信,直接访问BI的方式这个报告可以正常导出吗。如果直接导出正常,看下是不是文件名中有 "_"、 ...

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

使用道具 举报

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 15:06:21
yhdata_58W66IdQ 发表于 2022-5-6 15:05
详细信息:文件“1、油水-yh-631_db.xlsx”不存在。

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

使用道具 举报

环环白银三 显示全部楼层 发表于 2022-5-6 15:29:56
访问的时候会有这么一个文件,麻烦取一下企业微信导出报错时段的日志呢
回复

使用道具 举报

yhdata_58W66IdQ白银一 显示全部楼层 发表于 2022-5-6 15:46:27
永洪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:52
之前版本的企业微信都是正常的吧,麻烦再看下当前企业微信的版本呢
回复

使用道具 举报

高级模式
您需要登录后才可以回帖 登录 | 免费注册

  • 官方微信

    欢迎关注永洪服务号!收费为0,价值无限

    扫码关注
  • 新浪微博

    让每位用户轻松挖掘数据价值!

    访问新浪微博
  • 智能客服
50W

会员等你来哦

Copyright   ©2012-2024  北京永洪商智科技有限公司  (京ICP备12050607) 京公网安备110110802011451号 |《永洪社区协议》
返回顶部