excel导出失败

tutuke · 发表于 2015-3-18 14:27:49

Error: {"message":",导出excel失败！ ","reason":"","code":"","stack":"","url":"","param":""}
at Object.options.callback (http://127.0.0.1:8000/x5/$v3486_no_/UI/system/components/excel/excel.js?language=zh_CN:368:11)
at cbf (http://127.0.0.1:8000/x5/$v3486_no_/base/base.js?language=zh_CN:1:52357)
at Object.sendRequest2 (http://127.0.0.1:8000/x5/$v3486_no_/base/base.js?language=zh_CN:1:52601)
at Object.sendBizRequest2 (http://127.0.0.1:8000/x5/$v3486_no_/base/base.js?language=zh_CN:1:89931)
at justep.ExportExcel._doExport (http://127.0.0.1:8000/x5/$v3486_no_/UI/system/components/excel/excel.js?language=zh_CN:371:18)
at null. (http://127.0.0.1:8000/x5/$v3486_no_/UI/system/components/excel/excel.js?language=zh_CN:135:10)
at z [as ev_onreceive] (http://127.0.0.1:8000/x5/$v3486_no_/form/form.js?language=zh_CN:1:269141)
at obj.(anonymous function) [as callEvent] (http://127.0.0.1:8000/x5/$v3486_no_/form/form.js?language=zh_CN:1:268868)
at justep.WindowDialog.ensure (http://127.0.0.1:8000/x5/$v3486_no_/UI/system/components/windowDialog/windowDialog.js?language=zh_CN:221:8)
at Object.justep.windowReceiver.windowEnsure (http://127.0.0.1:8000/x5/$v3486_no_/UI/system/components/windowDialog/windowDialogReceiver.js?language=zh_CN:33:41)
这个是什么原因，怎么解决

tutuke · 发表于 2015-3-18 14:32:53

<xhtml:div appearance="image-text" icon-class="icon-system-export" component="/UI/system/components/excel.xbl.xml#export" id="excelExport1" from="UI" data="dataMain" download-filename="自定义文件.xls"></xhtml:div>

源码如下

jishuang · 发表于 2015-3-18 15:43:27

把控制台完整的错误信息发一下

tutuke · 发表于 2015-3-18 16:08:02

控制台图片如下

tutuke · 发表于 2015-3-18 16:11:22

2015-03-18 15:33:56 加载模块：/UI/portal2/process/portal ...
2015-03-18 15:33:56 加载模块：/UI/system/resources ...
2015-03-18 15:33:56 加载模块：/UI/system/resources
2015-03-18 15:33:56 加载模块：/UI/portal2/process/portal
2015-03-18 15:34:03 加载模块：/system/logic/code/interceptor ...
2015-03-18 15:34:05 加载模块：/portal2/process/portal ...
2015-03-18 15:34:05 加载模块：/portal2/process ...
2015-03-18 15:34:05 加载模块：/portal2 ...
2015-03-18 15:34:05 加载模块：/portal2/logic/action ...
2015-03-18 15:34:05 加载模块：/portal2/logic ...
2015-03-18 15:34:05 加载模块：/portal2/ontology ...
2015-03-18 15:34:05 加载模块：/portal2/data ...
2015-03-18 15:34:05 加载模块：/portal2/logic/code ...
2015-03-18 15:34:07 加载模块：/wlbtest/wlbgzgl/process/wlbgzgl ...
2015-03-18 15:34:07 加载模块：/wlbtest/wlbgzgl/process ...
2015-03-18 15:34:07 加载模块：/wlbtest/wlbgzgl ...
2015-03-18 15:34:07 加载模块：/wlbtest ...
2015-03-18 15:34:08 加载模块：/wlbtest/wlbgzgl/logic/code ...
2015-03-18 15:34:08 加载模块：/wlbtest/wlbgzgl/logic ...
2015-03-18 15:34:08 加载模块：/wlbtest/wlbgzgl/data ...
2015-03-18 15:34:08 加载模块：/wlbtest/wlbgzgl/ontology ...
2015-03-18 15:34:08 加载模块：/wlbtest/wlbgzgl/logic/action ...
2015-03-18 15:34:08 加载模块：/SA/excel/logic/action ...
2015-03-18 15:34:08 加载模块：/SA/excel/logic ...
2015-03-18 15:34:08 加载模块：/SA/excel ...
2015-03-18 15:34:08 加载模块：/SA/theme/ontology ...
2015-03-18 15:34:08 加载模块：/SA/theme ...
2015-03-18 15:34:08 加载模块：/SA/excel/logic/code ...
2015-03-18 15:34:08 加载模块：/UI/wlbtest/wlbgzgl/process/wlbgzgl ...
2015-03-18 15:34:08 加载模块：/UI/wlbtest/wlbgzgl/process/wlbgzgl
2015-03-18 15:34:08 加载模块：/UI/system/service/common ...
2015-03-18 15:34:08 加载模块：/UI/system/service/common
2015-03-18 15:34:11 加载模块：/UI/system/components/excel/export ...
2015-03-18 15:34:11 加载模块：/UI/system/components/excel/export
2015-03-18 15:34:45 加载模块：/SA/filterPattern ...
Table2Row-------->0ms
2015-03-18 15:42:17 Not registed session:70141DD8C8271DEDA983D5E0D1C55AE7, jsess
ionid:JSESSIONID=E81CEEFD07AED2C8E0D52666A5EA6AB5, action: <?xml version="1.0" e
ncoding="UTF-8"?>
<action direct-execute="true" process="/wlbtest/wlbgzgl/process/wlbgzgl/wlbgzglP
rocess" activity="mainActivity" action-flag="__action_0__" executor="ADE98B534AF
84D268622CFD0DD08E6BF" execute-context="" name="closeActivityAction"/>
2015-03-18 16:07:08 加载模块：/SA/excel/system ...
2015-03-18 16:07:08 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/SA/excel/system/systemProcess" activity
="mainActivity" action-flag="__action_0__" executor="ADE98B534AF84D268622CFD0DD0
8E6BF" execute-context="" name="exportExcel"><parameters xmlns:xbiz="http://www.
justep.com/xbiz#"><parameter name="from"><xbiz:simple type="http://www.w3.org/20
01/XMLSchema#String"><![CDATA[UI]]></xbiz:simple></parameter><parameter name="co
nfig"><xbiz:xml><root><config><show-label>true</show-label><start-row>1</start-r
ow></config><concept><relation metaName="fJFMC" metaLabel="机房名称" width="" me
taCellNo="1" type="String" excelCellNo="1"/><relation metaName="fSBXH" metaLabel
="设备型号" width="" metaCellNo="2" type="String" excelCellNo="2"/><relation met
aName="fSBGS" metaLabel="设备个数" width="" metaCellNo="3" type="Integer" excelC
ellNo="3"/><relation metaName="fGLMC" metaLabel="光缆名称" width="" metaCellNo="
4" type="String" excelCellNo="4"/><relation metaName="fGLXS" metaLabel="光缆芯数
" width="" metaCellNo="5" type="String" excelCellNo="5"/><relation metaName="fJS
SJ" metaLabel="建设时间" width="" metaCellNo="6" type="Date" excelCellNo="6"/></
concept></root></xbiz:xml></parameter><parameter name="data"><xbiz:table><rows><
userdata name="idColumnDefine">WL_GZPCCZW</userdata><userdata name="idColumnName
">WL_GZPCCZW</userdata><userdata name="idColumnType">String</userdata><userdata
name="model">/wlbtest/wlbgzgl/data</userdata><userdata name="relationAlias">fJFM
C,fSBXH,fSBGS,fGLMC,fGLXS,fJSSJ,space-column,version</userdata><userdata name="r
elationTypes">String,String,Integer,String,String,Date,String,Integer</userdata>
<userdata name="relations">WL_GZPCCZW.fJFMC,WL_GZPCCZW.fSBXH,WL_GZPCCZW.fSBGS,WL
_GZPCCZW.fGLMC,WL_GZPCCZW.fGLXS,WL_GZPCCZW.fJSSJ,EXPRESS,WL_GZPCCZW.version</use
rdata><userdata name="sys.count">2</userdata><userdata name="sys.rowid">WL_GZPCC
ZW</userdata><userdata name="updateMode">whereVersion</userdata><userdata name="
concept">WL_GZPCCZW</userdata><userdata name="concept-alias">WL_GZPCCZW</userdat
a><userdata name="id-column-name">WL_GZPCCZW</userdata><userdata name="id-column
-type">String</userdata><userdata name="id-column-define">WL_GZPCCZW</userdata><
userdata name="relation-alias">fJFMC,fSBXH,fSBGS,fGLMC,fGLXS,fJSSJ,space-column,
version</userdata><userdata name="relation-types">String,String,Integer,String,S
tring,Date,Object,Integer</userdata><userdata name="update-mode">whereVersion</u
serdata><row id="01CDA9F6361D42D3A1537FF9D252C28C" original-id="01CDA9F6361D42D3
A1537FF9D252C28C" selected="1"><cell original-value="%E6%B5%8B%E8%AF%95%E6%9C%BA
%E6%88%BF2">%E6%B5%8B%E8%AF%95%E6%9C%BA%E6%88%BF2</cell><cell original-value="OS
N%208800">OSN%208800</cell><cell original-value="44">44</cell><cell original-val
ue="%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B02">%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B02
</cell><cell original-value="5">5</cell><cell original-value="2015-01-08">2015-0
1-08</cell><cell original-value=""/><cell original-value="0">0</cell></row><row
id="7F3126C3A74147B4BB4F6F6E42A57A7D" original-id="7F3126C3A74147B4BB4F6F6E42A57
A7D"><cell original-value="%E6%B5%8B%E8%AF%95%E6%9C%BA%E6%88%BF1">%E6%B5%8B%E8%A
F%95%E6%9C%BA%E6%88%BF1</cell><cell original-value="OSN%208800">OSN%208800</cell
><cell original-value="3">3</cell><cell original-value="%E6%B5%8B%E8%AF%95%E5%90
%8D%E7%A7%B0">%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B0</cell><cell original-value="4
">4</cell><cell original-value="2015-01-01">2015-01-01</cell><cell original-valu
e=""/><cell original-value="0">0</cell></row></rows></xbiz:table></parameter></p
arameters></action>
com.justep.exception.BusinessException: 编码: JUSTEP150079; 提示: 行状态不允许为
空, "<row id="01CDA9F6361D42D3A1537FF9D252C28C" original-id="01CDA9F6361D42D3A15
37FF9D252C28C" selected="1"><cell original-value="%E6%B5%8B%E8%AF%95%E6%9C%BA%E6
%88%BF2">%E6%B5%8B%E8%AF%95%E6%9C%BA%E6%88%BF2</cell><cell original-value="OSN%2
08800">OSN%208800</cell><cell original-value="44">44</cell><cell original-value=
"%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B02">%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B02</c
ell><cell original-value="5">5</cell><cell original-value="2015-01-08">2015-01-0
8</cell><cell original-value=""/><cell original-value="0">0</cell></row>"
      at com.justep.exception.BusinessException.create(Unknown Source)
      at com.justep.system.transform.Row2Table.createRow(Unknown Source)
      at com.justep.system.transform.Row2Table.transform(Unknown Source)
      at com.justep.system.transform.ParameterTransform.transTableParam(Unknow
n Source)
      at com.justep.system.transform.ParameterTransform.transParam(Unknown Sou
rce)
      at com.justep.system.transform.ParameterTransform.helpTransformByElement
(Unknown Source)
      at com.justep.system.transform.ParameterTransform.transform(Unknown Sour
ce)
      at com.justep.system.transform.RequestTransform.transParamValue(Unknown
Source)
      at com.justep.system.transform.RequestTransform.transActionParams(Unknow
n 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 Sour
ce)
      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(Appl
icationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
      at java.lang.Thread.run(Thread.java:745)

jishuang · 发表于 2015-3-18 17:20:19

行id为01CDA9F6361D42D3A1537FF9D252C28C的这行数据是怎么添加的？把这条数据删除了看看

tutuke · 发表于 2015-3-19 14:39:08

jishuang 发表于 2015-3-18 17:20
行id为01CDA9F6361D42D3A1537FF9D252C28C的这行数据是怎么添加的？把这条数据删除了看看 ...

删了，一样还是不行。

2015-03-19 14:39:03 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/SA/excel/system/systemProcess" activity
="mainActivity" action-flag="__action_0__" executor="ADE98B534AF84D268622CFD0DD0
8E6BF" execute-context="" name="exportExcel"><parameters xmlns:xbiz="http://www.
justep.com/xbiz#"><parameter name="from"><xbiz:simple type="http://www.w3.org/20
01/XMLSchema#String"><![CDATA[UI]]></xbiz:simple></parameter><parameter name="co
nfig"><xbiz:xml><root><config><show-label>true</show-label><start-row>1</start-r
ow></config><concept><relation metaName="fJFMC" metaLabel="机房名称" width="" me
taCellNo="1" type="String" excelCellNo="1"/><relation metaName="fSBXH" metaLabel
="设备型号" width="" metaCellNo="2" type="String" excelCellNo="2"/><relation met
aName="fSBGS" metaLabel="设备个数" width="" metaCellNo="3" type="Integer" excelC
ellNo="3"/><relation metaName="fGLMC" metaLabel="光缆名称" width="" metaCellNo="
4" type="String" excelCellNo="4"/><relation metaName="fGLXS" metaLabel="光缆芯数
" width="" metaCellNo="5" type="String" excelCellNo="5"/><relation metaName="fJS
SJ" metaLabel="建设时间" width="" metaCellNo="6" type="Date" excelCellNo="6"/></
concept></root></xbiz:xml></parameter><parameter name="data"><xbiz:table><rows><
userdata name="idColumnDefine">WL_GZPCCZW</userdata><userdata name="idColumnName
">WL_GZPCCZW</userdata><userdata name="idColumnType">String</userdata><userdata
name="model">/wlbtest/wlbgzgl/data</userdata><userdata name="relationAlias">fJFM
C,fSBXH,fSBGS,fGLMC,fGLXS,fJSSJ,space-column,version</userdata><userdata name="r
elationTypes">String,String,Integer,String,String,Date,String,Integer</userdata>
<userdata name="relations">WL_GZPCCZW.fJFMC,WL_GZPCCZW.fSBXH,WL_GZPCCZW.fSBGS,WL
_GZPCCZW.fGLMC,WL_GZPCCZW.fGLXS,WL_GZPCCZW.fJSSJ,EXPRESS,WL_GZPCCZW.version</use
rdata><userdata name="sys.count">2</userdata><userdata name="sys.rowid">WL_GZPCC
ZW</userdata><userdata name="updateMode">whereVersion</userdata><userdata name="
concept">WL_GZPCCZW</userdata><userdata name="concept-alias">WL_GZPCCZW</userdat
a><userdata name="id-column-name">WL_GZPCCZW</userdata><userdata name="id-column
-type">String</userdata><userdata name="id-column-define">WL_GZPCCZW</userdata><
userdata name="relation-alias">fJFMC,fSBXH,fSBGS,fGLMC,fGLXS,fJSSJ,space-column,
version</userdata><userdata name="relation-types">String,String,Integer,String,S
tring,Date,Object,Integer</userdata><userdata name="update-mode">whereVersion</u
serdata><row id="7F3126C3A74147B4BB4F6F6E42A57A7D" original-id="7F3126C3A74147B4
BB4F6F6E42A57A7D" selected="1"><cell original-value="%E6%B5%8B%E8%AF%95%E6%9C%BA
%E6%88%BF1">%E6%B5%8B%E8%AF%95%E6%9C%BA%E6%88%BF1</cell><cell original-value="OS
N%208800">OSN%208800</cell><cell original-value="3">3</cell><cell original-value
="%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B0">%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B0</ce
ll><cell original-value="4">4</cell><cell original-value="2015-01-01">2015-01-01
</cell><cell original-value=""/><cell original-value="0">0</cell></row></rows></
xbiz:table></parameter></parameters></action>
com.justep.exception.BusinessException: 编码: JUSTEP150079; 提示: 行状态不允许为
空, "<row id="7F3126C3A74147B4BB4F6F6E42A57A7D" original-id="7F3126C3A74147B4BB4
F6F6E42A57A7D" selected="1"><cell original-value="%E6%B5%8B%E8%AF%95%E6%9C%BA%E6
%88%BF1">%E6%B5%8B%E8%AF%95%E6%9C%BA%E6%88%BF1</cell><cell original-value="OSN%2
08800">OSN%208800</cell><cell original-value="3">3</cell><cell original-value="%
E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B0">%E6%B5%8B%E8%AF%95%E5%90%8D%E7%A7%B0</cell>
<cell original-value="4">4</cell><cell original-value="2015-01-01">2015-01-01</c
ell><cell original-value=""/><cell original-value="0">0</cell></row>"
      at com.justep.exception.BusinessException.create(Unknown Source)
      at com.justep.system.transform.Row2Table.createRow(Unknown Source)
      at com.justep.system.transform.Row2Table.transform(Unknown Source)
      at com.justep.system.transform.ParameterTransform.transTableParam(Unknow
n Source)
      at com.justep.system.transform.ParameterTransform.transParam(Unknown Sou
rce)
      at com.justep.system.transform.ParameterTransform.helpTransformByElement
(Unknown Source)
      at com.justep.system.transform.ParameterTransform.transform(Unknown Sour
ce)
      at com.justep.system.transform.RequestTransform.transParamValue(Unknown
Source)
      at com.justep.system.transform.RequestTransform.transActionParams(Unknow
n 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 Sour
ce)
      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(Appl
icationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
      at java.lang.Thread.run(Thread.java:745)

jishuang · 发表于 2015-3-19 15:18:35

你的这些数据都是怎么添加的？

tutuke · 发表于 2015-3-19 15:32:50

jishuang 发表于 2015-3-19 15:18
你的这些数据都是怎么添加的？

正常添加的啊，做了应用，添加了个测试数据
刚才删也是通过界面删的,添加删除都测试正常的啊

tutuke · 发表于 2015-3-19 15:35:16

jishuang 发表于 2015-3-19 15:18
你的这些数据都是怎么添加的？

可以了，我数据都删掉，重新建就可以了，请结帖，谢谢

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

[结贴] excel导出失败