流程中选择流转弹出的组织机构今天突然没了

shuaigej

如图:


什么都没改，用户还是部门内用户，后台没有抱错

jishuang

所有的流程都没有了？

shuaigej

是啊

jishuang

确认tomcat的控制台是否报错

shuaigej

没抱错，上面说过了

jishuang

参考http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把sql语句打出来看看执行的sql

shuaigej

2016-06-21 12:42:23 [SQL Time]sql 执行时间：2ms, exec KSQL: select customGroup as sID, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         from SA_OPCustomGroup customGroup                 optional join SA_ResourceControl range1                         on range1.sTypeID = 'customGroup_range' and range1.sResourceID = customGroup         where ((customGroup.sTypeID = 'private' and customGroup.sCreatorID = :currentPersonID())                         or (customGroup.sTypeID = 'public' and (range1 is null or (((((range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos/o9oWNgKlseTOcrKSpKn@ZWTlQIGN0jkzYKuhyJe.psm'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt'))or(range1.sOrgFID = '/AKLwWiuMzZ7A1mIVET2.ogn')))))         group by customGroup, customGroup.sName, customGroup.sTypeID, customGroup.sSequence         order by customGroup.sTypeID, customGroup.sSequence
  --> sql:SELECT  customGroup.sID AS sID, customGroup.SNAME AS sName, customGroup.STYPEID AS sTypeID, customGroup.SSEQUENCE AS sSequence FROM SA_OPCustomGroup customGroup LEFT JOIN SA_ResourceControl range1 ON  (range1.STYPEID = ?) AND (range1.sResourceID = customGroup.sID)   WHERE  ( (customGroup.STYPEID = ?) AND (customGroup.SCREATORID =  ? ) ) OR ( (customGroup.STYPEID = ?) AND ( (range1.sID IS NULL) OR ( ( ( (range1.SORGFID = ?) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) OR (range1.SORGFID = ?) ) ) )    GROUP BY customGroup.sID, customGroup.SNAME, customGroup.STYPEID, customGroup.SSEQUENCE  ORDER BY customGroup.STYPEID ASC, customGroup.SSEQUENCE ASC
--> binds:[customGroup_range, private, o9oWNgKlseTOcrKSpKn, public, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos/o9oWNgKlseTOcrKSpKn@ZWTlQIGN0jkzYKuhyJe.psm, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt/ZWTlQIGN0jkzYKuhyJe.pos, /AKLwWiuMzZ7A1mIVET2.ogn/saNevp3k9yRy58boak7.dpt, /AKLwWiuMzZ7A1mIVET2.ogn]
2016-06-21 12:42:23 [SQL Time]sql 执行时间：0ms, exec KSQL: SELECT SA_OPOrg.*, member1.sResourceID as groupID, member1 as memberID   FROM SA_OPOrg SA_OPOrg join SA_ResourceControl member1 on SA_OPOrg.sFID = member1.sOrgFID  and member1.sTypeID = 'customGroup_member'         and member1.sResourceID in ('') WHERE (SA_OPOrg.sValidState >= 0) AND ((SA_OPOrg.sValidState=1)) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
  --> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID FROM SA_OPOrg SA_OPOrg JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN (?) )   WHERE  (SA_OPOrg.SVALIDSTATE >= ?) AND (SA_OPOrg.SVALIDSTATE = ?)   ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[customGroup_member, , 0, 1]

jishuang

SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.SWXDEPTID AS sWxDeptID, SA_OPOrg.VERSION AS version, member1.sResourceID AS groupID, member1.sID AS memberID FROM SA_OPOrg SA_OPOrg JOIN SA_ResourceControl member1 ON  (SA_OPOrg.sFID = member1.SORGFID) AND (member1.STYPEID = ?) AND ( member1.sResourceID IN ('customGroup_member') )   WHERE  (SA_OPOrg.SVALIDSTATE >= 0) AND (SA_OPOrg.SVALIDSTATE = 1)   ORDER BY SA_OPOrg.SSEQUENCE ASC

到数据库中执行看看是否能查出数据

shuaigej

查不到

jishuang

你好楼主，该问题准备远程。（待远程）