|
1.组织权限-组织管理报错,提示KSQL语句错误;如果启动BeX5运行平台,则会报该错,但是如果启动调试模式运行就没有该错误。
2.在登录后个人账户处新增了 个人基本资料修改(调取的SA_OPPerson的部分信息),在调试模式完全正常,但在正常模式启动,新增的功能则直接不见了。
版本是BeX5_V3.4_small
1报错内容如下:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: SELECT SA_OPOrg.*,SA_OPPerson as personID,SA_OPPerson.sMail as
sMail,SA_OPPerson.sOfficePhone as sOfficePhone,SA_OPPerson.sMobilePhone as sMob
ilePhone,SA_OPPerson.sName as personName,SA_OPPerson.sCode as personCode,SA_OPPe
rson.sNumb as personNumb,SA_OPPerson.sLoginName as personLoginName,SA_OPPerson.s
Password as personPassword,SA_OPPerson.sMainOrgID as personMainOrgID,SA_OPPerson
.sIDCard as personIDCard,SA_OPPerson.sValidState as personValidState,SA_OPPerson
.version as personVersion,SA_OPPerson.sSex as personSex,'' as ognName,'' as dptN
ame,'' as posName FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerso
n on SA_OPOrg.sPersonID = SA_OPPerson WHERE ((SA_OPOrg.sParent is null) AND (SA_
OPOrg.sValidState = 1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.BizData.query(Unknown Source)
at OrgProcedure.queryOPOrg(OrgProcedure.java:46)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQ
L语法错误, columns中的列levelName必须包含在select查出列中
at com.justep.exception.BusinessException.create(Unknown Source)
--------------------------------------
2.截图如下 |
-
-
|