我的资产报view "JUSTEP_OA.V_SA_OPPERSON" 有错误

feibuer

页面报错

后台问题
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_AS_Card.*,V_SA_OPPerson.sMainOrgFID  FROM OA_AS_Card OA_AS_Card join V_SA_OPPerson V_SA_OPPerson on V_SA_OPPerson = OA_AS_Card.fDutyPsnID WHERE (OA_AS_Card.fStatus = 0 or OA_AS_Card.fStatus = 1) AND ((fDutyPsnID = 'PSN01')) ORDER BY fCode ASC LIMIT 0, 20
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)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  OA_AS_Card.VERSION AS version, OA_AS_Card.FKINDID AS fKindID, OA_AS_Card.FKIND AS fKind, OA_AS_Card.FCODE AS fCode, OA_AS_Card.FNAME AS fName, OA_AS_Card.FSPECTYPE AS fSpecType, OA_AS_Card.FUNITID AS fUnitID, OA_AS_Card.FUNIT AS fUnit, OA_AS_Card.FSTATUS AS fStatus, OA_AS_Card.FSTATUSNAME AS fStatusName, OA_AS_Card.FORIGINVALUE AS fOriginValue, OA_AS_Card.FREMAINVALUE AS fRemainValue, OA_AS_Card.FSERVICEYEAR AS fServiceYear, OA_AS_Card.FDUTYOGNID AS fDutyOgnID, OA_AS_Card.FDUTYOGNNAME AS fDutyOgnName, OA_AS_Card.FDUTYOGNFID AS fDutyOgnFID, OA_AS_Card.FDUTYDEPTID AS fDutyDeptID, OA_AS_Card.FDUTYDEPTNAME AS fDutyDeptName, OA_AS_Card.FDUTYPOSID AS fDutyPosID, OA_AS_Card.FDUTYPOSNAME AS fDutyPosName, OA_AS_Card.FDUTYPSNID AS fDutyPsnID, OA_AS_Card.FDUTYPSNNAME AS fDutyPsnName, OA_AS_Card.FDUTYPSNFID AS fDutyPsnFID, OA_AS_Card.FDUTYPSNFNAME AS fDutyPsnFName, OA_AS_Card.FUSEDDEPTID AS fUsedDeptID, OA_AS_Card.FUSEDDEPTNAME AS fUsedDeptName, OA_AS_Card.FUSEDID AS fUsedID, OA_AS_Card.FUSEDNAME AS fUsedName, OA_AS_Card.FBGDEPREYEAR AS fBgDepreYear, OA_AS_Card.FBGDEPREMONTH AS fBgDepreMonth, OA_AS_Card.FADDDEPREVALUE AS fAddDepreValue, OA_AS_Card.FFACTORY AS fFactory, OA_AS_Card.FFACTORYDATE AS fFactoryDate, OA_AS_Card.FSUPPLIER AS fSupplier, OA_AS_Card.FSOURCE AS fSource, OA_AS_Card.FSOURCENAME AS fSourceName, OA_AS_Card.FDETAILINFO AS fDetailInfo, OA_AS_Card.FCHECKID AS fCheckID, OA_AS_Card.FCHECKNO AS fCheckNO, OA_AS_Card.FBUYAPPLYID AS fBuyApplyID, OA_AS_Card.FBUYAPPLYNO AS fBuyApplyNO, OA_AS_Card.FASSETINID AS fAssetInID, OA_AS_Card.FASSETINNO AS fAssetInNO, OA_AS_Card.FREMARK AS fRemark, OA_AS_Card.FCREATEOGNID AS fCreateOgnID, OA_AS_Card.FCREATEOGNNAME AS fCreateOgnName, OA_AS_Card.FCREATEDEPTID AS fCreateDeptID, OA_AS_Card.FCREATEDEPTNAME AS fCreateDeptName, OA_AS_Card.FCREATEPOSID AS fCreatePosID, OA_AS_Card.FCREATEPOSNAME AS fCreatePosName, OA_AS_Card.FCREATEPSNID AS fCreatePsnID, OA_AS_Card.FCREATEPSNNAME AS fCreatePsnName, OA_AS_Card.FCREATEPSNFID AS fCreatePsnFID, OA_AS_Card.FCREATEPSNFNAME AS fCreatePsnFName, OA_AS_Card.FCREATETIME AS fCreateTime, OA_AS_Card.FUPDATEPSNID AS fUpdatePsnID, OA_AS_Card.FUPDATEPSNNAME AS fUpdatePsnName, OA_AS_Card.FUPDATETIME AS fUpdateTime, OA_AS_Card.FARRANGEDATE AS fArrangeDate, OA_AS_Card.FCHECKED AS fChecked, OA_AS_Card.FASSETCONFIRM AS fAssetConfirm, OA_AS_Card.FEXTENDSTR1 AS fExtendStr1, OA_AS_Card.FEXTENDSTR2 AS fExtendStr2, OA_AS_Card.FEXTENDSTR3 AS fExtendStr3, OA_AS_Card.FEXTENDSTR4 AS fExtendStr4, OA_AS_Card.FEXTENDSTR5 AS fExtendStr5, OA_AS_Card.FEXTENDSTR6 AS fExtendStr6, OA_AS_Card.FEXTENDSTR7 AS fExtendStr7, OA_AS_Card.FEXTENDSTR8 AS fExtendStr8, OA_AS_Card.FEXTENDSTR9 AS fExtendStr9, OA_AS_Card.FEXTENDDATE1 AS fExtendDate1, OA_AS_Card.FEXTENDDATE2 AS fExtendDate2, OA_AS_Card.FEXTENDDATE3 AS fExtendDate3, OA_AS_Card.FEXTENDDATE4 AS fExtendDate4, OA_AS_Card.FEXTENDDATE5 AS fExtendDate5, OA_AS_Card.FEXTENDNUM1 AS fExtendNum1, OA_AS_Card.FEXTENDNUM2 AS fExtendNum2, OA_AS_Card.FEXTENDNUM3 AS fExtendNum3, OA_AS_Card.FEXTENDNUM4 AS fExtendNum4, OA_AS_Card.FEXTENDNUM5 AS fExtendNum5, V_SA_OPPerson.SMAINORGFID AS sMainOrgFID, OA_AS_Card.fID AS OA_AS_Card FROM OA_AS_Card OA_AS_Card JOIN V_SA_OPPerson V_SA_OPPerson ON V_SA_OPPerson.sID = OA_AS_Card.FDUTYPSNID  WHERE  ( (OA_AS_Card.FSTATUS = ?) OR (OA_AS_Card.FSTATUS = ?) ) AND (fDutyPsnID = ?)   ORDER BY fCode ASC, binds: [0, 1, PSN01]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: ORA-04063: view "JUSTEP_OA.V_SA_OPPERSON" 有错误

yinlun

参考这个帖子，也许对你的问题有帮助
http://bbs.justep.com/forum.php? ... id=54322&extra=

feibuer

yinlun 发表于 2013-12-17 12:09
参考这个帖子，也许对你的问题有帮助
http://bbs.justep.com/forum.php?mod=viewthread&tid=54322&extra= ...

好的。谢谢。

feibuer

yinlun 发表于 2013-12-17 12:09
参考这个帖子，也许对你的问题有帮助
http://bbs.justep.com/forum.php?mod=viewthread&tid=54322&extra= ...

我问下，我应该在哪里找那个视图了，怎么没找见。

yinlun

feibuer 发表于 2013-12-17 12:18
我问下，我应该在哪里找那个视图了，怎么没找见。

你在哪里找，studio里还是数据库？

yinlun

/BIZ/OA/common/ontology/pubOrg.ontology.m 这个里面有

feibuer

yinlun 发表于 2013-12-17 12:22
/BIZ/OA/common/ontology/pubOrg.ontology.m 这个里面有

好的，我把JUSTEP_OA.V_SA_OPPERSON这个的，JUSTEP_OA变为我的表空间名就ok了吧。

feibuer

yinlun 发表于 2013-12-17 12:22
/BIZ/OA/common/ontology/pubOrg.ontology.m 这个里面有

JUSTEP_OA.V_SA_OPPERSON,我问的是这个，不是需要改这个么，我找不到这个。

yinlun

feibuer 发表于 2013-12-17 12:48
JUSTEP_OA.V_SA_OPPERSON,我问的是这个，不是需要改这个么，我找不到这个。

不需要改什么，你就找找数据库有这个视图有没有，如果没有自己建一张

feibuer

yinlun 发表于 2013-12-17 13:00
不需要改什么，你就找找数据库有这个视图有没有，如果没有自己建一张

我在数据库里面找到这个视图了，视图名称前面有个红叉。