Excel导入时校验数据报错(定义中不存在参数[createActionParam])

wushiwusuo

业务需求：excel导入时去掉空行，（判断某金额字段是否为空）
按照帖子http://bbs.justep.com/forum.php?mod=viewthread&tid=37297&highlight=excel%E5%AF%BC%E5%85%A5进行的。
在点击excel导入时报错。求指点。报错信息如下：
2014-06-18 16:33:51 check error!
com.justep.model.exception.ModelException: /SROA/finance/process/gatherPublish/importExcelBeforeAction定义中不存在参数[createActionParam]
        at com.justep.util.Utils.check(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)
        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:595)
catch JniException in invokeActions .find Java exception in invokeActions after invoke translateParameters
2014-06-18 16:33:51 invokeActions error！
com.justep.model.exception.ModelException: com.justep.model.exception.ModelException: /SROA/finance/process/gatherPublish/importExcelBeforeAction定义中不存在参数[createActionParam]
        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:595)
Caused by: com.justep.model.exception.ModelException: /SROA/finance/process/gatherPublish/importExcelBeforeAction定义中不存在参数[createActionParam]
        at com.justep.util.Utils.check(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
2014-06-18 16:33:51 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/SROA/finance/process/gatherPublish/gatherPublishProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="importExcelBeforeAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="config">
<xbiz:xml>
<config use-default="true" to="UI" excel-file="E:\x5.2.1.2000\apache-tomcat\temp\35c5cc27-1afd-48e2-8a0d-2317d64a67d4.tmp" mapping-file="E:\x5.2.1.2000\apache-tomcat\temp\a879c19c-eae3-40be-a186-8e4488296289.tmp"><data><concept name="SR_GatherPublish">
<relation name="calculate0" type="Object"/>
<relation name="fReceiptDate" type="Date"/>
<relation name="fOtherName" type="String"/>
<relation name="fCollectedMoney" type="Decimal"/>
<relation name="fNote" type="String"/>
<relation name="fUnclaimedMoney" type="Decimal"/>
<relation name="version" type="Integer"/>
<relation name="fCreatePsnFID" type="String"/>
<relation name="fCreatePsnID" type="String"/>
<relation name="fCreatePsnName" type="String"/><relation name="fCreateTime" type="DateTime"/><relation name="fClaimedMoney" type="Decimal"/><relation name="fRefundMoney" type="Decimal"/><relation name="fGatherType" 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">/SROA/finance/process/gatherPublish/gatherPublishProcess</xbiz:simple></item><item key="activity"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">mainActivity</xbiz:simple></item><item key="action"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">createSR_GatherPublishAction</xbiz:simple></item><item key="parameters"><xbiz:map><item key="table"><xbiz:table><rows><userdata name="concept">SR_GatherPublish</userdata><userdata name="concept-alias">SR_GatherPublish</userdata><userdata name="id-column-name">SR_GatherPublish</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">SR_GatherPublish</userdata><userdata name="relations">EXPRESS,SR_GatherPublish.fReceiptDate,SR_GatherPublish.fOtherName,SR_GatherPublish.fCollectedMoney,SR_GatherPublish.fNote,SR_GatherPublish.fUnclaimedMoney,SR_GatherPublish.version,SR_GatherPublish.fCreatePsnFID,SR_GatherPublish.fCreatePsnID,SR_GatherPublish.fCreatePsnName,SR_GatherPublish.fCreateTime,SR_GatherPublish.fClaimedMoney,SR_GatherPublish.fRefundMoney,SR_GatherPublish.fGatherType</userdata><userdata name="relation-alias">calculate0,fReceiptDate,fOtherName,fCollectedMoney,fNote,fUnclaimedMoney,version,fCreatePsnFID,fCreatePsnID,fCreatePsnName,fCreateTime,fClaimedMoney,fRefundMoney,fGatherType</userdata><userdata name="relation-types">Object,Date,String,Decimal,String,Decimal,Integer,String,String,String,DateTime,Decimal,Decimal,String</userdata><userdata name="model">/SROA/finance/data</userdata><userdata name="update-mode">whereVersion</userdata></rows></xbiz:table></item><item key="defaultValues"><xbiz:map><item key="fGatherType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">
'业务往来资金'
</xbiz:simple></item></xbiz:map></item></xbiz:map></item></xbiz:map></parameter></parameters></action>

com.justep.model.exception.ModelException: com.justep.model.exception.ModelException: /SROA/finance/process/gatherPublish/importExcelBeforeAction定义中不存在参数[createActionParam]
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.model.exception.ModelException: /SROA/finance/process/gatherPublish/importExcelBeforeAction定义中不存在参数[createActionParam]
        at com.justep.util.Utils.check(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

wushiwusuo

补充一下，我进行第一步的时候添加了如下的jar包。

jishuang

参考http://bbs.justep.com/forum.php? ... 7&pid=165008000，仔细看看什么地方写的不对

wushiwusuo

jishuang 发表于 2014-6-19 10:19
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=37297&pid=165008000，仔细看看什 ...

感谢，原因是我的excel选择了imprtExcelBeforeAction动作，修改成importExcel就可以了。请结贴吧。

malixin

jishuang 发表于 2014-6-19 10:19
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=37297&pid=165008000，仔细看看什 ...

遇到了同样的问题，提示没有定义参数"createActionParam"，如楼下所述“excel选择了imprtExcelBeforeAction动作，修改成importExcel就可以了”，这样做对吗?这样话选择的action就不一样了，那之前设置的那些根本不起作用。