客户端登陆时出错，日志“ORA-00904: "SECURITY"."FREQUIRESPECI...
0人赞赏了该文章
670次浏览
未经作者许可，禁止转载编辑于2018年07月23日 17:23:44
适用版本EAS7.0.1
问题现象启动EAS客户端输入用户名、密码进行登录时提示“获取用户相关信息失败！请查看服务器日志，并确认是否数据库设置错误或者版本不匹配”。详细信息请查看附件。
client.log中错误日志如下：Caused by:com.kingdee.bos.BOSException: Sql execute exception : SELECT U.FID, U.FNumber, U.FName_L2, U.FPassword, U.FType, U.FIsLocked, U.FIsDelete, U.FForbidden, U.FIsRegister, U.FGroupID, U.FPersonId,U.FSecurityID, U.FEffectiveDate, U.FInvalidationDate, U.FDefaultLocale, U.FErrCount,U.FPWEffectiveDate, U.FLockedTime, U.FType, U.FDefOrgUnitID, U.FControlUnitID, CtrlUnit.FNumber ASFCtrlUnitNumber, CtrlUnit.FName_L2 ASFCtrlUnitName, U.FIsBizAdmin,U.FIsChangedPW,U.FLoginAuthorWay, U.FDescription_L2, Person.FNumberAS FPersonNumber, Person.FName_L2 AS FPersonName, Person.FOfficePhone AS FOfficePhone, Security.FNumber AS FSecurityNumber, Security.FAlias_L2 AS FSecurityAlias, Security.FPasswordLength ASFPasswordLength, Security.FPasswordForever AS FPasswordForever, Security.FNeedLocked ASFNeedLocked, Security.FLockCount ASFLockCount, Security.FPasswordCanChg AS FPasswordCanChg, Security.FPasswordCycle AS FPasswordCycle,Security.FForewarnDay AS FForewarnDay, Security.FIsComplex AS FIsComplex, Security.FIsRequireChgPW ASFIsRequireChgPW, Security.FExpiredPassCanChg as FExpiredPassCanChg,Security.FRequireSpecialChar as FRequireSpecialChar, BaseUnit.FNumber ASFDefOrgUnitNumber, BaseUnit.FName_L2 ASFDefOrgUnitName, BaseUnit.FIsCU,BaseUnit.FIsCompanyOrgUnit, BaseUnit.FIsSaleOrgUnit, BaseUnit.FIsCostOrgUnit,BaseUnit.FIsPurchaseOrgUnit, BaseUnit.FIsStorageOrgUnit,BaseUnit.FIsHROrgUnit, BaseUnit.FIsTransportOrgUnit,BaseUnit.FIsQualityOrgUnit, U.FCustomerID, U.FSupplierID FROM T_PM_UserU LEFT OUTER JOIN T_BD_Person Person ONPerson.FID = U.FPersonId LEFT OUTER JOINT_PM_Security Security ON Security.FID = U.FSecurityID LEFT OUTER JOIN T_ORG_BaseUnit BaseUnit ONBaseUnit.FID = U.FDefOrgUnitID LEFTOUTER JOIN T_ORG_CtrlUnit CtrlUnit ON CtrlUnit.FID = U.FControlUnitID WHERE UPPER(U.FNumber) = ? AND U.FIsDelete = 0 Caused exception message is:ORA-00904: "SECURITY"."FREQUIRESPECIALCHAR": invalid identifier atcom.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:226) atcom.kingdee.eas.base.permission.app.util.UserInfoUtils.getUserInfo4LoinModule(UserInfoUtils.java:76) 
