表单保存数据失败！

yibo

FU_CPsaleZB(FU_CPsaleZB, FU_CPsaleZB.version, FU_CPsaleZB.fBGDH, FU_CPsaleZB.fBZ, FU_CPsaleZB.fDWID, FU_CPsaleZB.fFWDQR, FU_CPsaleZB.fFWF, FU_CPsaleZB.fFWRYID, FU_CPsaleZB.fHTBH, FU_CPsaleZB.fHTE, FU_CPsaleZB.fRQ, FU_CPsaleZB.fSRID, FU_CPsaleZB.fXLH, FU_CPsaleZB.fXM, FU_CPsaleZB.fXSRYID) VALUES (:FU_CPsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWF, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID),保存数据失败！ ","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO FU_CPsaleZB FU_CPsaleZB(FU_CPsaleZB, FU_CPsaleZB.version, FU_CPsaleZB.fBGDH, FU_CPsaleZB.fBZ, FU_CPsaleZB.fDWID, FU_CPsaleZB.fFWDQR, FU_CPsaleZB.fFWF, FU_CPsaleZB.fFWRYID, FU_CPsaleZB.fHTBH, FU_CPsaleZB.fHTE, FU_CPsaleZB.fRQ, FU_CPsaleZB.fSRID, FU_CPsaleZB.fXLH, FU_CPsaleZB.fXM, FU_CPsaleZB.fXSRYID) VALUES (:FU_CPsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWF, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID)\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.insert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.BizData.save(Unknown Source)\r\n\tat BizProcedure.save(BizProcedure.java:143)\r\n\t... 27 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO FU_SALEZB (FU_SALEZB.fID, FU_SALEZB.VERSION, FU_SALEZB.FBGDH, FU_SALEZB.FBZ, FU_SALEZB.FDWID, FU_SALEZB.FFWDQR, FU_SALEZB.FFWF, FU_SALEZB.FFWRYID, FU_SALEZB.FHTBH, FU_SALEZB.FHTE, FU_SALEZB.FRQ, FU_SALEZB.FSRID, FU_SALEZB.FXLH, FU_SALEZB.FXM, FU_SALEZB.FXSRYID, FU_SALEZB.TYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [05BCBE67AF9546CAAEDD0FABBA438D8F, 0, test, null, 277076B46F4B46819832F1D708CE64B1, 2017-03-28 17:33:54.647, 0.0, EE30C38AF2314851A2C0914C5DF4B229, cp000012, 44.0, 2016-03-28 17:33:54.647, null, null, test, EE30C38AF2314851A2C0914C5DF4B229, chanpin]出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)\r\n\t... 36 more\r\nCaused by: java.sql.SQLException: 对象名 'FW_JCDA' 无效。\r\n\tat net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)\r\n\tat net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)\r\n\tat net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)\r\n\tat net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\t... 37 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO FU_CPsaleZB FU_CPsaleZB(FU_CPsaleZB, FU_CPsaleZB.version, FU_CPsaleZB.fBGDH, FU_CPsaleZB.fBZ, FU_CPsaleZB.fDWID, FU_CPsaleZB.fFWDQR, FU_CPsaleZB.fFWF, FU_CPsaleZB.fFWRYID, FU_CPsaleZB.fHTBH, FU_CPsaleZB.fHTE, FU_CPsaleZB.fRQ, FU_CPsaleZB.fSRID, FU_CPsaleZB.fXLH, FU_CPsaleZB.fXM, FU_CPsaleZB.fXSRYID) VALUES (:FU_CPsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWF, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID)","编码: JUSTEP150039; 提示: 执行sql: INSERT INTO FU_SALEZB (FU_SALEZB.fID, FU_SALEZB.VERSION, FU_SALEZB.FBGDH, FU_SALEZB.FBZ, FU_SALEZB.FDWID, FU_SALEZB.FFWDQR, FU_SALEZB.FFWF, FU_SALEZB.FFWRYID, FU_SALEZB.FHTBH, FU_SALEZB.FHTE, FU_SALEZB.FRQ, FU_SALEZB.FSRID, FU_SALEZB.FXLH, FU_SALEZB.FXM, FU_SALEZB.FXSRYID, FU_SALEZB.TYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [05BCBE67AF9546CAAEDD0FABBA438D8F, 0, test, null, 277076B46F4B46819832F1D708CE64B1, 2017-03-28 17:33:54.647, 0.0, EE30C38AF2314851A2C0914C5DF4B229, cp000012, 44.0, 2016-03-28 17:33:54.647, null, null, test, EE30C38AF2314851A2C0914C5DF4B229, chanpin]出错","对象名 'FW_JCDA' 无效。"],"url":"","param":""}__justepServerErrorEnd__

yibo

对象'FW_JCDA'是之前的数据库表，新表名是‘FU_JCDA’

yibo

Uncaught Error: __justepServerErrorStart__{"message":"执行KSQL出错, KSQL: INSERT INTO FU_FWsaleZB FU_FWsaleZB(FU_FWsaleZB, FU_FWsaleZB.version, FU_FWsaleZB.fBGDH, FU_FWsaleZB.fBZ, FU_FWsaleZB.fDWID, FU_FWsaleZB.fFWDQR, FU_FWsaleZB.fFWRYID, FU_FWsaleZB.fHTBH, FU_FWsaleZB.fHTE, FU_FWsaleZB.fRQ, FU_FWsaleZB.fSRID, FU_FWsaleZB.fXLH, FU_FWsaleZB.fXM, FU_FWsaleZB.fXSRYID, FU_FWsaleZB.fYJTSID) VALUES (:FU_FWsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID, :fYJTSID),保存数据失败！ ","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO FU_FWsaleZB FU_FWsaleZB(FU_FWsaleZB, FU_FWsaleZB.version, FU_FWsaleZB.fBGDH, FU_FWsaleZB.fBZ, FU_FWsaleZB.fDWID, FU_FWsaleZB.fFWDQR, FU_FWsaleZB.fFWRYID, FU_FWsaleZB.fHTBH, FU_FWsaleZB.fHTE, FU_FWsaleZB.fRQ, FU_FWsaleZB.fSRID, FU_FWsaleZB.fXLH, FU_FWsaleZB.fXM, FU_FWsaleZB.fXSRYID, FU_FWsaleZB.fYJTSID) VALUES (:FU_FWsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID, :fYJTSID)\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.insert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.BizData.save(Unknown Source)\r\n\tat BizProcedure.save(BizProcedure.java:143)\r\n\t... 27 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO FU_SALEZB (FU_SALEZB.fID, FU_SALEZB.VERSION, FU_SALEZB.FBGDH, FU_SALEZB.FBZ, FU_SALEZB.FDWID, FU_SALEZB.FFWDQR, FU_SALEZB.FFWRYID, FU_SALEZB.FHTBH, FU_SALEZB.FHTE, FU_SALEZB.FRQ, FU_SALEZB.FSRID, FU_SALEZB.FXLH, FU_SALEZB.FXM, FU_SALEZB.FXSRYID, FU_SALEZB.FYJTSID, FU_SALEZB.TYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [2BA494FBBF994CF3862034E92B20D730, 0, test, , 277076B46F4B46819832F1D708CE64B1, 2017-03-28 20:27:43.665, EE30C38AF2314851A2C0914C5DF4B229, fw000007, 8888.0, 2016-03-28 20:27:43.681, null, 111, test, EE30C38AF2314851A2C0914C5DF4B229, null, fuwu]出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)\r\n\t... 36 more\r\nCaused by: java.sql.SQLException: 对象名 'FW_JCDA' 无效。\r\n\tat net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)\r\n\tat net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)\r\n\tat net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)\r\n\tat net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\t... 37 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO FU_FWsaleZB FU_FWsaleZB(FU_FWsaleZB, FU_FWsaleZB.version, FU_FWsaleZB.fBGDH, FU_FWsaleZB.fBZ, FU_FWsaleZB.fDWID, FU_FWsaleZB.fFWDQR, FU_FWsaleZB.fFWRYID, FU_FWsaleZB.fHTBH, FU_FWsaleZB.fHTE, FU_FWsaleZB.fRQ, FU_FWsaleZB.fSRID, FU_FWsaleZB.fXLH, FU_FWsaleZB.fXM, FU_FWsaleZB.fXSRYID, FU_FWsaleZB.fYJTSID) VALUES (:FU_FWsaleZB, :version, :fBGDH, :fBZ, :fDWID, :fFWDQR, :fFWRYID, :fHTBH, :fHTE, :fRQ, :fSRID, :fXLH, :fXM, :fXSRYID, :fYJTSID)","编码: JUSTEP150039; 提示: 执行sql: INSERT INTO FU_SALEZB (FU_SALEZB.fID, FU_SALEZB.VERSION, FU_SALEZB.FBGDH, FU_SALEZB.FBZ, FU_SALEZB.FDWID, FU_SALEZB.FFWDQR, FU_SALEZB.FFWRYID, FU_SALEZB.FHTBH, FU_SALEZB.FHTE, FU_SALEZB.FRQ, FU_SALEZB.FSRID, FU_SALEZB.FXLH, FU_SALEZB.FXM, FU_SALEZB.FXSRYID, FU_SALEZB.FYJTSID, FU_SALEZB.TYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [2BA494FBBF994CF3862034E92B20D730, 0, test, , 277076B46F4B46819832F1D708CE64B1, 2017-03-28 20:27:43.665, EE30C38AF2314851A2C0914C5DF4B229, fw000007, 8888.0, 2016-03-28 20:27:43.681, null, 111, test, EE30C38AF2314851A2C0914C5DF4B229, null, fuwu]出错","对象名 'FW_JCDA' 无效。"],"url":"","param":""}__justepServerErrorEnd__

wintersday

yibo 发表于 2016-3-28 20:03
对象'FW_JCDA'是之前的数据库表，新表名是‘FU_JCDA’

根据ontology文件重新生成库表。

yibo

wintersday 发表于 2016-3-28 23:28
根据ontology文件重新生成库表。

谢谢哈，我又重新生成了，还是报错。
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执
行sql: INSERT INTO FU_SALEZB (FU_SALEZB.fID, FU_SALEZB.VERSION, FU_SALEZB.FBGDH,
FU_SALEZB.FBZ, FU_SALEZB.FDWID, FU_SALEZB.FFWRYID, FU_SALEZB.FHTBH, FU_SALEZB.F
HTE, FU_SALEZB.FRQ, FU_SALEZB.FSRID, FU_SALEZB.FXM, FU_SALEZB.FXSRYID, FU_SALEZB
.TYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), b
inds: [F794547ED53743B2A22BD83E21F53545, 0, test, null, 277076B46F4B46819832F1D7
08CE64B1, EE30C38AF2314851A2C0914C5DF4B229, hc000005, 88.0, 2016-03-29 08:26:57.
457, null, test, EE30C38AF2314851A2C0914C5DF4B229, haocai]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 36 more
Caused by: java.sql.SQLException: 对象名 'FW_JCDA' 无效。

jishuang

对象名无效说明数据库中没有找到FW_JCDA这张表

如果是换了表名，看映射设置中设置的表名是新的吗

yibo

jishuang 发表于 2016-3-29 09:34
对象名无效说明数据库中没有找到FW_JCDA这张表

如果是换了表名，看映射设置中设置的表名是新的吗

映射设置里面，表名已改为FU_JCDA，并重新生成数据库表，还是提示这个错误。

yibo

jishuang 发表于 2016-3-29 09:34
对象名无效说明数据库中没有找到FW_JCDA这张表

如果是换了表名，看映射设置中设置的表名是新的吗

情况是这样的，本来是好好的，没有报错了。刚开始设计的是概念映射FW_JCDA表，后来修改映射设置里面表名，改为现在的FU_JCDA，重新生成了数据库表，就一直正常使用没有报错，后来在navicat看数据库表时，发现有有两个表FU_JCDA和FW_JCDA，就把FW_JCDA直接删了，然后就报错了，我重新复制表FU_JCDA为FW_JCDA，就又不报错了，删除了FW_JCDA就报错。

jishuang

在biz下搜下一下看看FW_JCDA改全了吗？

修改了映射设置应该就可以的，可以打开data下的mapping文件看看源码中是否修改生效了

yibo

jishuang 发表于 2016-3-29 11:56
在biz下搜下一下看看FW_JCDA改全了吗？

修改了映射设置应该就可以的，可以打开data下的mapping文件看看源 ...

mapping文件替换过的