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

QQ登录

只需一步,快速开始

查看: 9566|回复: 1

[处理中3] 导入excl 失败

[复制链接]

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
发表于 2021-10-14 15:52:10 | 显示全部楼层 |阅读模式
版本: BeX5V3.5 小版本号:
数据库: Oracle 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 其它 浏览器: Chrome
本帖最后由 tianhaoweiUp 于 2021-10-15 10:02 编辑

Error: __justepServerErrorStart__{"message":"","reason":"","code":"JUSTEP170005","stack":"java.lang.reflect.InvocationTargetException\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)\n\tat org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)\n\tat org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)\n\tat org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)\n\tat com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat com.justep.dbproxy.DbProxyHelper.doFilter(DbProxyHelper.java:625)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat com.justep.sso.uaa.client.SsoClientFilter.doFilter(Unknown Source)\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\n\tat org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\n\tat org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:685)\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\n\tat org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)\n\tat org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\n\tat org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)\n\tat org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: com.justep.excel.ExcelException: 编码: JUSTEP170005; 提示: \n\tat com.justep.excel.ExcelException.create(ExcelException.java:32)\n\tat com.justep.excel.ImportGenerator.LoadExcel(ImportGenerator.java:68)\n\tat com.justep.excel.ImportGenerator.init(ImportGenerator.java:58)\n\tat com.justep.excel.ImportGenerator.generate(ImportGenerator.java:109)\n\tat Excel.importExcel(Excel.java:89)\n\t... 51 more\nCaused by: java.io.FileNotFoundException: /usr/local/tomcat/temp/24a4d831-31d8-448f-bca1-52127bfd41c0.excel.tmp (No such file or directory)\n\tat java.io.FileInputStream.open0(Native Method)\n\tat java.io.FileInputStream.open(FileInputStream.java:195)\n\tat java.io.FileInputStream.<init>(FileInputStream.java:138)\n\tat java.io.FileInputStream.<init>(FileInputStream.java:93)\n\tat com.justep.excel.ImportGenerator.LoadExcel(ImportGenerator.java:64)\n\t... 54 more\n","messages":["编码: JUSTEP170005; 提示: ","/usr/local/tomcat/temp/24a4d831-31d8-448f-bca1-52127bfd41c0.excel.tmp (No such file or directory)"],"url":"/x5/UI2/v_a1634152152638l_zh_CNs_desktopd_pc/system/service/common/bizAction.j","param":{"contentType":"json","accept":"application/json","process":"/PM/WuZiGuanLi/process/xiaoHaoCaiLiaoZhuanXiangCaiGouWuZiJinChang/xiaoHaoCaiLiaoZhuanXiangCaiGouWuZiJinChangProcess","activity":"caiLiaoYuanTianBaoBusActivity","actionFlag":"__action_0__","executor":"/CD3E5428DEB242F085D76FDDDD337503.ogn/2E80D2DF20484B3F8DAAAC28C90D6FCF.ogn/C1EB2966F3D6448EA8AD10E44EE52C0E.ogn/91797BF3F7EE4EC184704592D82245B3.dpt/9411A679633D4901914BC72FD50173AB.pos/27206DDFABFD4E529B70E6E54BDE0B77@9411A679633D4901914BC72FD50173AB.psm","executeContext":"","action":"importExcel","parameters":{"config":{"@type":"xml","xml":"<config use-default=\"true\" to=\"UI\" excel-file=\"/usr/local/tomcat/temp/24a4d831-31d8-448f-bca1-52127bfd41c0.excel.tmp\" mapping-file=\"/usr/local/tomcat/temp/c4eec164-8c97-4f28-bcb2-8e02ed49fcb4.excel.tmp\"><data><concept name=\"GSPM_WuZiJinChangWuZiXX_CB\"><relation name=\"fPanYingShuLiang\" type=\"Decimal\"/><relation name=\"fShangWuKeMu\" type=\"String\"/><relation name=\"fCanWuKeMuBianMa\" type=\"String\"/><relation name=\"fCaiWuKeMuFName\" type=\"String\"/><relation name=\"fCaiWuKeMuJiCiMa\" type=\"String\"/><relation name=\"fJinChangBianHao\" type=\"String\"/><relation name=\"sCreatorID\" type=\"String\"/><relation name=\"fPanKuiShuLiang\" type=\"Decimal\"/><relation name=\"fShiGongZhuanYeID\" type=\"String\"/><relation name=\"fWuZiMingCheng\" type=\"String\"/><relation name=\"fZengZhiShuiShuiLv\" type=\"Decimal\"/><relation name=\"fCaiWuKeMuID\" type=\"String\"/><relation name=\"fJingChangDanJia\" type=\"Decimal\"/><relation name=\"sCreateTime\" type=\"DateTime\"/><relation name=\"fDiaoBoShuLiang\" type=\"Decimal\"/><relation name=\"fXDQHTMC\" type=\"String\"/><relation name=\"fHeTongMXID\" type=\"String\"/><relation name=\"fTuiChangShuLiang\" type=\"Decimal\"/><relation name=\"sOrgFName\" type=\"String\"/><relation name=\"fRrea\" type=\"String\"/><relation name=\"fShuiE\" type=\"Decimal\"/><relation name=\"sCreatorOgnName\" type=\"String\"/><relation name=\"fGuiGeNull\" type=\"Integer\"/><relation name=\"fCaiZhiNull\" type=\"Integer\"/><relation name=\"version\" type=\"Integer\"/><relation name=\"fCaiZhi\" type=\"String\"/><relation name=\"sCreatorPosID\" type=\"String\"/><relation name=\"sCreatorName\" type=\"String\"/><relation name=\"sLastModifyTime\" type=\"DateTime\"/><relation name=\"fWuZiJieSuanHeTong\" type=\"String\"/><relation name=\"fFuKuanZhuangTai\" type=\"String\"/><relation name=\"sCreatorDeptID\" type=\"String\"/><relation name=\"fPinPaiNull\" type=\"Integer\"/><relation name=\"fHanShuiDanJia\" type=\"Decimal\"/><relation name=\"fShiGongZhuanYeBianMa\" type=\"String\"/><relation name=\"fGongFangMingCheng\" type=\"String\"/><relation name=\"sCreatorDeptName\" type=\"String\"/><relation name=\"fJinChangDanID1\" type=\"String\"/><relation name=\"sCreatorPosName\" type=\"String\"/><relation name=\"fChuKuShuLiang\" type=\"Decimal\"/><relation name=\"fShiWuZanCunShuLiang\" type=\"Decimal\"/><relation name=\"fShangWuKeMuID\" type=\"String\"/><relation name=\"fShiGongZhuanYe\" type=\"String\"/><relation name=\"fRreaNull\" type=\"Integer\"/><relation name=\"fGXKTMC\" type=\"String\"/><relation name=\"fJiaShuiHeJi\" type=\"Decimal\"/><relation name=\"fJinChangRiQi\" type=\"Date\"/><relation name=\"fShangWuKeMuFName\" type=\"String\"/><relation name=\"fYouXiaoKuCunLiang\" type=\"Decimal\"/><relation name=\"fHeTongLeiXing\" type=\"String\"/><relation name=\"fCaiWuKeMuFID\" type=\"String\"/><relation name=\"fJinE\" type=\"Decimal\"/><relation name=\"fShangWuKeMuJiCiMa\" type=\"String\"/><relation name=\"fDanWei\" type=\"String\"/><relation name=\"fJinChangShuLiang\" type=\"Decimal\"/><relation name=\"sOrgFID\" type=\"String\"/><relation name=\"fBiaoZhunHeTongName\" type=\"String\"/><relation name=\"fDanWeiNull\" type=\"Integer\"/><relation name=\"sLastWriterFID\" type=\"String\"/><relation name=\"GSPM_WuZiJinChangWuZiXX_CB\" type=\"String\"/><relation name=\"fCaiWuKeMuFCode\" type=\"String\"/><relation name=\"fGuiGeXingHao\" type=\"String\"/><relation name=\"fShangWuKeMuBianMa\" type=\"String\"/><relation name=\"fYanShouDanHao\" type=\"String\"/><relation name=\"fShunXuHao\" type=\"Integer\"/><relation name=\"fXDQHTBH\" type=\"String\"/><relation name=\"fShangWuKeMuFCode\" type=\"String\"/><relation name=\"fCaiWuKeMu\" type=\"String\"/><relation name=\"fWuZiBianMa\" type=\"String\"/><relation name=\"fPinPai\" type=\"String\"/><relation name=\"fShiFouKetiaoJia\" type=\"String\"/><relation name=\"fBianMaMingCheng\" type=\"String\"/><relation name=\"fWuZiBieMing\" type=\"String\"/><relation name=\"fShangWuKeMuFID\" type=\"String\"/><relation name=\"sLastWriterName\" type=\"String\"/><relation name=\"fSFSJGXKT\" type=\"String\"/><relation name=\"fBiaoZhunHeTongCode\" type=\"String\"/><relation name=\"sCreatorOgnID\" type=\"String\"/><relation name=\"fTuiKuShuLiang\" type=\"Decimal\"/></concept></data></config>"},"createActionParam":{"process":"/PM/WuZiGuanLi/process/xiaoHaoCaiLiaoZhuanXiangCaiGouWuZiJinChang/xiaoHaoCaiLiaoZhuanXiangCaiGouWuZiJinChangProcess","activity":"caiLiaoYuanTianBaoBusActivity","action":"createGSPM_WuZiJinChangWuZiXX_CBAction","parameters":{"table":{"@type":"table","rows":[],"userdata":{"idColumnDefine":"GSPM_WuZiJinChangWuZiXX_CB","idColumnName":"GSPM_WuZiJinChangWuZiXX_CB","idColumnType":"String","model":"/PM/WuZiGuanLi/data","relationAlias":"fPanYingShuLiang,fShangWuKeMu,fCanWuKeMuBianMa,fCaiWuKeMuFName,fCaiWuKeMuJiCiMa,fJinChangBianHao,sCreatorID,fPanKuiShuLiang,fShiGongZhuanYeID,fWuZiMingCheng,fZengZhiShuiShuiLv,fCaiWuKeMuID,fJingChangDanJia,sCreateTime,fDiaoBoShuLiang,fXDQHTMC,fHeTongMXID,fTuiChangShuLiang,sOrgFName,fRrea,fShuiE,sCreatorOgnName,fGuiGeNull,fCaiZhiNull,version,fCaiZhi,sCreatorPosID,sCreatorName,sLastModifyTime,fWuZiJieSuanHeTong,fFuKuanZhuangTai,sCreatorDeptID,fPinPaiNull,fHanShuiDanJia,fShiGongZhuanYeBianMa,fGongFangMingCheng,sCreatorDeptName,fJinChangDanID1,sCreatorPosName,fChuKuShuLiang,fShiWuZanCunShuLiang,fShangWuKeMuID,fShiGongZhuanYe,fRreaNull,fGXKTMC,fJiaShuiHeJi,fJinChangRiQi,fShangWuKeMuFName,fYouXiaoKuCunLiang,fHeTongLeiXing,fCaiWuKeMuFID,fJinE,fShangWuKeMuJiCiMa,fDanWei,fJinChangShuLiang,sOrgFID,fBiaoZhunHeTongName,fDanWeiNull,sLastWriterFID,fCaiWuKeMuFCode,fGuiGeXingHao,fShangWuKeMuBianMa,fYanShouDanHao,fShunXuHao,fXDQHTBH,fShangWuKeMuFCode,fCaiWuKeMu,fWuZiBianMa,fPinPai,fShiFouKetiaoJia,fBianMaMingCheng,fWuZiBieMing,fShangWuKeMuFID,sLastWriterName,fSFSJGXKT,fBiaoZhunHeTongCode,sCreatorOgnID,fTuiKuShuLiang","relationTypes":"Decimal,String,String,String,String,String,String,Decimal,String,String,Decimal,String,Decimal,DateTime,Decimal,String,String,Decimal,String,String,Decimal,String,Integer,Integer,Integer,String,String,String,DateTime,String,String,String,Integer,Decimal,String,String,String,String,String,Decimal,Decimal,String,String,Integer,String,Decimal,Date,String,Decimal,String,String,Decimal,String,String,Decimal,String,String,Integer,String,String,String,String,String,Integer,String,String,String,String,String,String,String,String,String,String,String,String,String,Decimal","relations":"GSPM_WuZiJinChangWuZiXX_CB.fPanYingShuLiang,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMu,GSPM_WuZiJinChangWuZiXX_CB.fCanWuKeMuBianMa,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMuFName,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMuJiCiMa,GSPM_WuZiJinChangWuZiXX_CB.fJinChangBianHao,GSPM_WuZiJinChangWuZiXX_CB.sCreatorID,GSPM_WuZiJinChangWuZiXX_CB.fPanKuiShuLiang,GSPM_WuZiJinChangWuZiXX_CB.fShiGongZhuanYeID,GSPM_WuZiJinChangWuZiXX_CB.fWuZiMingCheng,GSPM_WuZiJinChangWuZiXX_CB.fZengZhiShuiShuiLv,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMuID,GSPM_WuZiJinChangWuZiXX_CB.fJingChangDanJia,GSPM_WuZiJinChangWuZiXX_CB.sCreateTime,GSPM_WuZiJinChangWuZiXX_CB.fDiaoBoShuLiang,GSPM_WuZiJinChangWuZiXX_CB.fXDQHTMC,GSPM_WuZiJinChangWuZiXX_CB.fHeTongMXID,GSPM_WuZiJinChangWuZiXX_CB.fTuiChangShuLiang,GSPM_WuZiJinChangWuZiXX_CB.sOrgFName,GSPM_WuZiJinChangWuZiXX_CB.fRrea,GSPM_WuZiJinChangWuZiXX_CB.fShuiE,GSPM_WuZiJinChangWuZiXX_CB.sCreatorOgnName,GSPM_WuZiJinChangWuZiXX_CB.fGuiGeNull,GSPM_WuZiJinChangWuZiXX_CB.fCaiZhiNull,GSPM_WuZiJinChangWuZiXX_CB.version,GSPM_WuZiJinChangWuZiXX_CB.fCaiZhi,GSPM_WuZiJinChangWuZiXX_CB.sCreatorPosID,GSPM_WuZiJinChangWuZiXX_CB.sCreatorName,GSPM_WuZiJinChangWuZiXX_CB.sLastModifyTime,GSPM_WuZiJinChangWuZiXX_CB.fWuZiJieSuanHeTong,GSPM_WuZiJinChangWuZiXX_CB.fFuKuanZhuangTai,GSPM_WuZiJinChangWuZiXX_CB.sCreatorDeptID,GSPM_WuZiJinChangWuZiXX_CB.fPinPaiNull,GSPM_WuZiJinChangWuZiXX_CB.fHanShuiDanJia,GSPM_WuZiJinChangWuZiXX_CB.fShiGongZhuanYeBianMa,GSPM_WuZiJinChangWuZiXX_CB.fGongFangMingCheng,GSPM_WuZiJinChangWuZiXX_CB.sCreatorDeptName,GSPM_WuZiJinChangWuZiXX_CB.fJinChangDanID1,GSPM_WuZiJinChangWuZiXX_CB.sCreatorPosName,GSPM_WuZiJinChangWuZiXX_CB.fChuKuShuLiang,GSPM_WuZiJinChangWuZiXX_CB.fShiWuZanCunShuLiang,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuID,GSPM_WuZiJinChangWuZiXX_CB.fShiGongZhuanYe,GSPM_WuZiJinChangWuZiXX_CB.fRreaNull,GSPM_WuZiJinChangWuZiXX_CB.fGXKTMC,GSPM_WuZiJinChangWuZiXX_CB.fJiaShuiHeJi,GSPM_WuZiJinChangWuZiXX_CB.fJinChangRiQi,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuFName,GSPM_WuZiJinChangWuZiXX_CB.fYouXiaoKuCunLiang,GSPM_WuZiJinChangWuZiXX_CB.fHeTongLeiXing,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMuFID,GSPM_WuZiJinChangWuZiXX_CB.fJinE,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuJiCiMa,GSPM_WuZiJinChangWuZiXX_CB.fDanWei,GSPM_WuZiJinChangWuZiXX_CB.fJinChangShuLiang,GSPM_WuZiJinChangWuZiXX_CB.sOrgFID,GSPM_WuZiJinChangWuZiXX_CB.fBiaoZhunHeTongName,GSPM_WuZiJinChangWuZiXX_CB.fDanWeiNull,GSPM_WuZiJinChangWuZiXX_CB.sLastWriterFID,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMuFCode,GSPM_WuZiJinChangWuZiXX_CB.fGuiGeXingHao,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuBianMa,GSPM_WuZiJinChangWuZiXX_CB.fYanShouDanHao,GSPM_WuZiJinChangWuZiXX_CB.fShunXuHao,GSPM_WuZiJinChangWuZiXX_CB.fXDQHTBH,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuFCode,GSPM_WuZiJinChangWuZiXX_CB.fCaiWuKeMu,GSPM_WuZiJinChangWuZiXX_CB.fWuZiBianMa,GSPM_WuZiJinChangWuZiXX_CB.fPinPai,GSPM_WuZiJinChangWuZiXX_CB.fShiFouKetiaoJia,GSPM_WuZiJinChangWuZiXX_CB.fBianMaMingCheng,GSPM_WuZiJinChangWuZiXX_CB.fWuZiBieMing,GSPM_WuZiJinChangWuZiXX_CB.fShangWuKeMuFID,GSPM_WuZiJinChangWuZiXX_CB.sLastWriterName,GSPM_WuZiJinChangWuZiXX_CB.fSFSJGXKT,GSPM_WuZiJinChangWuZiXX_CB.fBiaoZhunHeTongCode,GSPM_WuZiJinChangWuZiXX_CB.sCreatorOgnID,GSPM_WuZiJinChangWuZiXX_CB.fTuiKuShuLiang","updateMode":"whereVersion"}},"defaultValues":{"fJinChangDanID1":"'FB0396F989804DEFAD4C53F6102A6D1D'"}}}},"translateParameter":null}}__justepServerErrorEnd__

我本地的环境 可以导入成功 正式环境 会报错



91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36067
发表于 2021-10-15 11:58:29 | 显示全部楼层
/usr/local/tomcat/temp/24a4d831-31d8-448f-bca1-52127bfd41c0.excel.tmp (No such file or directory)

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



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

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-11-23 20:27 , Processed in 0.066052 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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