起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › 报表报错，请问这个是什么错误呢
返回列表 发新帖
查看: 3999|回复: 6

[结贴] 报表报错，请问这个是什么错误呢

[复制链接]

179

主题

709

帖子

2090

积分

金牌会员

QQ:1262363236

Rank: 6Rank: 6

积分
2090
QQ
发表于 2017-3-7 14:34:43 | 显示全部楼层 |阅读模式
提示
/x5/UI2/v_d87774f5703d4046bc78c2ba7319a4b6l_zh_CNs_desktopd_pc/HR/salary/process/salaryCalculate/persionalSalaryCollect.w?$pageType=view HTTP status: 500
[url=]隐藏详细[/url]
Error: /x5/UI2/v_d87774f5703d4046bc78c2ba7319a4b6l_zh_CNs_desktopd_pc/HR/salary/process/salaryCalculate/persionalSalaryCollect.w?$pageType=view HTTP status: 500 at XMLHttpRequest.s.onreadystatechange (http://127.0.0.1:8080/x5/UI2/v_b ... core.min.js:71:2665)


QQ:1262363236
回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36180
发表于 2017-3-7 15:42:29 | 显示全部楼层
看tomcat控制台完整的错误信息
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

179

主题

709

帖子

2090

积分

金牌会员

QQ:1262363236

Rank: 6Rank: 6

积分
2090
QQ
 楼主| 发表于 2017-3-7 15:45:52 | 显示全部楼层
jishuang 发表于 2017-3-7 15:42
看tomcat控制台完整的错误信息

  --> sql:SELECT  SA_Task.sID AS SA_Task, SA_Task.SACTIVITY AS sActivity, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SEURL AS sEURL, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SKINDID AS sKindID, SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess, SA_Task.SSTATUSID AS sStatusID FROM SA_Task SA_Task  WHERE  ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND ( ?  LIKE SA_Task.SEXECUTORFID || ?) AND (SA_Task.SEXECUTORFID LIKE ?)   ORDER BY sCreateTime DESC
--> binds:[tesReady, tesExecuting, /ORG01.ogn/PSN01@ORG01.psm, %, /%]
2017-03-07 15:45:20 [KSQL Time]sql 执行时间：35ms, ksql:SELECT SA_Task.*  FROM SA_Task SA_Task WHERE ((SA_Task.sStatusID='tesReady' or SA_Task.sStatusID='tesExecuting')  and (:_efid0 like concat(SA_Task.sExecutorFID, '%')) and SA_Task.sExecutorFID like '/%' ) ORDER BY sCreateTime DESC LIMIT 0, 5
2017-03-07 15:45:21 Excel生成报表定义失败，文件名：E:/BeX5_V3.6_2/model/UI2/HR/salary/process/salaryCalculate/excel/personCollect.xml
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：E:/BeX5_V3.6_2/model/UI2/HR/salary/process/salaryCalculate/excel/personCollect.xml
        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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生成报表定义失败，文件名：E:/BeX5_V3.6_2/model/UI2/HR/salary/process/salaryCalculate/excel/personCollect.xml
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 17 more
Caused by: java.lang.RuntimeException: Excel生成报表定义失败
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        ... 31 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 7
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        ... 32 more
2017-03-07 15:45:21 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
三月 07, 2017 3:45:21 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 7
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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)
QQ:1262363236
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36180
发表于 2017-3-7 16:33:17 | 显示全部楼层
Excel生成报表定义失败，文件名：E:/BeX5_V3.6_2/model/UI2/HR/salary/process/salaryCalculate/excel/personCollect.xml


excel文件中定义有问题

如果是用grouph在excel上方多加几行空行看看
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

179

主题

709

帖子

2090

积分

金牌会员

QQ:1262363236

Rank: 6Rank: 6

积分
2090
QQ
 楼主| 发表于 2017-3-7 16:35:18 | 显示全部楼层
jishuang 发表于 2017-3-7 16:33
Excel生成报表定义失败，文件名：E:/BeX5_V3.6_2/model/UI2/HR/salary/process/salaryCalculate/excel/pers ...

我发现有几个字段加进去就会报错，如果只加2,3个字段就不会报错
QQ:1262363236
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36180
发表于 2017-3-7 16:55:28 | 显示全部楼层
如果是用grouph在excel上方多加几行空行看看
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

197

主题

834

帖子

1511

积分

金牌会员

Rank: 6Rank: 6

积分
1511
QQ
发表于 2017-12-4 16:46:29 | 显示全部楼层
jishuang 发表于 2017-3-7 16:55
如果是用grouph在excel上方多加几行空行看看

显示完整，，，感觉就像放大版的
QQ图片20171204164601.png
------回复内容仅供参考
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-6-29 22:50 , Processed in 0.100642 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表