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

EXCEL导入报错

yhdata_SAdBVbaR青铜二 显示全部楼层 发表于 2021-11-29 09:24:07 |阅读模式 打印 上一主题 下一主题
1、EXCEL导入保存时报错见附件11
2、日志错误:
[2021-11-28 21:10:13.378] |-[ERROR] |-[9487769e8a654d4eb03f1a16d093c350] |-[admin] |-[g5.sv.db.DBProc.procReq(DBProc.java:1143)] |-[DASHBOARD: [城网板块20211128203809-394<皖天然气数据中心/数据填报中心/经营数据填报/财务类数据/城网板块.db>][ErrCode: 8192]  请输入“0”和“179,769,313,486,231,570,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000”之间的数据。]
g5.util.GRTException: 请输入“0”和“179,769,313,486,231,570,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000”之间的数据。
        at g5.sv.db.req.CommitReq.checkRules(CommitReq.java:336) ~[product.jar:?]
        at g5.sv.db.req.CommitReq.checkDataInvalid(CommitReq.java:241) ~[product.jar:?]
        at g5.sv.db.req.CommitReq.checkInputValid(CommitReq.java:186) ~[product.jar:?]
        at g5.sv.db.req.CommitReq.process0(CommitReq.java:122) ~[product.jar:?]
        at g5.sv.Req.process(Req.java:41) ~[product.jar:?]
        at g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1061) ~[product.jar:?]
        at g5.sv.db.DBProc.procReq(DBProc.java:984) [product.jar:?]
        at g5.sv.db.DBProc.service(DBProc.java:137) [product.jar:?]
        at g5.sv.ServletHelper.service(ServletHelper.java:101) [product.jar:?]
        at g5.sv.PortalServlet.service(PortalServlet.java:465) [product.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.37]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.37]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.37]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.37]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.37]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.37]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.37]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.37]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.37]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.37]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote.jar:9.0.37]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.37]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.37]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.37]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.37]
        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.37]
        at java.lang.Thread.run(Thread.java:834) [?:?]
3、数据库表配置:
见附件22

不知道问题在哪里,如何处理啊?
11.png
22.png
回复

使用道具 举报

精彩评论3

_贝贝白银一 显示全部楼层 发表于 2021-11-29 11:15:23
检查一下数据库字段是否允许负值 包括字段长度是否超过
回复 支持 反对

使用道具 举报

SamuelLiu青铜四 显示全部楼层 发表于 2021-12-22 10:23:02
编辑报告,选中当月数,看下右侧设置-编辑器中的最大值和最小值范围,看报错应该是范围设置有问题。
回复 支持 反对

使用道具 举报

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

  • 官方微信

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

    扫码关注
  • 新浪微博

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

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

会员等你来哦

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