ontology文件中的主键映射无法修改

sandgia

1.表中的主键是ID
2，映射中的主键是fID，我要修改成ID，但是报错：字段已存在，改不了。

3.因为改不了，所以页面运行的时候就会报KSQL错误，说没有 字段fid。

怎么办？我就不截图了。

报错：
Uncaught Error: __justepServerErrorStart__{"message":"保存数据失败！ , \n执行KSQL出错, KSQL: INSERT INTO BIDBUDGETOPTIONAL_MASTER BIDBUDGETOPTIONAL_MASTER(BIDBUDGETOPTIONAL_MASTER, BIDBUDGETOPTIONAL_MASTER.version, BIDBUDGETOPTIONAL_MASTER.BIDNO, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A1, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A2, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A3, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A4, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B1, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B2, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B3, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B4, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B5, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B6, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B7, BIDBUDGETOPTIONAL_MASTER.EXPENSE_B8, BIDBUDGETOPTIONAL_MASTER.EXPENSE_C1, BIDBUDGETOPTIONAL_MASTER.EXPENSE_C2, BIDBUDGETOPTIONAL_MASTER.EXPENSE_C3, BIDBUDGETOPTIONAL_MASTER.EXPENSE_D1, BIDBUDGETOPTIONAL_MASTER.EXPENSE_D2, BIDBUDGETOPTIONAL_MASTER.EXPENSE_D3, BIDBUDGETOPTIONAL_MASTER.EXPENSE_D4, BIDBUDGETOPTIONAL_MASTER.EXPENSE_D5, BIDBUDGETOPTIONAL_MASTER.EXPENSE_E, BIDBUDGETOPTIONAL_MASTER.EXPENSE_G, BIDBUDGETOPTIONAL_MASTER.EXPENSE_H, BIDBUDGETOPTIONAL_MASTER.EXPENSE_I, BIDBUDGETOPTIONAL_MASTER.EXPENSE_YYLR, BIDBUDGETOPTIONAL_MASTER.FACTIVITY, BIDBUDGETOPTIONAL_MASTER.FACTIVITYNAME, BIDBUDGETOPTIONAL_MASTER.FCREATDTIME, BIDBUDGETOPTIONAL_MASTER.FCREATEDEPTCODE, BIDBUDGETOPTIONAL_MASTER.FCREATEDEPTID, BIDBUDGETOPTIONAL_MASTER.FCREATEDEPTNAME, BIDBUDGETOPTIONAL_MASTER.FCREATEPERSONCODE, BIDBUDGETOPTIONAL_MASTER.FCREATEPERSONFID, BIDBUDGETOPTIONAL_MASTER.FCREATEPERSONID, BIDBUDGETOPTIONAL_MASTER.FCREATEPERSONNAME, BIDBUDGETOPTIONAL_MASTER.FDELFLAG, BIDBUDGETOPTIONAL_MASTER.FORMNO, BIDBUDGETOPTIONAL_MASTER.FPROCESSID, BIDBUDGETOPTIONAL_MASTER.FTASKID, BIDBUDGETOPTIONAL_MASTER.FUPDATETIME, BIDBUDGETOPTIONAL_MASTER.ID, BIDBUDGETOPTIONAL_MASTER.PROCESSSTATUS) VALUES (:BIDBUDGETOPTIONAL_MASTER, :version, :BIDNO, :EXPENSE_A1, :EXPENSE_A2, :EXPENSE_A3, :EXPENSE_A4, :EXPENSE_B1, :EXPENSE_B2, :EXPENSE_B3, :EXPENSE_B4, :EXPENSE_B5, :EXPENSE_B6, :EXPENSE_B7, :EXPENSE_B8, :EXPENSE_C1, :EXPENSE_C2, :EXPENSE_C3, :EXPENSE_D1, :EXPENSE_D2, :EXPENSE_D3, :EXPENSE_D4, :EXPENSE_D5, :EXPENSE_E, :EXPENSE_G, :EXPENSE_H, :EXPENSE_I, :EXPENSE_YYLR, :FACTIVITY, :FACTIVITYNAME, :FCREATDTIME, :FCREATEDEPTCODE, :FCREATEDEPTID, :FCREATEDEPTNAME, :FCREATEPERSONCODE, :FCREATEPERSONFID, :FCREATEPERSONID, :FCREATEPERSONNAME, :FDELFLAG, :FORMNO, :FPROCESSID, :FTASKID, :FUPDATETIME, :ID, ROCESSSTATUS)","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:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\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 BIDBUDGETOPTIONAL_MASTER BIDBUDGETOPTIONAL_MASTER(BIDBUDGETOPTIONAL_MASTER, BIDBUDGETOPTIONAL_MASTER.version, BIDBUDGETOPTIONAL_MASTER.BIDNO, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A1, BIDBUDGETOPTIONAL_MASTER.EXPENSE_A2core.min.js:65)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at n.doSaveDataAfter (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.Request._requestCallback (biz.common.min.js:12)
    at Object.<anonymous> (biz.common.min.js:12)
    at f (core.min.js:65)
    at Object.add (core.min.js:65)
    at Object.Request.endBatch (biz.common.min.js:12)
    at n._endBatch (biz.common.min.js:12)


为了解决以上的问题，我在 数据库中将ID指定为主键，利用反向生成本体重新生成，这一次主键在映射的界面自动修改为ID了，但是在 概念的定义中没有ID这个关系，在界面保存的时候报错,说关系中没有定义ID这个字段。然后我定义了ID这个字段，接着报错，ksql执行时候ID字段重复。

以上的问题产生的原因是什么？我在开发手册中没有查到有关的注意点。

jishuang

关系中定义ID后，在主键关系的地方选择ID啊http://docs.wex5.com/bex5-server-question-list-10030/

sandgia

jishuang 发表于 2019-5-27 09:57
关系中定义ID后，在主键关系的地方选择ID啊http://docs.wex5.com/bex5-server-question-list-10030/ ...

虽然和上次碰到的问题不同，还是通过连接的方法解决的，关于主键的问题基本这是解决的万能方法。请结贴。