普元 EOS Platform 7.6 DM7.1 Studio组织机构报错：java.sql.SQLException: 字符串截断

【问题描述】

EOS Platform 7.6 DM7.1 Studio组织机构报错：

[default][2017-08-22 12:30:04,827][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[select '$queryEntityId$' as column1_56_0_, this_.role_id as role2_56_0_, this_.party_type as party3_56_0_, this_.empid as empid56_0_, this_.empcode as empcode56_0_, this_.empname as empname56_0_, this_.sortno as sortno56_0_, this_.tenant_id as tenant8_56_0_ from (select b.role_id, b.party_type, a.empid, a.empcode, a.empname, a.sortno,a.tenant_id
from org_employee a left join cap_partyauth b
on b.party_id=cast(a.empid as char)
where a.tenant_id=b.tenant_id) this_ where this_.tenant_id=? and this_.role_id=? and this_.party_type=? order by this_.sortno asc] execute error.
java.sql.SQLException: 字符串截断

 【问题原因】

coframe代码org.gocom.components.coframe.auth.queryentity.QueryEmpByRole的查询实体中的sql语句问题

【解决方案】

将该查询实体中数据库类型为default的sql改为select b.role_id, b.party_type, a.empid, a.empcode, a.empname, a.sortno,a.tenant_id from org_employee a left join cap_partyauth b on b.party_id=TO_CHAR(a.empid) where a.tenant_id=b.tenant_id即可。

【原文链接】

http://doc.primeton.com/pages/viewpage.action?pageId=61926702