导入Excel

dh_n · 发表于 2017-12-1 15:49:03

导入Excel,导入Excel,导入不进去，经常需要重启Tomcat，为什么？

jishuang · 发表于 2017-12-1 16:40:06

导入不进去具体什么现象？

重启tomcat就可以导入了？

dh_n · 发表于 2017-12-1 21:24:05

[code]/erp/marketSys/process/ProArchives/proArchivesProcess/TaskBookManagement/importExcelBeforeAction///{excel=Name: /xl/workbook.xml - Content Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml, config=com.justep.excel.ImportConfig@120edc1}
java.lang.IllegalArgumentException: wrong number of arguments

重启Tomcat，就好了，为什么？

jishuang · 发表于 2017-12-4 09:00:22

如果是java.lang.IllegalArgumentException: wrong number of arguments这个错误跟重启tomcat无关
这个错是action的参数个数不正确
发tomcat控制台完整的错误信息

dh_n · 发表于 2017-12-4 16:14:55

2017-12-01 21:13:42 excute stream action, params:{"accept":"application/json","action":"importExcel","actionFlag":"__action_0__","activity":"TaskBookManagement","contentType":"json","executeContext":"","executor":"","parameters":{"config":{"@type":"xml","xml":"<config use-default=\"true\" to=\"DB\" excel-file=\"D:\\Bex5V3.6_1\\apache-tomcat\\temp\\bda85766-460a-426f-9646-9f701f867708.excel.tmp\" mapping-file=\"D:\\Bex5V3.6_1\\apache-tomcat\\temp\\264416ab-d0ee-44f9-8bfc-f6732aa91aef.excel.tmp\"><data><concept name=\"ERP_TaskBookSon\"><relation name=\"ERP_TaskBookSon\" type=\"String\"/><relation name=\"fBOMState\" type=\"String\"/><relation name=\"fBackupQuantity\" type=\"String\"/><relation name=\"fBeginDate\" type=\"Date\"/><relation name=\"fBomConfirmDate\" type=\"Date\"/><relation name=\"fBomConfirmPersonID\" type=\"String\"/><relation name=\"fBomStatus\" type=\"String\"/><relation name=\"fContractID\" type=\"String\"/><relation name=\"fCustomerBatch\" type=\"String\"/><relation name=\"fCustomerSalesman\" type=\"String\"/><relation name=\"fCustomerSalesmanID\" type=\"String\"/><relation name=\"fCustomerToken\" type=\"String\"/><relation name=\"fDeliveryDate\" type=\"Date\"/><relation name=\"fDispatch\" type=\"String\"/><relation name=\"fEditionCode\" type=\"String\"/><relation name=\"fFinalDeliveryNum\" type=\"Float\"/><relation name=\"fFullName\" type=\"String\"/><relation name=\"fISOffer\" type=\"String\"/><relation name=\"fImportDate\" type=\"Date\"/><relation name=\"fJTechnicalAgreement\" type=\"String\"/><relation name=\"fMainID\" type=\"String\"/><relation name=\"fMaterielCode\" type=\"String\"/><relation name=\"fMeaUniName\" type=\"String\"/><relation name=\"fMeteringUnitID\" type=\"String\"/><relation name=\"fNo\" type=\"Integer\"/><relation name=\"fNormsType\" type=\"String\"/><relation name=\"fOutsourcingOddNumber\" type=\"String\"/><relation name=\"fProduceOrderID\" type=\"String\"/><relation name=\"fProjectName\" type=\"String\"/><relation name=\"fPurpose\" type=\"String\"/><relation name=\"fRawMaterial\" type=\"String\"/><relation name=\"fRemark\" type=\"String\"/><relation name=\"fStandard\" type=\"String\"/><relation name=\"fStockName\" type=\"String\"/><relation name=\"fSumNum\" type=\"Float\"/><relation name=\"fTaskBookSonName\" type=\"String\"/><relation name=\"fWhetherDraw\" type=\"String\"/><relation name=\"fWhetherMaterial\" type=\"String\"/><relation name=\"fWhetherTechnology\" type=\"String\"/><relation name=\"version\" type=\"Integer\"/></concept></data></config>"},"createActionParam":{"action":"createERP_TaskBookSonAction","activity":"TaskBookManagement","parameters":{"defaultValues":{"fMainID":"'0D26FD1AE2DB485CB10B090687449C3C'"},"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"ERP_TaskBookSon","idColumnName":"ERP_TaskBookSon","idColumnType":"String","model":"/erp/marketSys/data","relationAlias":"fBOMState,fBackupQuantity,fBeginDate,fBomConfirmDate,fBomConfirmPersonID,fBomStatus,fContractID,fCustomerBatch,fCustomerSalesman,fCustomerSalesmanID,fCustomerToken,fDeliveryDate,fDispatch,fEditionCode,fFinalDeliveryNum,fFullName,fISOffer,fImportDate,fJTechnicalAgreement,fMainID,fMaterielCode,fMeaUniName,fMeteringUnitID,fNo,fNormsType,fOutsourcingOddNumber,fProduceOrderID,fProjectName,fPurpose,fRawMaterial,fRemark,fStandard,fStockName,fSumNum,fTaskBookSonName,fWhetherDraw,fWhetherMaterial,fWhetherTechnology,version","relationTypes":"String,String,Date,Date,String,String,String,String,String,String,String,Date,String,String,Float,String,String,Date,String,String,String,String,String,Integer,String,String,String,String,String,String,String,String,String,Float,String,String,String,String,Integer","relations":"ERP_MM_BOMMaster.fBOMState,ERP_TaskBookSon.fBackupQuantity,ERP_TaskBookSon.fBeginDate,ERP_TaskBookSon.fBomConfirmDate,ERP_TaskBookSon.fBomConfirmPersonID,ERP_TaskBookSon.fBomStatus,ERP_TaskBookSon.fContractID,ERP_TaskBookSon.fCustomerBatch,ERP_CustomerContacts.fName,ERP_TaskBookSon.fCustomerSalesmanID,ERP_TaskBookSon.fCustomerToken,ERP_TaskBookSon.fDeliveryDate,ERP_TaskBookSon.fDispatch,ERP_TaskBookSon.fEditionCode,ERP_TaskBookSon.fFinalDeliveryNum,ERP_StockArchives.fFullName,ERP_TaskBookSon.fISOffer,ERP_TaskBookSon.fImportDate,ERP_TaskBookSon.fJTechnicalAgreement,ERP_TaskBookSon.fMainID,ERP_TaskBookSon.fMaterielCode,ERP_MeasurementUnit.fName,ERP_TaskBookSon.fMeteringUnitID,ERP_TaskBookSon.fNo,ERP_StockArchives.fNormsType,ERP_TaskBookSon.fOutsourcingOddNumber,ERP_TaskBookSon.fProduceOrderID,ERP_ProjectArchives.fProjectName,ERP_TaskBookSon.fPurpose,ERP_TaskBookSon.fRawMaterial,ERP_TaskBookSon.fRemark,ERP_TaskBookSon.fStandard,ERP_StockArchives.fStockName,ERP_TaskBookSon.fSumNum,ERP_TaskBookSon.fTaskBookSonName,ERP_TaskBookSon.fWhetherDraw,ERP_TaskBookSon.fWhetherMaterial,ERP_TaskBookSon.fWhetherTechnology,ERP_TaskBookSon.version","updateMode":"whereVersion"}}},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"},"saveActionParam":{"action":"saveERP_TaskBookSonAction","activity":"TaskBookManagement","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"ERP_TaskBookSon","idColumnName":"ERP_TaskBookSon","idColumnType":"String","model":"/erp/marketSys/data","relationAlias":"fBOMState,fBackupQuantity,fBeginDate,fBomConfirmDate,fBomConfirmPersonID,fBomStatus,fContractID,fCustomerBatch,fCustomerSalesman,fCustomerSalesmanID,fCustomerToken,fDeliveryDate,fDispatch,fEditionCode,fFinalDeliveryNum,fFullName,fISOffer,fImportDate,fJTechnicalAgreement,fMainID,fMaterielCode,fMeaUniName,fMeteringUnitID,fNo,fNormsType,fOutsourcingOddNumber,fProduceOrderID,fProjectName,fPurpose,fRawMaterial,fRemark,fStandard,fStockName,fSumNum,fTaskBookSonName,fWhetherDraw,fWhetherMaterial,fWhetherTechnology,version","relationTypes":"String,String,Date,Date,String,String,String,String,String,String,String,Date,String,String,Float,String,String,Date,String,String,String,String,String,Integer,String,String,String,String,String,String,String,String,String,Float,String,String,String,String,Integer","relations":"ERP_MM_BOMMaster.fBOMState,ERP_TaskBookSon.fBackupQuantity,ERP_TaskBookSon.fBeginDate,ERP_TaskBookSon.fBomConfirmDate,ERP_TaskBookSon.fBomConfirmPersonID,ERP_TaskBookSon.fBomStatus,ERP_TaskBookSon.fContractID,ERP_TaskBookSon.fCustomerBatch,ERP_CustomerContacts.fName,ERP_TaskBookSon.fCustomerSalesmanID,ERP_TaskBookSon.fCustomerToken,ERP_TaskBookSon.fDeliveryDate,ERP_TaskBookSon.fDispatch,ERP_TaskBookSon.fEditionCode,ERP_TaskBookSon.fFinalDeliveryNum,ERP_StockArchives.fFullName,ERP_TaskBookSon.fISOffer,ERP_TaskBookSon.fImportDate,ERP_TaskBookSon.fJTechnicalAgreement,ERP_TaskBookSon.fMainID,ERP_TaskBookSon.fMaterielCode,ERP_MeasurementUnit.fName,ERP_TaskBookSon.fMeteringUnitID,ERP_TaskBookSon.fNo,ERP_StockArchives.fNormsType,ERP_TaskBookSon.fOutsourcingOddNumber,ERP_TaskBookSon.fProduceOrderID,ERP_ProjectArchives.fProjectName,ERP_TaskBookSon.fPurpose,ERP_TaskBookSon.fRawMaterial,ERP_TaskBookSon.fRemark,ERP_TaskBookSon.fStandard,ERP_StockArchives.fStockName,ERP_TaskBookSon.fSumNum,ERP_TaskBookSon.fTaskBookSonName,ERP_TaskBookSon.fWhetherDraw,ERP_TaskBookSon.fWhetherMaterial,ERP_TaskBookSon.fWhetherTechnology,ERP_TaskBookSon.version","sys.rowid":"ERP_TaskBookSon","updateMode":"whereVersion"}}},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"}},"process":"/erp/marketSys/process/ProArchives/proArchivesProcess"}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.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)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: 导入excel失败!
at Excel.importExcel(Excel.java:93)
... 27 more

dh_n · 发表于 2017-12-4 16:15:42

重启Tomcat后，就正常了。

jishuang · 发表于 2017-12-4 16:40:29

还有其他的错误吗？这个看不出什么问题

平台默认带的excel组件案例有问题吗？

dh_n · 发表于 2017-12-4 17:00:12

其他Excel导入都没有问题，就这个主子表的导入子表的会出现需要重启Tomcat的情况。

jishuang · 发表于 2017-12-4 17:18:39

设置也其他的有什么不同吗？比如自己在事件中做了什么操作？

dh_n · 发表于 2017-12-4 19:49:44

设置是一样的，还没有进入我自己写的导入前事件。

		自动登录	找回密码
密码			注册

[结贴] 导入Excel