fID无效

YAKUMO

通过视图反向生成的本体，在测试时候提示fID无效，该如何解决

刷新数据失败！ ,
执行KSQL出错, KSQL: SELECT POTask.* FROM POTask POTask LIMIT 0, 20
--> sql: SELECT POTask.AMOUNT AS Amount, POTask.BUYER AS Buyer, POTask.CPRICE AS CPrice, POTask.CPRICEMF AS CPriceMF, POTask.CPRICEMS AS CPriceMS, POTask.CPRICEP AS CPriceP, POTask.ETD AS ETD, POTask.MAT_NM AS Mat_Nm, POTask.MAT_NO AS Mat_No, POTask.fID AS POTask, POTask.PO_DATE AS PO_Date, POTask.PO_LN AS PO_Ln, POTask.PO_No AS PO_No, POTask.PLANT_ID AS Plant_Id, POTask.PUR_QTY AS Pur_Qty, POTask.REMARKS AS Remarks, POTask.SUPP_MAT_NO AS Supp_Mat_No, POTask.SUPPLIER_ID AS Supplier_Id, POTask.SUPPLIER_NM AS Supplier_Nm, POTask.TAX_RATE AS Tax_Rate, POTask.UNITP AS Unitp, POTask.FFID AS fFID, POTask.SCREATORPERSONNAME AS sCreatorPersonName, POTask.SEXECUTORPERSONNAME AS sExecutorPersonName, POTask.SNAME AS sName, POTask.SSTATUSNAME AS sStatusName, POTask.STYPENAME AS sTypeName FROM POTask POTask
--> binds: []
编码：JUSTEP150210
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.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:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) 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:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:745) Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT POTask.* FROM POTask POTask LIMIT 0, 20 --> sql: SELECT POTask.AMOUNT AS Amount, POTask.BUYER AS Buyer, POTask.CPRICE AS CPrice, POTask.CPRICEMF AS CPriceMF, POTask.CPRICEMS AS CPriceMS, POTask.CPRICEP AS CPriceP, POTask.ETD AS ETD, POTask.MAT_NM AS Mat_Nm, POTask.MAT_NO AS Mat_No, POTask.fID AS POTask, POTask.PO_DATE AS PO_Date, POTask.PO_LN AS PO_Ln, POTask.PO_No AS PO_No, POTask.PLANT_ID AS Plant_Id, POTask.PUR_QTY AS Pur_Qty, POTask.REMARKS AS Remarks, POTask.SUPP_MAT_NO AS Supp_Mat_No, POTask.SUPPLIER_ID AS Supplier_Id, POTask.SUPPLIER_NM AS Supplier_Nm, POTask.TAX_RATE AS Tax_Rate, POTask.UNITP AS Unitp, POTask.FFID AS fFID, POTask.SCREATORPERSONNAME AS sCreatorPersonName, POTask.SEXECUTORPERSONNAME AS sExecutorPersonName, POTask.SNAME AS sName, POTask.SSTATUSNAME AS sStatusName, POTask.STYPENAME AS sTypeName FROM POTask POTask --> binds: [] 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.BizData.query(Unknown Source) at BizProcedure.query(BizProcedure.java:12) ... 27 more Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT POTask.AMOUNT AS Amount, POTask.BUYER AS Buyer, POTask.CPRICE AS CPrice, POTask.CPRICEMF AS CPriceMF, POTask.CPRICEMS AS CPriceMS, POTask.CPRICEP AS CPriceP, POTask.ETD AS ETD, POTask.MAT_NM AS Mat_Nm, POTask.MAT_NO AS Mat_No, POTask.fID AS POTask, POTask.PO_DATE AS PO_Date, POTask.PO_LN AS PO_Ln, POTask.PO_No AS PO_No, POTask.PLANT_ID AS Plant_Id, POTask.PUR_QTY AS Pur_Qty, POTask.REMARKS AS Remarks, POTask.SUPP_MAT_NO AS Supp_Mat_No, POTask.SUPPLIER_ID AS Supplier_Id, POTask.SUPPLIER_NM AS Supplier_Nm, POTask.TAX_RATE AS Tax_Rate, POTask.UNITP AS Unitp, POTask.FFID AS fFID, POTask.SCREATORPERSONNAME AS sCreatorPersonName, POTask.SEXECUTORPERSONNAME AS sExecutorPersonName, POTask.SNAME AS sName, POTask.SSTATUSNAME AS sStatusName, POTask.STYPENAME AS sTypeName FROM POTask POTask, binds: []出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source) ... 32 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) ... 33 more

关闭

jishuang

http://docs.wex5.com/bex5-server-question-list-10030/

YAKUMO

懂了，可以结贴了