ORA-00904: "SA_OPPERSON"."FID": 标识符无效

yddezk

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select Check_Card.*,SA_OPPerson.sName as sName     from Check_Card Check_Card       optional  join SA_OPPerson SA_OPPerson on Check_Card.sPersonID  =  SA_OPPerson 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  Check_Card.fID AS Check_Card, Check_Card.VERSION AS version, Check_Card.SORDERNUM AS sOrderNum, Check_Card.FACCOUNT AS fAccount, Check_Card.FEQUID AS fEquID, Check_Card.FCARDNO AS fCardNo, Check_Card.FWORKNO AS fWorkNo, Check_Card.SPERSONID AS sPersonID, Check_Card.FDEPTID AS fDeptID, Check_Card.FNAME AS fName, Check_Card.FDEPTNAME AS fDeptName, Check_Card.SSEX AS sSex, Check_Card.SIDCARD AS sIDCard, Check_Card.FFUNCTION AS fFunction, Check_Card.FTIME AS fTime, Check_Card.FTYPE AS fType, Check_Card.FINCOME AS fIncome, Check_Card.FPAY AS fPay, Check_Card.FBEGINBALANCE AS fBeginBalance, Check_Card.FENDBALANCE AS fEndBalance, Check_Card.FCOUNT AS fCount, Check_Card.FEQUCOUNT AS fEquCount, Check_Card.FCOUNTDATE AS fCountDate, Check_Card.FTRADEDATE AS fTradeDate, Check_Card.FREMARK AS fRemark, SA_OPPerson.SNAME AS sName FROM Check_Card Check_Card LEFT JOIN SA_OPPerson SA_OPPerson ON Check_Card.SPERSONID = SA_OPPerson.fID), 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: ORA-00904: "SA_OPPERSON"."FID": 标识符无效     

为什么系统人员表 SA_OPPERSON会去找FID  它应该是SID啊

MaHZ

到.mapping文件中找到人员表，把这个fID改成sID，试试，不知道这么改标准不标准

yddezk

MaHZ 发表于 2014-6-26 17:48
到.mapping文件中找到人员表，把这个fID改成sID，试试，不知道这么改标准不标准
...

我这么改过了 好像没有用

MaHZ

yddezk 发表于 2014-6-26 18:49
我这么改过了 好像没有用

你到底是用sql还是ksql，ksql 连接是 optional join 吧

FROM支持连接(JOIN)和可选连接(OPTIONAL JOIN， 等价于SQL的LEFT JOIN)

yddezk

MaHZ 发表于 2014-6-26 19:08
你到底是用sql还是ksql，ksql 连接是 optional join 吧

FROM支持连接(JOIN)和可选连接(OPTIONAL JOIN， ...

这是ksql 我都是用的里面自带的功能选出来的   是照着教学视频上面 （采购申请单 采购物品）一步一步学的

腹部流出的肉

MaHZ 发表于 2014-6-26 19:08
你到底是用sql还是ksql，ksql 连接是 optional join 吧

FROM支持连接(JOIN)和可选连接(OPTIONAL JOIN， ...

明明是KSQL呀

腹部流出的肉

SELECT
    Check_Card.fID AS Check_Card,
    Check_Card.VERSION AS version,
    Check_Card.SORDERNUM AS sOrderNum,
    Check_Card.FACCOUNT AS fAccount,
    Check_Card.FEQUID AS fEquID,
    Check_Card.FCARDNO AS fCardNo,
    Check_Card.FWORKNO AS fWorkNo,
    Check_Card.SPERSONID AS sPersonID,
    Check_Card.FDEPTID AS fDeptID,
    Check_Card.FNAME AS fName,
    Check_Card.FDEPTNAME AS fDeptName,
    Check_Card.SSEX AS sSex,
    Check_Card.SIDCARD AS sIDCard,
    Check_Card.FFUNCTION AS fFunction,
    Check_Card.FTIME AS fTime,
    Check_Card.FTYPE AS fType,
    Check_Card.FINCOME AS fIncome,
    Check_Card.FPAY AS fPay,
    Check_Card.FBEGINBALANCE AS fBeginBalance,
    Check_Card.FENDBALANCE AS fEndBalance,
    Check_Card.FCOUNT AS fCount,
    Check_Card.FEQUCOUNT AS fEquCount,
    Check_Card.FCOUNTDATE AS fCountDate,
    Check_Card.FTRADEDATE AS fTradeDate,
    Check_Card.FREMARK AS fRemark,
    SA_OPPerson.SNAME AS sName
FROM
    Check_Card Check_Card
LEFT JOIN
    SA_OPPerson SA_OPPerson
ON
    Check_Card.SPERSONID = SA_OPPerson.fID

你这个是怎么回事？

yddezk

腹部流出的肉 发表于 2014-6-26 20:32
SELECT
    Check_Card.fID AS Check_Card,
    Check_Card.VERSION AS version,

我就是想知道 为什么是FID。应该是SID 才对 。关系Check_Card.SpersonId =SA_OPPerson  我是在上面选出来的。点击测试时候就报这个错了

腹部流出的肉

yddezk 发表于 2014-6-27 07:40
我就是想知道 为什么是FID。应该是SID 才对 。关系Check_Card.SpersonId =SA_OPPerson  我是在上面选出来 ...

把你配置形成的源码贴一下

zhaixin

删除model\BIZ\SA\doc\data目录下的、data.store.m 和 include.m