grid导入excel报错

zdq · 发表于 2018-6-27 16:44:28

老师您好，请问BEX5 2.7版本我使用excel导入功能，控制台报错：
2018-06-27 16:22:15 开始-WINDOW生成中间文件: /UI/ICT/HeTGL/process/ZHongXICTXMQD/mainActivity.w
2018-06-27 16:22:16 结束-WINDOW生成中间文件: /UI/ICT/HeTGL/process/ZHongXICTXMQD/mainActivity.w
2018-06-27 16:22:16 开始-中间文件生成缓存文件: /UI/ICT/HeTGL/process/ZHongXICTXMQD/mainActivity.w
2018-06-27 16:22:16 结束-中间文件生成缓存文件: /UI/ICT/HeTGL/process/ZHongXICTXMQD/mainActivity.w
2018-06-27 16:22:59 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/SA/excel/system/systemProcess" activity="mainActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="importExcel"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="config"><xbiz:xml><config use-default="false" to="UI" excel-file="E:\ICT\ICT(20160811)\apache-tomcat\temp\4652e1ca-9f39-4911-a62a-6b7b5d84335b.tmp" mapping-file="E:\ICT\ICT(20160811)\apache-tomcat\temp\56698ab9-56a5-46ae-b03e-efae46e8061d.tmp"><sheet all="false" start="1" end="1"/><row all="true" start="1" end="1"/><data><concept name="TZHongXICTXMQD"><relation name="version" type="Integer"/><relation name="tfXiangMLY" type="String"/><relation name="tfXuH1" type="String"/><relation name="tfXuH2" type="String"/><relation name="tfXuH3" type="String"/><relation name="tfXiangMND" type="String"/><relation name="tfQianYZT" type="String"/><relation name="tfXiangMBH" type="String"/><relation name="tfYeWHTBH" type="String"/><relation name="tfLiuSH" type="String"/><relation name="tfERPBH" type="String"/><relation name="tfXiangMMC" type="String"/><relation name="tfKeHMC" type="String"/><relation name="tfYingXQY" type="String"/><relation name="tfHeTQYKHJL" type="String"/><relation name="tfSHouRHTEYHTXT" type="String"/><relation name="tfSHouRHTJJY" type="String"/><relation name="tfHeTTJSJ" type="String"/><relation name="tfHeTWCSPSJ" type="String"/><relation name="tfHeTGZSJ" type="String"/><relation name="tfHeTZT" type="String"/><relation name="tfHeTGZQRSJ" type="String"/><relation name="tfBenNQRSR" type="String"/><relation name="tfQiZFWSR" type="String"/><relation name="tfLeiJQRSR20132018" type="String"/><relation name="tfSHouRQRJD" type="String"/><relation name="tfBenNQRCB" type="String"/><relation name="tfQqZFWCB" type="String"/><relation name="tfLeiJQRCB" type="String"/><relation name="tfLeiJHK" type="String"/><relation name="tfHuiKBL" type="String"/><relation name="tfDangNHK" type="String"/><relation name="tfYingSZK" type="String"/><relation name="tfYingSZK3NN" type="String"/><relation name="tfDaoQYS" type="String"/><relation name="tfYiJTHZ" type="String"/><relation name="tfYuSZK" type="String"/><relation name="tfYingFZK" type="String"/><relation name="tfZHiZHTSFGD" type="String"/><relation name="tfZHiCJL" type="String"/><relation name="tfZHongBSJ" type="String"/><relation name="tfXiangMJL" type="String"/><relation name="tfZHiZJSWTXDSJ" type="String"/><relation name="tfJiHYSSJ" type="String"/><relation name="tfYanSSJ" type="String"/><relation name="tfCaiGJL" type="String"/><relation name="tfDianZCGXQXDSJ" type="String"/><relation name="tfCaiGZBWCSJ" type="String"/><relation name="tfCHengBHTWCQYSJ" type="String"/><relation name="tfYeWZCB" type="String"/><relation name="tfJianWB" type="String"/><relation name="tfCaiGB" type="String"/><relation name="tfYunYB" type="String"/><relation name="tfYiQCBHTJE" type="String"/><relation name="tfYiQCBHTJJ" type="String"/><relation name="tfCHengBZSBHS" type="String"/><relation name="tfYuJML" type="String"/><relation name="tfQianYML" type="String"/><relation name="tfLeiJQRML" type="String"/><relation name="tf2018NQRML" type="String"/><relation name="tf2018NFWML" type="String"/><relation name="tfSHiF4YSRJHXM" type="String"/><relation name="tf5Y7RHYXLS" type="String"/><relation name="tfWuSM" type="String"/><relation name="tfSHiFXYSLDZBQ" type="String"/><relation name="tfBuQNR" type="String"/><relation name="tfZHongDSRJHXM" type="String"/><relation name="tfXiangMZTSRD" type="String"/><relation name="tfITFWSR" type="String"/><relation name="tfITDSF" type="String"/><relation name="tfCT" type="String"/><relation name="space-column" type="Object"/></concept></data></config></xbiz:xml></parameter><parameter name="createActionParam"><xbiz:map><item key="process"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[/ICT/HeTGL/process/ZHongXICTXMQD/zHongXICTXMQDProcess]]></xbiz:simple></item><item key="activity"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[mainActivity]]></xbiz:simple></item><item key="action"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[createTZHongXICTXMQDAction]]></xbiz:simple></item><item key="parameters"><xbiz:map><item key="table"><xbiz:table><rows><userdata name="concept">TZHongXICTXMQD</userdata><userdata name="relations">TZHongXICTXMQD.version,TZHongXICTXMQD.tfXiangMLY,TZHongXICTXMQD.tfXuH1,TZHongXICTXMQD.tfXuH2,TZHongXICTXMQD.tfXuH3,TZHongXICTXMQD.tfXiangMND,TZHongXICTXMQD.tfQianYZT,TZHongXICTXMQD.tfXiangMBH,TZHongXICTXMQD.tfYeWHTBH,TZHongXICTXMQD.tfLiuSH,TZHongXICTXMQD.tfERPBH,TZHongXICTXMQD.tfXiangMMC,TZHongXICTXMQD.tfKeHMC,TZHongXICTXMQD.tfYingXQY,TZHongXICTXMQD.tfHeTQYKHJL,TZHongXICTXMQD.tfSHouRHTEYHTXT,TZHongXICTXMQD.tfSHouRHTJJY,TZHongXICTXMQD.tfHeTTJSJ,TZHongXICTXMQD.tfHeTWCSPSJ,TZHongXICTXMQD.tfHeTGZSJ,TZHongXICTXMQD.tfHeTZT,TZHongXICTXMQD.tfHeTGZQRSJ,TZHongXICTXMQD.tfBenNQRSR,TZHongXICTXMQD.tfQiZFWSR,TZHongXICTXMQD.tfLeiJQRSR20132018,TZHongXICTXMQD.tfSHouRQRJD,TZHongXICTXMQD.tfBenNQRCB,TZHongXICTXMQD.tfQqZFWCB,TZHongXICTXMQD.tfLeiJQRCB,TZHongXICTXMQD.tfLeiJHK,TZHongXICTXMQD.tfHuiKBL,TZHongXICTXMQD.tfDangNHK,TZHongXICTXMQD.tfYingSZK,TZHongXICTXMQD.tfYingSZK3NN,TZHongXICTXMQD.tfDaoQYS,TZHongXICTXMQD.tfYiJTHZ,TZHongXICTXMQD.tfYuSZK,TZHongXICTXMQD.tfYingFZK,TZHongXICTXMQD.tfZHiZHTSFGD,TZHongXICTXMQD.tfZHiCJL,TZHongXICTXMQD.tfZHongBSJ,TZHongXICTXMQD.tfXiangMJL,TZHongXICTXMQD.tfZHiZJSWTXDSJ,TZHongXICTXMQD.tfJiHYSSJ,TZHongXICTXMQD.tfYanSSJ,TZHongXICTXMQD.tfCaiGJL,TZHongXICTXMQD.tfDianZCGXQXDSJ,TZHongXICTXMQD.tfCaiGZBWCSJ,TZHongXICTXMQD.tfCHengBHTWCQYSJ,TZHongXICTXMQD.tfYeWZCB,TZHongXICTXMQD.tfJianWB,TZHongXICTXMQD.tfCaiGB,TZHongXICTXMQD.tfYunYB,TZHongXICTXMQD.tfYiQCBHTJE,TZHongXICTXMQD.tfYiQCBHTJJ,TZHongXICTXMQD.tfCHengBZSBHS,TZHongXICTXMQD.tfYuJML,TZHongXICTXMQD.tfQianYML,TZHongXICTXMQD.tfLeiJQRML,TZHongXICTXMQD.tf2018NQRML,TZHongXICTXMQD.tf2018NFWML,TZHongXICTXMQD.tfSHiF4YSRJHXM,TZHongXICTXMQD.tf5Y7RHYXLS,TZHongXICTXMQD.tfWuSM,TZHongXICTXMQD.tfSHiFXYSLDZBQ,TZHongXICTXMQD.tfBuQNR,TZHongXICTXMQD.tfZHongDSRJHXM,TZHongXICTXMQD.tfXiangMZTSRD,TZHongXICTXMQD.tfITFWSR,TZHongXICTXMQD.tfITDSF,TZHongXICTXMQD.tfCT,EXPRESS</userdata><userdata name="model">/ICT/HeTGL/data</userdata><userdata name="concept-alias">TZHongXICTXMQD</userdata><userdata name="id-column-name">TZHongXICTXMQD</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">TZHongXICTXMQD</userdata><userdata name="relation-alias">version,tfXiangMLY,tfXuH1,tfXuH2,tfXuH3,tfXiangMND,tfQianYZT,tfXiangMBH,tfYeWHTBH,tfLiuSH,tfERPBH,tfXiangMMC,tfKeHMC,tfYingXQY,tfHeTQYKHJL,tfSHouRHTEYHTXT,tfSHouRHTJJY,tfHeTTJSJ,tfHeTWCSPSJ,tfHeTGZSJ,tfHeTZT,tfHeTGZQRSJ,tfBenNQRSR,tfQiZFWSR,tfLeiJQRSR20132018,tfSHouRQRJD,tfBenNQRCB,tfQqZFWCB,tfLeiJQRCB,tfLeiJHK,tfHuiKBL,tfDangNHK,tfYingSZK,tfYingSZK3NN,tfDaoQYS,tfYiJTHZ,tfYuSZK,tfYingFZK,tfZHiZHTSFGD,tfZHiCJL,tfZHongBSJ,tfXiangMJL,tfZHiZJSWTXDSJ,tfJiHYSSJ,tfYanSSJ,tfCaiGJL,tfDianZCGXQXDSJ,tfCaiGZBWCSJ,tfCHengBHTWCQYSJ,tfYeWZCB,tfJianWB,tfCaiGB,tfYunYB,tfYiQCBHTJE,tfYiQCBHTJJ,tfCHengBZSBHS,tfYuJML,tfQianYML,tfLeiJQRML,tf2018NQRML,tf2018NFWML,tfSHiF4YSRJHXM,tf5Y7RHYXLS,tfWuSM,tfSHiFXYSLDZBQ,tfBuQNR,tfZHongDSRJHXM,tfXiangMZTSRD,tfITFWSR,tfITDSF,tfCT,space-column</userdata><userdata name="relation-types">Integer,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Object</userdata><userdata name="update-mode">whereVersion</userdata></rows></xbiz:table></item><item key="defaultValues"><xbiz:map/></item></xbiz:map></item></xbiz:map></parameter></parameters></action>
java.lang.reflect.InvocationTargetException

jishuang · 发表于 2018-6-27 16:57:46

发完整的错误信息

zdq · 发表于 2018-6-28 09:01:14

jishuang 发表于 2018-6-27 16:57
发完整的错误信息

老师您好这就是完整的控制台报错

jishuang · 发表于 2018-6-28 09:45:37

发的这个就没有错误信息，只有一句java.lang.reflect.InvocationTargetException是完整的？

zdq · 发表于 2018-6-28 13:07:56

jishuang 发表于 2018-6-28 09:45
发的这个就没有错误信息，只有一句java.lang.reflect.InvocationTargetException是完整的？ ...

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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)
Caused by: java.lang.RuntimeException: Not implemented yet
at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105)
at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916)
at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556)
at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:427)
at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117)
at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077)
at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424)
at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524)
at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508)
at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465)
at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1445)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1566)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174)
at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:146)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:277)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221)
at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:257)
at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:150)
at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:269)
at com.justep.excel.ImportGenerator.setCellsValue(ImportGenerator.java:238)
at com.justep.excel.ImportGenerator.generateRecord(ImportGenerator.java:203)
at com.justep.excel.ImportGenerator.generateSheet(ImportGenerator.java:198)
at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:131)
at Excel.importExcel(Excel.java:88)
... 26 more

jishuang · 发表于 2018-6-28 13:21:15

确认导入的excel文件中是不是有公式等的设置

zdq · 发表于 2018-6-28 13:31:38

jishuang 发表于 2018-6-28 13:21
确认导入的excel文件中是不是有公式等的设置

是的老师，但是我把excel中的所有的数据的格式都改成了文本

jishuang · 发表于 2018-6-28 13:46:52

如果所有的都是文本的就不会有问题，这个错误就是excel中的内容有问题，应该还有没改的

zdq · 发表于 2018-6-28 19:40:47

jishuang 发表于 2018-6-28 13:46
如果所有的都是文本的就不会有问题，这个错误就是excel中的内容有问题，应该还有没改的 ...

谢谢老师可以了是数据类型的问题，还存在公式。粘贴复制（数值类型）。就可以了

zdq · 发表于 2018-6-28 19:46:47

jishuang 发表于 2018-6-28 13:46
如果所有的都是文本的就不会有问题，这个错误就是excel中的内容有问题，应该还有没改的 ...

老师您好，请问主键怎么插入？我是直接插入到数据库中，提示主键不能重复java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:146)
at Excel.importExcel(Excel.java:88)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO TZHongXICTXMQD TZHongXICTXMQD(TZHongXICTXMQD, TZHongXICTXMQD.version, TZHongXICTXMQD.tfXiangMLY, TZHongXICTXMQD.tfXuH1, TZHongXICTXMQD.tfXuH2, TZHongXICTXMQD.tfXuH3, TZHongXICTXMQD.tfXiangMND, TZHongXICTXMQD.tfQianYZT, TZHongXICTXMQD.tfXiangMBH, TZHongXICTXMQD.tfYeWHTBH, TZHongXICTXMQD.tfLiuSH, TZHongXICTXMQD.tfERPBH, TZHongXICTXMQD.tfXiangMMC, TZHongXICTXMQD.tfKeHMC, TZHongXICTXMQD.tfYingXQY, TZHongXICTXMQD.tfHeTQYKHJL, TZHongXICTXMQD.tfSHouRHTEYHTXT, TZHongXICTXMQD.tfSHouRHTJJY, TZHongXICTXMQD.tfHeTTJSJ, TZHongXICTXMQD.tfHeTWCSPSJ, TZHongXICTXMQD.tfHeTGZSJ, TZHongXICTXMQD.tfHeTZT, TZHongXICTXMQD.tfHeTGZQRSJ, TZHongXICTXMQD.tfBenNQRSR, TZHongXICTXMQD.tfQiZFWSR, TZHongXICTXMQD.tfLeiJQRSR20132018, TZHongXICTXMQD.tfSHouRQRJD, TZHongXICTXMQD.tfBenNQRCB, TZHongXICTXMQD.tfQqZFWCB, TZHongXICTXMQD.tfLeiJQRCB, TZHongXICTXMQD.tfLeiJHK, TZHongXICTXMQD.tfHuiKBL, TZHongXICTXMQD.tfDangNHK, TZHongXICTXMQD.tfYingSZK, TZHongXICTXMQD.tfYingSZK3NN, TZHongXICTXMQD.tfDaoQYS, TZHongXICTXMQD.tfYiJTHZ, TZHongXICTXMQD.tfYuSZK, TZHongXICTXMQD.tfYingFZK, TZHongXICTXMQD.tfZHiZHTSFGD, TZHongXICTXMQD.tfZHiCJL, TZHongXICTXMQD.tfZHongBSJ, TZHongXICTXMQD.tfXiangMJL, TZHongXICTXMQD.tfZHiZJSWTXDSJ, TZHongXICTXMQD.tfJiHYSSJ, TZHongXICTXMQD.tfYanSSJ, TZHongXICTXMQD.tfCaiGJL, TZHongXICTXMQD.tfDianZCGXQXDSJ, TZHongXICTXMQD.tfCaiGZBWCSJ, TZHongXICTXMQD.tfCHengBHTWCQYSJ, TZHongXICTXMQD.tfYeWZCB, TZHongXICTXMQD.tfJianWB, TZHongXICTXMQD.tfCaiGB, TZHongXICTXMQD.tfYunYB, TZHongXICTXMQD.tfYiQCBHTJE, TZHongXICTXMQD.tfYiQCBHTJJ, TZHongXICTXMQD.tfCHengBZSBHS, TZHongXICTXMQD.tfYuJML, TZHongXICTXMQD.tfQianYML, TZHongXICTXMQD.tfLeiJQRML, TZHongXICTXMQD.tf2018NQRML, TZHongXICTXMQD.tf2018NFWML, TZHongXICTXMQD.tfSHiF4YSRJHXM, TZHongXICTXMQD.tf5Y7RHYXLS, TZHongXICTXMQD.tfWuSM, TZHongXICTXMQD.tfSHiFXYSLDZBQ, TZHongXICTXMQD.tfBuQNR, TZHongXICTXMQD.tfZHongDSRJHXM, TZHongXICTXMQD.tfXiangMZTSRD, TZHongXICTXMQD.tfITFWSR, TZHongXICTXMQD.tfITDSF, TZHongXICTXMQD.tfCT) VALUES (:TZHongXICTXMQD, :version, :tfXiangMLY, :tfXuH1, :tfXuH2, :tfXuH3, :tfXiangMND, :tfQianYZT, :tfXiangMBH, :tfYeWHTBH, :tfLiuSH, :tfERPBH, :tfXiangMMC, :tfKeHMC, :tfYingXQY, :tfHeTQYKHJL, :tfSHouRHTEYHTXT, :tfSHouRHTJJY, :tfHeTTJSJ, :tfHeTWCSPSJ, :tfHeTGZSJ, :tfHeTZT, :tfHeTGZQRSJ, :tfBenNQRSR, :tfQiZFWSR, :tfLeiJQRSR20132018, :tfSHouRQRJD, :tfBenNQRCB, :tfQqZFWCB, :tfLeiJQRCB, :tfLeiJHK, :tfHuiKBL, :tfDangNHK, :tfYingSZK, :tfYingSZK3NN, :tfDaoQYS, :tfYiJTHZ, :tfYuSZK, :tfYingFZK, :tfZHiZHTSFGD, :tfZHiCJL, :tfZHongBSJ, :tfXiangMJL, :tfZHiZJSWTXDSJ, :tfJiHYSSJ, :tfYanSSJ, :tfCaiGJL, :tfDianZCGXQXDSJ, :tfCaiGZBWCSJ, :tfCHengBHTWCQYSJ, :tfYeWZCB, :tfJianWB, :tfCaiGB, :tfYunYB, :tfYiQCBHTJE, :tfYiQCBHTJJ, :tfCHengBZSBHS, :tfYuJML, :tfQianYML, :tfLeiJQRML, :tf2018NQRML, :tf2018NFWML, :tfSHiF4YSRJHXM, :tf5Y7RHYXLS, :tfWuSM, :tfSHiFXYSLDZBQ, :tfBuQNR, :tfZHongDSRJHXM, :tfXiangMZTSRD, :tfITFWSR, :tfITDSF, :tfCT)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:18)
... 37 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO TZHONGXICTXMQD (TZHONGXICTXMQD.fID, TZHONGXICTXMQD.VERSION, TZHONGXICTXMQD.TFXIANGMLY, TZHONGXICTXMQD.TFXUH1, TZHONGXICTXMQD.TFXUH2, TZHONGXICTXMQD.TFXUH3, TZHONGXICTXMQD.TFXIANGMND, TZHONGXICTXMQD.TFQIANYZT, TZHONGXICTXMQD.TFXIANGMBH, TZHONGXICTXMQD.TFYEWHTBH, TZHONGXICTXMQD.TFLIUSH, TZHONGXICTXMQD.TFERPBH, TZHONGXICTXMQD.TFXIANGMMC, TZHONGXICTXMQD.TFKEHMC, TZHONGXICTXMQD.TFYINGXQY, TZHONGXICTXMQD.TFHETQYKHJL, TZHONGXICTXMQD.TFSHOURHTEYHTXT, TZHONGXICTXMQD.TFSHOURHTJJY, TZHONGXICTXMQD.TFHETTJSJ, TZHONGXICTXMQD.TFHETWCSPSJ, TZHONGXICTXMQD.TFHETGZSJ, TZHONGXICTXMQD.TFHETZT, TZHONGXICTXMQD.TFHETGZQRSJ, TZHONGXICTXMQD.TFBENNQRSR, TZHONGXICTXMQD.TFQIZFWSR, TZHONGXICTXMQD.TFLEIJQRSR20132018, TZHONGXICTXMQD.TFSHOURQRJD, TZHONGXICTXMQD.TFBENNQRCB, TZHONGXICTXMQD.TFQQZFWCB, TZHONGXICTXMQD.TFLEIJQRCB, TZHONGXICTXMQD.TFLEIJHK, TZHONGXICTXMQD.TFHUIKBL, TZHONGXICTXMQD.TFDANGNHK, TZHONGXICTXMQD.TFYINGSZK, TZHONGXICTXMQD.TFYINGSZK3NN, TZHONGXICTXMQD.TFDAOQYS, TZHONGXICTXMQD.TFYIJTHZ, TZHONGXICTXMQD.TFYUSZK, TZHONGXICTXMQD.TFYINGFZK, TZHONGXICTXMQD.TFZHIZHTSFGD, TZHONGXICTXMQD.TFZHICJL, TZHONGXICTXMQD.TFZHONGBSJ, TZHONGXICTXMQD.TFXIANGMJL, TZHONGXICTXMQD.TFZHIZJSWTXDSJ, TZHONGXICTXMQD.TFJIHYSSJ, TZHONGXICTXMQD.TFYANSSJ, TZHONGXICTXMQD.TFCAIGJL, TZHONGXICTXMQD.TFDIANZCGXQXDSJ, TZHONGXICTXMQD.TFCAIGZBWCSJ, TZHONGXICTXMQD.TFCHENGBHTWCQYSJ, TZHONGXICTXMQD.TFYEWZCB, TZHONGXICTXMQD.TFJIANWB, TZHONGXICTXMQD.TFCAIGB, TZHONGXICTXMQD.TFYUNYB, TZHONGXICTXMQD.TFYIQCBHTJE, TZHONGXICTXMQD.TFYIQCBHTJJ, TZHONGXICTXMQD.TFCHENGBZSBHS, TZHONGXICTXMQD.TFYUJML, TZHONGXICTXMQD.TFQIANYML, TZHONGXICTXMQD.TFLEIJQRML, TZHONGXICTXMQD.TF2018NQRML, TZHONGXICTXMQD.TF2018NFWML, TZHONGXICTXMQD.TFSHIF4YSRJHXM, TZHONGXICTXMQD.TF5Y7RHYXLS, TZHONGXICTXMQD.TFWUSM, TZHONGXICTXMQD.TFSHIFXYSLDZBQ, TZHONGXICTXMQD.TFBUQNR, TZHONGXICTXMQD.TFZHONGDSRJHXM, TZHONGXICTXMQD.TFXIANGMZTSRD, TZHONGXICTXMQD.TFITFWSR, TZHONGXICTXMQD.TFITDSF, TZHONGXICTXM........
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 46 more
Caused by: java.sql.SQLException: 违反了 PRIMARY KEY 约束 'PK__TZHongXI__D9F8259C7FD6B9FC'。不能在对象 'dbo.TZHongXICTXMQD' 中插入重复键。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

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

[结贴] grid导入excel报错