视图反向生成本体报错

橄榄树下的小草

2016-11-04 09:43:41 加载模块：/yongyoujicheng/ysxiaoshoudingdanxin/data ...
2016-11-04 09:43:41 加载模块：/yongyoujicheng/ysxiaoshoudingdanxin/ontology ...
2016-11-04 09:43:41 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="queryDataTestAction"><parameters><parameter name="ksql"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">select oa_x_ysbom.*     from oa_x_ysbom oa_x_ysbom LIMIT 0, 50</xbiz:simple></parameter><parameter name="dataModel"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">/yongyoujicheng/ysxiaoshoudingdanxin/data</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
        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: com.justep.exception.BusinessException: 编码: JUSTEP150109; 提示: "/yongyoujicheng/ysxiaoshoudingdanxin/ontology/f_itemno@Relation"不存在
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.checkNotExist(Unknown Source)
        at com.justep.model.impl.ConceptImpl.init(Unknown Source)
        at com.justep.model.impl.ModelImpl.initial(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModelObjects(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModel(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModel(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:17)
        ... 25 more

大雁子

请问是BeX5么？

橄榄树下的小草

X5.2.7

jishuang

"/yongyoujicheng/ysxiaoshoudingdanxin/ontology/f_itemno@Relation"不存在

没有f_itemno这个关系的定义

在模块中查找一下有<relation name="f_itemno"类似于这样的定义吗？没有添加一个

橄榄树下的小草

现在又提示新的错误
2016-11-04 14:15:16 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:justep="http://www.justep.com/x5#" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xforms="http://www.w3.org/2002/xforms" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:ns="http://www.justep.com/x5#" xmlns:xbiz="http://www.justep.com/xbiz#" activity="mainActivity" process="/SA/OPM/system/systemProcess" name="queryDataTestAction"><parameters><parameter name="ksql"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">select OAysbom.*     from OAysbom OAysbom LIMIT 0, 50</xbiz:simple></parameter><parameter name="dataModel"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#string">/yongyoujicheng/ysxiaoshoudingdanxin/data</xbiz:simple></parameter></parameters></action>
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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select OAysbom.*     from OAysbom OAysbom LIMIT 0, 50
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at KSQLProcedure.query(KSQLProcedure.java:17)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  OAysbom.fID AS OAysbom, OAysbom.F_ITEMNO AS f_itemno, OAysbom.FMC AS fmc, OAysbom.QTY AS qty, OAysbom.F_QTY AS f_qty, OAysbom.ITEMNO AS itemno, OAysbom.ZMC AS zmc, OAysbom.REMARK AS Remark FROM OAysbom OAysbom), binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 31 more
Caused by: java.sql.SQLException: 列名 'fID' 无效。
        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.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 32 more

橄榄树下的小草

表中没有FID

jishuang

看看映射设置中主键关系的名字是不是fID

橄榄树下的小草

解决了

橄榄树下的小草

现在有一个新的问题，X5进阶培训—对话框系列组件的视频，做了一个多选对话框，对话框代码：
ysbom.trigger1Click = function(event){
var grid = justep.xbl("grid1");
var checkedIDs = grid.getDhtmlxGrid().getCheckedRows(0).split(',');
alert(checkedIDs);
var r = [];
for(var i=0;i<checkedIDs.length;i++){
    var id=checkedIDs[i];
    r.push({
               "id":id,
               "fbm":justep.xbl("bizData1").getValue("f_itemno",id),
               "zbm":justep.xbl("bizData1").getValue("itemno",id)
    });
   
}       
justep.xbl('windowReceiver1').windowEnsure(r);
};

主窗口接收的代码视频上没讲，自己写的代码
mainActivityDetail.windowDialog1Receive = function(event){
        justep.xbl("detailData").setValue("fFBM",event.data.fbm);
        justep.xbl("detailData").setValue("fCHBM",event.data.zbm);
};
返回数据失败，主界面没有接收到数据，请问主界面接收的代码怎么写？

jishuang

不同的问题请分开发帖

debugger调试看看event中都有什么