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

QQ登录

只需一步,快速开始

查看: 5907|回复: 11

[结贴] excel导入又不行了。。。

[复制链接]

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
发表于 2017-8-9 11:31:23 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
后台报错是这样的!

2017-08-09 11:19:24
javax.servlet.ServletException: excel导入上载文件失败
        at Upload.execute(Upload.java:42)
        at com.justep.ui.JavaServer.runJava(Unknown Source)
        at com.justep.ui.JavaServer.doJ(Unknown Source)
        at com.justep.ui.JavaServer.service(Native Method)
        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.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(FileInputStream.java:195)
        at java.io.FileInputStream.<init>(FileInputStream.java:138)
        at java.io.FileInputStream.<init>(FileInputStream.java:93)
        at Upload.generateParts(Upload.java:82)
        at Upload.execute(Upload.java:33)
        ... 20 more
八月 09, 2017 11:19:24 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(FileInputStream.java:195)
        at java.io.FileInputStream.<init>(FileInputStream.java:138)
        at java.io.FileInputStream.<init>(FileInputStream.java:93)
        at Upload.generateParts(Upload.java:82)
        at Upload.execute(Upload.java:33)
        at com.justep.ui.JavaServer.runJava(Unknown Source)
        at com.justep.ui.JavaServer.doJ(Unknown Source)
        at com.justep.ui.JavaServer.service(Native Method)
        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)

2017-08-09 11:19:24 编码: JUSTEP002026; 提示: .J(/UI2/system/components/justep/excel/server/upload.j)执行失败
javax.servlet.ServletException: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/system/components/justep/excel/server/upload.j)执行失败
        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: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/system/components/justep/excel/server/upload.j)执行失败
        at com.justep.ui.exception.UIException.create(Unknown Source)
        at com.justep.ui.JavaServer.doJ(Unknown Source)
        at com.justep.ui.JavaServer.service(Native Method)
        ... 17 more
Caused by: javax.servlet.ServletException: excel导入上载文件失败
        at Upload.execute(Upload.java:42)
        at com.justep.ui.JavaServer.runJava(Unknown Source)
        ... 19 more
Caused by: java.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(FileInputStream.java:195)
        at java.io.FileInputStream.<init>(FileInputStream.java:138)
        at java.io.FileInputStream.<init>(FileInputStream.java:93)
        at Upload.generateParts(Upload.java:82)
        at Upload.execute(Upload.java:33)
        ... 20 more


91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2017-8-9 14:05:46 | 显示全部楼层
java.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)

确认目录是否有权限操作
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
 楼主| 发表于 2017-8-9 14:09:09 | 显示全部楼层
jishuang 发表于 2017-8-9 14:05
java.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)

确认目录是否有权限操作 ...

有的,不然怎么进界面呢
回复 支持 反对

使用道具 举报

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
 楼主| 发表于 2017-8-9 14:16:59 | 显示全部楼层
本帖最后由 zcgame 于 2017-8-9 14:18 编辑
jishuang 发表于 2017-8-9 14:05
java.io.FileNotFoundException: D:\BeX5.3.7\model (拒绝访问。)

确认目录是否有权限操作 ...

然后我重启了服务器,再导入测试现在web是报null错误,后台是报这个 02688钻展.jpg
2017-08-09 14:09:25 excute stream action, params:{"accept":"application/json","action":"importExcel","actionFlag":"__action_0__","activity":"UserActivity1","contentType":"json","executeContext":"","executor":"","parameters":{"config":{"@type":"xml","xml":"<config use-default=\"true\" to=\"UI\" excel-file=\"D:\\BeX5.3.7\\apache-tomcat\\temp\\7f694501-6c93-437f-a3f7-39bc8dafebc1.excel.tmp\" mapping-file=\"D:\\BeX5.3.7\\apache-tomcat\\temp\\8e6b902f-0b4f-47c0-aee5-289d622a5de2.excel.tmp\"><data><concept name=\"TBK_TaokeResult\"><relation name=\"TBK_TaokeResult\" type=\"String\"/><relation name=\"calcCheckBox\" type=\"String\"/><relation name=\"fCommission\" type=\"Float\"/><relation name=\"fContact\" type=\"String\"/><relation name=\"fEndTime\" type=\"Date\"/><relation name=\"fGetTime\" type=\"Date\"/><relation name=\"fMoney\" type=\"String\"/><relation name=\"fName\" type=\"String\"/><relation name=\"fOrderNum\" type=\"String\"/><relation name=\"fPlan\" type=\"String\"/><relation name=\"fPrice\" type=\"String\"/><relation name=\"fShop\" type=\"String\"/><relation name=\"fStartTime\" type=\"Date\"/><relation name=\"fVol\" type=\"Integer\"/><relation name=\"version\" type=\"Integer\"/></concept></data></config>"},"createActionParam":{"action":"createTBK_TaokeResultAction","activity":"UserActivity1","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"TBK_TaokeResult","idColumnName":"TBK_TaokeResult","idColumnType":"String","model":"/TBK/TaokeResult/data","relationAlias":"fCommission,fContact,fEndTime,fGetTime,fMoney,fName,fOrderNum,fPlan,fPrice,fShop,fStartTime,fVol,version","relationTypes":"Float,String,Date,Date,String,String,String,String,String,String,Date,Integer,Integer","relations":"TBK_TaokeResult.fCommission,TBK_TaokeResult.fContact,TBK_TaokeResult.fEndTime,TBK_TaokeResult.fGetTime,TBK_TaokeResult.fMoney,TBK_TaokeResult.fName,TBK_TaokeResult.fOrderNum,TBK_TaokeResult.fPlan,TBK_TaokeResult.fPrice,TBK_TaokeResult.fShop,TBK_TaokeResult.fStartTime,TBK_TaokeResult.fVol,TBK_TaokeResult.version","updateMode":"whereVersion"}}},"process":"/TBK/TaokeResult/process/TaokeResult/taokeResultProcess"}},"process":"/TBK/TaokeResult/process/TaokeResult/taokeResultProcess"}
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.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.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:121)
        at Excel.importExcel(Excel.java:88)
        ... 27 more
Caused by: java.lang.NullPointerException
        at TaokeResultProcess.taokeResultProcessAfterImportExcelBeforeAction(TaokeResultProcess.java:27)
        ... 37 more



回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2017-8-9 15:11:10 | 显示全部楼层
Caused by: java.lang.NullPointerException
        at TaokeResultProcess.taokeResultProcessAfterImportExcelBeforeAction(TaokeResultProcess.java:27)

自己的java代码中有问题,调试跟踪java代码
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
 楼主| 发表于 2017-8-9 15:29:36 | 显示全部楼层
本帖最后由 zcgame 于 2017-8-9 15:42 编辑
jishuang 发表于 2017-8-9 15:11
Caused by: java.lang.NullPointerException
        at TaokeResultProcess.taokeResultProcessAfterImpor ...

泣血啊,这个不是之前出过的,http://bbs.wex5.com/forum.php?mo ... 76707&extra=&page=3

就是这里反应的后来换个excel版本解决的,那我现在还是用2003呀,怎么又不行了。时好时坏呀。帮帮我吧,这次真不知道哪里有问题啊,java之前那次就全查过的
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2017-8-9 16:13:41 | 显示全部楼层
把java文件发一下
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
 楼主| 发表于 2017-8-9 17:10:14 | 显示全部楼层
本帖最后由 zcgame 于 2017-8-9 17:27 编辑
jishuang 发表于 2017-8-9 16:13
把java文件发一下

TaokeResultProcess.zip (1.01 KB, 下载次数: 55)
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2017-8-9 17:43:15 | 显示全部楼层
java调试Cell fOrderNum = row.getCell(9);获取到了吗?
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

59

主题

264

帖子

386

积分

中级会员

Rank: 3Rank: 3

积分
386
QQ
 楼主| 发表于 2017-8-9 17:55:51 | 显示全部楼层
jishuang 发表于 2017-8-9 17:43
java调试Cell fOrderNum = row.getCell(9);获取到了吗?

能的,对第10列进行校验,发现execl导入的数据:编码36939250773257674在当前Excel表中重复
这个都打印出来了,说明这个编码是能的
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-11-25 18:47 , Processed in 0.055587 second(s), 27 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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