excelImport数据daoru

wenxin8580

excel导入报错空指针

jishuang

mapping文件中配置的概念等是否正确

wenxin8580

jishuang 发表于 2020-4-14 18:24
mapping文件中配置的概念等是否正确

配置了，没有问题

jishuang

把mapping的配置和excel文件都发一下

wenxin8580

jishuang 发表于 2020-4-15 09:22
把mapping的配置和excel文件都发一下

jishuang

tomcat控制台完整的错误信息也发一下
mapping中concept中配置的概念名确认是否正确？

wenxin8580

jishuang 发表于 2020-4-15 10:18
tomcat控制台完整的错误信息也发一下
mapping中concept中配置的概念名确认是否正确？
...

概念名没错
2020-04-15 10:19:02 invokeActions error！
com.justep.model.exception.ModelException: java.lang.NullPointerException
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
        at com.justep.system.transform.Row2Table.transform(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transTableParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transMapParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transMapParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.helpTransformByElement(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transform(Unknown Source)
        at com.justep.system.transform.RequestTransform.transParamValue(Unknown Source)
        at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source)
        at com.justep.system.transform.RequestTransform.transform(Unknown Source)
        at com.justep.system.action.Engine.translateParameters(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
2020-04-15 10:19:02 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/SA/excel/system/systemProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="importExcel"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="config"><xbiz:xml><config use-default="true" to="DB" excel-file="D:\Aisino\WMS\wms_xc\apache-tomcat\temp\b9954302-9fe9-46eb-b2c5-28132b21f194.tmp" mapping-file="D:\Aisino\WMS\wms_xc\apache-tomcat\temp\635d3ec4-2311-41fe-a915-80f74f885c35.tmp"><data><concept name="ASSEMBLY_SUPPLY_CHAIN"><relation name="MTL_ITEM_CODE" type="String"/><relation name="PRODUCTION_LINE_CODE" type="String"/><relation name="STATION_CODE" type="String"/><relation name="PICK_LPN" type="String"/><relation name="DELAY_STATE" type="Integer"/><relation name="STORE_HOUSE_CODE" type="String"/><relation name="WIP_SUPPLY_TXT" type="String"/><relation name="SUBINVENTORY_CODE" type="String"/><relation name="SUBINV_PRIORITY" type="String"/><relation name="BH_TYPE" type="String"/><relation name="TO_POSITION_CODE_FL" type="String"/><relation name="TO_POSITION_CODE_BH" type="String"/><relation name="WIP_SUPPLY_TYPE" type="Integer"/><relation name="DESTINATION_CODE" type="String"/><relation name="LAST_UPDATE_DATE" type="DateTime"/><relation name="IS_CLEAN" type="Integer"/><relation name="ZONE_CODE" type="String"/><relation name="LOCATOR_X" type="String"/><relation name="MTL_GROUP_SUBINV" type="String"/></concept></data></config></xbiz:xml></parameter><parameter name="createActionParam"><xbiz:map><item key="process"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[/lms/po/process/po/poProcess]]></xbiz:simple></item><item key="activity"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[AssemblySupplyActity]]></xbiz:simple></item><item key="action"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[createASSEMBLY_SUPPLY_CHAINAction]]></xbiz:simple></item><item key="parameters"><xbiz:map><item key="table"><xbiz:table>[object Object]</xbiz:table></item><item key="defaultValues"><xbiz:map/></item></xbiz:map></item></xbiz:map></parameter><parameter name="saveActionParam"><xbiz:map><item key="process"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[/lms/po/process/po/poProcess]]></xbiz:simple></item><item key="activity"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[AssemblySupplyActity]]></xbiz:simple></item><item key="action"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[saveASSEMBLY_SUPPLY_CHAINAction]]></xbiz:simple></item><item key="parameters"><xbiz:map><item key="table"><xbiz:table>[object Object]</xbiz:table></item></xbiz:map></item></xbiz:map></parameter></parameters></action>
com.justep.model.exception.ModelException: java.lang.NullPointerException
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
        at com.justep.system.transform.Row2Table.transform(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transTableParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transMapParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transMapParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transParam(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.helpTransformByElement(Unknown Source)
        at com.justep.system.transform.ActionParameterTransform.transform(Unknown Source)
        at com.justep.system.transform.RequestTransform.transParamValue(Unknown Source)
        at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source)
        at com.justep.system.transform.RequestTransform.transform(Unknown Source)
        at com.justep.system.action.Engine.translateParameters(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more

jishuang

看着是正确的，excel文件是什么版本office生成的

wenxin8580

jishuang 发表于 2020-4-15 13:33
看着是正确的，excel文件是什么版本office生成的

问题找到了，业务数据格式不对，结贴