importExcel导入数据时出错，什么原因？

lijie_75

编码：JUSTEP170004

隐藏详细

java.lang.reflect.InvocationTargetException atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:497) atcom.justep.system.action.Engine.invokeActions(Native Method) atcom.justep.system.action.Engine.invokeActions(Unknown Source) atcom.justep.business.server.BusinessServer.doAction(Unknown Source) atcom.justep.business.server.BusinessServer.doExcute(Unknown Source) atcom.justep.business.server.BusinessServer.excute(Unknown Source) atcom.justep.business.server.BusinessServer.excute(Unknown Source) atcom.justep.business.server.BusinessServerServlet.execService(Unknown Source) atcom.justep.business.server.BusinessServerServlet.service(Unknown Source) atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723) atcom.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) atjava.lang.Thread.run(Thread.java:745) Caused by:com.justep.excel.ExcelException: 编码: JUSTEP170004; 提示: atcom.justep.excel.ExcelException.create(ExcelException.java:28) atcom.justep.excel.ImportConceptConfig.<init>(ImportConceptConfig.java:28)at com.justep.excel.ImportConfig.<init>(ImportConfig.java:15) atcom.justep.excel.ImportGenerator.loadMapping(ImportGenerator.java:85) atcom.justep.excel.ImportGenerator.init(ImportGenerator.java:59) atcom.justep.excel.ImportGenerator.generate(ImportGenerator.java:109) at Excel.importExcel(Excel.java:88)... 27 more

jishuang

确认XXX.mapping.xml中配置的概念等都正确吗？

gzcyp2000

导入错误常见的原因有三种，一种是mapping配置不正确，二种是数据表结构中存在not null字段但导入表格中此类字段对应的单元格却有null值，一种是excel表格记录行下方空白行的可能误输入了空格之类的东西，导入时也当成为数据行进行导入，产生第二种错误。

lijie_75

好的，我好好查一下，谢谢了！。导4个表，2个表正常，另2个表不正常，换成csv用数据库管理工具导就OK.