多出fID字段

1104797209

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT PLUS_PROJECT.*  FROM PLUS_PROJECT PLUS_PROJECT WHERE ((UID_='2011080')) LIMIT 0, 20
--> sql: SELECT  PLUS_PROJECT.CALENDARS_ AS CALENDARS_, PLUS_PROJECT.CALENDARUID_ AS CALENDARUID_, PLUS_PROJECT.FINISHDATE_ AS FINISHDATE_, PLUS_PROJECT.LASTSAVED_ AS LASTSAVED_, PLUS_PROJECT.NAME_ AS NAME_, PLUS_PROJECT.fID AS PLUS_PROJECT, PLUS_PROJECT.STARTDATE_ AS STARTDATE_, PLUS_PROJECT.UID_ AS UID_ FROM PLUS_PROJECT PLUS_PROJECT  WHERE UID_ = ?
--> binds: [2011080]
        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:33)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  PLUS_PROJECT.CALENDARS_ AS CALENDARS_, PLUS_PROJECT.CALENDARUID_ AS CALENDARUID_, PLUS_PROJECT.FINISHDATE_ AS FINISHDATE_, PLUS_PROJECT.LASTSAVED_ AS LASTSAVED_, PLUS_PROJECT.NAME_ AS NAME_, PLUS_PROJECT.fID AS PLUS_PROJECT, PLUS_PROJECT.STARTDATE_ AS STARTDATE_, PLUS_PROJECT.UID_ AS UID_ FROM PLUS_PROJECT PLUS_PROJECT  WHERE UID_ = ?, binds: [2011080]出错
        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: "PLUS_PROJECT"."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

jishuang

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

1104797209

jishuang 发表于 2018-3-26 14:12
http://docs.wex5.com/bex5-server-question-list-10030/

结帖，已解决