急！ksql中多出一个fid

sandgia

生成标准的query动作，此前没有问题，但是在测试的时候报出异常
异常如下：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  PRAQUALIFY_MASTER.fID AS PRAQUALIFY_MASTER, PRAQUALIFY_MASTER.ID AS ID, PRAQUALIFY_MASTER.VERSION AS version, PRAQUALIFY_MASTER.FCREATEPERSONNAME AS FCREATEPERSONNAME, PRAQUALIFY_MASTER.FCREATEPERSONID AS FCREATEPERSONID, PRAQUALIFY_MASTER.FCREATEPERSONCODE AS FCREATEPERSONCODE, PRAQUALIFY_MASTER.FCREATEPERSONFID AS FCREATEPERSONFID, PRAQUALIFY_MASTER.FCREATEDEPTNAME AS FCREATEDEPTNAME, PRAQUALIFY_MASTER.FCREATEDEPTID AS FCREATEDEPTID, PRAQUALIFY_MASTER.FCREATEDEPTCODE AS FCREATEDEPTCODE, PRAQUALIFY_MASTER.FCREATDTIME AS FCREATDTIME, PRAQUALIFY_MASTER.FUPDATETIME AS FUPDATETIME, PRAQUALIFY_MASTER.FACTIVITY AS FACTIVITY, PRAQUALIFY_MASTER.FACTIVITYNAME AS FACTIVITYNAME, PRAQUALIFY_MASTER.FTASKID AS FTASKID, PRAQUALIFY_MASTER.FPROCESSID AS FPROCESSID, PRAQUALIFY_MASTER.FDELFLAG AS FDELFLAG, PRAQUALIFY_MASTER.PROCESSSTATUS AS PROCESSSTATUS, PRAQUALIFY_MASTER.FORMNUMBER AS FORMNUMBER, PRAQUALIFY_MASTER.FWORKDATE AS FWORKDATE, PRAQUALIFY_MASTER.RUSIDATE AS RUSIDATE, PRAQUALIFY_MASTER.NOWROLES AS NOWROLES, PRAQUALIFY_MASTER.APPLYROLE AS APPLYROLE, PRAQUALIFY_MASTER.APPLYMAJORIDS AS APPLYMAJORIDS, PRAQUALIFY_MASTER.TITLEINFOFSCANS AS TITLEINFOFSCANS, PRAQUALIFY_MASTER.COMPETENCYFSCANS AS COMPETENCYFSCANS, PRAQUALIFY_MASTER.ANNOUNCEMENTREMARK AS ANNOUNCEMENTREMARK, PRAQUALIFY_MASTER.JOBNO AS JOBNO FROM PRAQUALIFY_MASTER PRAQUALIFY_MASTER, 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: ORA-00904: "PRAQUALIFY_MASTER"."FID": 标识符无效

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    ... 33 more
但是我在ontology文件中没有定义FID这个关系，我重新删除了动作，重新生成还是报这个错误。

jishuang

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

sandgia

jishuang 发表于 2019-5-21 17:18
http://docs.wex5.com/bex5-server-question-list-10030/

解决，请结贴。