执行规则表达式在自动流转的时候报错

星辰

流程文件中执行规则为：findOrgUnitsHasRoleByCode('rlzyfw', currentOgnID(), false)，角色  人力资源发文分给了当前机构的人力资源部。 流转用js写的advance（），点击按钮时报错：任务"公司人事审核:项目人员调配"必须指定执行者编码：JUSTEP180197   
sql执行如下：
2018-11-28 18:36:09 [SQL Time]sql 执行时间：6ms, exec KSQL: select SA_Task.sName, SA_Task.sProcess, SA_Task.sActivity, SA_Task.sFlowID from SA_Task SA_Task where SA_Task='19638BA1770A4A959486D00C5666A899'
  --> sql:SELECT  SA_Task.SNAME AS sName, SA_Task.SPROCESS AS sProcess, SA_Task.SACTIVITY AS sActivity, SA_Task.SFLOWID AS sFlowID FROM SA_Task SA_Task  WHERE SA_Task.sID = ?
--> binds:[19638BA1770A4A959486D00C5666A899]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：7ms, ksql:select SA_Task.sName, SA_Task.sProcess, SA_Task.sActivity, SA_Task.sFlowID from SA_Task SA_Task where SA_Task='19638BA1770A4A959486D00C5666A899'
2018-11-28 18:36:09 [SQL Time]sql 执行时间：10ms, exec KSQL: select t.sFlowID, t.sProcess, t.sActivity, t.sName from SA_Task t where t=:task
  --> sql:SELECT  t.SFLOWID AS sFlowID, t.SPROCESS AS sProcess, t.SACTIVITY AS sActivity, t.SNAME AS sName FROM SA_Task t  WHERE t.sID =  ?
--> binds:[19638BA1770A4A959486D00C5666A899]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：11ms, ksql:select t.sFlowID, t.sProcess, t.sActivity, t.sName from SA_Task t where t=:task
2018-11-28 18:36:09 [SQL Time]sql 执行时间：9ms, exec KSQL: select t,t.sCustomerID,t.sWithdraw,t.sStatusID,t.sActualFinishTime,t.sPlanName,t.sVariable,t.sProcessTemplateItemSequence,t.sSummary,t.sFlowID,t.sAIStatusName,t.sDistributeTime,t.sETField32,t.sExecutorPosName,t.sStatusName,t.sETField31,t.sCreatorFName,t.sEDField21,t.sCreatorOgnName,t.sEDField24,t.sEIField41,t.sEIField42,t.sEDField22,t.sEIField43,t.sEDField23,t.sEIField44,t.sETField34,t.version,t.sETField33,t.sExpectFinishTime,t.sExecutorPersonName,t.sData2,t.sTypeName,t.sExecutorOgnName,t.sData1,t.sData4,t.sCreatorDeptName,t.sData3,t.sActivityNames,t.sCreatorPosName,t.sAIID,t.sLock,t.sActivity,t.sExpectStartTime,t.sProcessTemplateID2,t.sENField13,t.sENField14,t.sPlanID,t.sActive,t.sActivityInTemplate,t.sSequence,t.sKindID,t.sProcessName,t.sExecutorOgnID,t.sImportanceName,t.sCreatorPersonID,t.sCURL,t.sENField11,t.sENField12,t.sCode,t.sHints,t.sCreatorOgnID,t.sExecutorNames,t.sParent,t.fBR_BD_travelExpensePro,t.sEmergencyName,t.sESField03,t.sTypeID,t.sESField04,t.sESField05,t.sESField06,t.sESField01,t.sESField02,t.sContent,t.sProcess,t.sExecuteMode,t.sCreatorPersonName,t.sCreateTime,t.sLimitTime,t.sWarningTime,t.sTempPermissionID,t.sSourceID,t.sEURL,t.sImportanceID,t.sCreatorPosID,t.sLastModifyTime,t.sESField07,t.sESField08,t.sExecutorPosID,t.sCreatorDeptID,t.sExecutorPersonID,t.sExecuteTime,t.sEBField51,t.sEBField52,t.sExecutorFName,t.sEBField53,t.sEBField54,t.sCreatorFID,t.sEmergencyID,t.sRemark,t.sAIStatusID,t.sActualStartTime,t.sCustomerName,t.sExecutorFID,t.sProjectID,t.sResponsible,t.sFrontID,t.sPreemptMode,t.sExecutorDeptName,t.sAIActive,t.sExecuteMode2,t.sName,t.sRemindMode,t.sProcessTemplateID,t.sExecutorDeptID,t.sCatalogID,t.sShortcut,t.sActivityName,t.sProjectName from SA_Task t  where  t.sFlowID = :flowID
  --> sql:SELECT  t.sID, t.SCUSTOMERID AS sCustomerID, t.SWITHDRAW AS sWithdraw, t.SSTATUSID AS sStatusID, t.SACTUALFINISHTIME AS sActualFinishTime, t.SPLANNAME AS sPlanName, t.SVARIABLE AS sVariable, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SSUMMARY AS sSummary, t.SFLOWID AS sFlowID, t.SAISTATUSNAME AS sAIStatusName, t.SDISTRIBUTETIME AS sDistributeTime, t.SETFIELD32 AS sETField32, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSTATUSNAME AS sStatusName, t.SETFIELD31 AS sETField31, t.SCREATORFNAME AS sCreatorFName, t.SEDFIELD21 AS sEDField21, t.SCREATOROGNNAME AS sCreatorOgnName, t.SEDFIELD24 AS sEDField24, t.SEIFIELD41 AS sEIField41, t.SEIFIELD42 AS sEIField42, t.SEDFIELD22 AS sEDField22, t.SEIFIELD43 AS sEIField43, t.SEDFIELD23 AS sEDField23, t.SEIFIELD44 AS sEIField44, t.SETFIELD34 AS sETField34, t.VERSION AS version, t.SETFIELD33 AS sETField33, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SDATA2 AS sData2, t.STYPENAME AS sTypeName, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SDATA1 AS sData1, t.SDATA4 AS sData4, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SDATA3 AS sData3, t.SACTIVITYNAMES AS sActivityNames, t.SCREATORPOSNAME AS sCreatorPosName, t.SAIID AS sAIID, t.SLOCK AS sLock, t.SACTIVITY AS sActivity, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SENFIELD13 AS sENField13, t.SENFIELD14 AS sENField14, t.SPLANID AS sPlanID, t.SACTIVE AS sActive, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SSEQUENCE AS sSequence, t.SKINDID AS sKindID, t.SPROCESSNAME AS sProcessName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SIMPORTANCENAME AS sImportanceName, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SENFIELD11 AS sENField11, t.SENFIELD12 AS sENField12, t.SCODE AS sCode, t.SHINTS AS sHints, t.SCREATOROGNID AS sCreatorOgnID, t.SEXECUTORNAMES AS sExecutorNames, t.sParentID AS sParent, t.FBR_BD_TRAVELEXPENSEPRO AS fBR_BD_travelExpensePro, t.SEMERGENCYNAME AS sEmergencyName, t.SESFIELD03 AS sESField03, t.STYPEID AS sTypeID, t.SESFIELD04 AS sESField04, t.SESFIELD05 AS sESField05, t.SESFIELD06 AS sESField06, t.SESFIELD01 AS sESField01, t.SESFIELD02 AS sESField02, t.SCONTENT AS sContent, t.SPROCESS AS sProcess, t.SEXECUTEMODE AS sExecuteMode, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SCREATETIME AS sCreateTime, t.SLIMITTIME AS sLimitTime, t.SWARNINGTIME AS sWarningTime, t.STEMPPERMISSIONID AS sTempPermissionID, t.SSOURCEID AS sSourceID, t.SEURL AS sEURL, t.SIMPORTANCEID AS sImportanceID, t.SCREATORPOSID AS sCreatorPosID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SESFIELD07 AS sESField07, t.SESFIELD08 AS sESField08, t.SEXECUTORPOSID AS sExecutorPosID, t.SCREATORDEPTID AS sCreatorDeptID, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SEXECUTETIME AS sExecuteTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEXECUTORFNAME AS sExecutorFName, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORFID AS sCreatorFID, t.SEMERGENCYID AS sEmergencyID, t.SREMARK AS sRemark, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SCUSTOMERNAME AS sCustomerName, t.SEXECUTORFID AS sExecutorFID, t.SPROJECTID AS sProjectID, t.SRESPONSIBLE AS sResponsible, t.SFRONTID AS sFrontID, t.SPREEMPTMODE AS sPreemptMode, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SAIACTIVE AS sAIActive, t.SEXECUTEMODE2 AS sExecuteMode2, t.SNAME AS sName, t.SREMINDMODE AS sRemindMode, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SCATALOGID AS sCatalogID, t.SSHORTCUT AS sShortcut, t.SACTIVITYNAME AS sActivityName, t.SPROJECTNAME AS sProjectName FROM SA_Task t  WHERE t.SFLOWID =  ?
--> binds:[2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：15ms, ksql:select t,t.sCustomerID,t.sWithdraw,t.sStatusID,t.sActualFinishTime,t.sPlanName,t.sVariable,t.sProcessTemplateItemSequence,t.sSummary,t.sFlowID,t.sAIStatusName,t.sDistributeTime,t.sETField32,t.sExecutorPosName,t.sStatusName,t.sETField31,t.sCreatorFName,t.sEDField21,t.sCreatorOgnName,t.sEDField24,t.sEIField41,t.sEIField42,t.sEDField22,t.sEIField43,t.sEDField23,t.sEIField44,t.sETField34,t.version,t.sETField33,t.sExpectFinishTime,t.sExecutorPersonName,t.sData2,t.sTypeName,t.sExecutorOgnName,t.sData1,t.sData4,t.sCreatorDeptName,t.sData3,t.sActivityNames,t.sCreatorPosName,t.sAIID,t.sLock,t.sActivity,t.sExpectStartTime,t.sProcessTemplateID2,t.sENField13,t.sENField14,t.sPlanID,t.sActive,t.sActivityInTemplate,t.sSequence,t.sKindID,t.sProcessName,t.sExecutorOgnID,t.sImportanceName,t.sCreatorPersonID,t.sCURL,t.sENField11,t.sENField12,t.sCode,t.sHints,t.sCreatorOgnID,t.sExecutorNames,t.sParent,t.fBR_BD_travelExpensePro,t.sEmergencyName,t.sESField03,t.sTypeID,t.sESField04,t.sESField05,t.sESField06,t.sESField01,t.sESField02,t.sContent,t.sProcess,t.sExecuteMode,t.sCreatorPersonName,t.sCreateTime,t.sLimitTime,t.sWarningTime,t.sTempPermissionID,t.sSourceID,t.sEURL,t.sImportanceID,t.sCreatorPosID,t.sLastModifyTime,t.sESField07,t.sESField08,t.sExecutorPosID,t.sCreatorDeptID,t.sExecutorPersonID,t.sExecuteTime,t.sEBField51,t.sEBField52,t.sExecutorFName,t.sEBField53,t.sEBField54,t.sCreatorFID,t.sEmergencyID,t.sRemark,t.sAIStatusID,t.sActualStartTime,t.sCustomerName,t.sExecutorFID,t.sProjectID,t.sResponsible,t.sFrontID,t.sPreemptMode,t.sExecutorDeptName,t.sAIActive,t.sExecuteMode2,t.sName,t.sRemindMode,t.sProcessTemplateID,t.sExecutorDeptID,t.sCatalogID,t.sShortcut,t.sActivityName,t.sProjectName from SA_Task t  where  t.sFlowID = :flowID
2018-11-28 18:36:09 [SQL Time]sql 执行时间：12ms, exec KSQL: select tr.sTaskID1, tr.sTaskID2 from SA_TaskRelation tr where tr.sTaskID1=:tid0 or tr.sTaskID1=:tid1
  --> sql:SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TASKRELATION tr  WHERE  (tr.STASKID1 =  ? ) OR (tr.STASKID1 =  ? )
--> binds:[19638BA1770A4A959486D00C5666A899, 2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：12ms, ksql:select tr.sTaskID1, tr.sTaskID2 from SA_TaskRelation tr where tr.sTaskID1=:tid0 or tr.sTaskID1=:tid1
2018-11-28 18:36:09 [SQL Time]sql 执行时间：7ms, exec KSQL: select t, t.sProcessTemplateID2, t.sProcess, t.sProcessInstanceID, t.sPlace, t.sFromActivity, t.sFromActivityInstanceID, t.sToActivity, t.sToActivityInstanceID, t.sValue, t.sActive from SA_TokenInstance t where t.sProcessInstanceID = :flowID
  --> sql:SELECT  t.sID, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SPROCESS AS sProcess, t.SPROCESSINSTANCEID AS sProcessInstanceID, t.SPLACE AS sPlace, t.SFROMACTIVITY AS sFromActivity, t.SFROMACTIVITYINSTANCEID AS sFromActivityInstanceID, t.STOACTIVITY AS sToActivity, t.STOACTIVITYINSTANCEID AS sToActivityInstanceID, t.SVALUE AS sValue, t.SACTIVE AS sActive FROM SA_TokenInstance t  WHERE t.SPROCESSINSTANCEID =  ?
--> binds:[2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：9ms, ksql:select t, t.sProcessTemplateID2, t.sProcess, t.sProcessInstanceID, t.sPlace, t.sFromActivity, t.sFromActivityInstanceID, t.sToActivity, t.sToActivityInstanceID, t.sValue, t.sActive from SA_TokenInstance t where t.sProcessInstanceID = :flowID
2018-11-28 18:36:09 [SQL Time]sql 执行时间：11ms, exec KSQL: select role1 from SA_OPRole role1 where role1.sValidState=1 and ((role1.sCode='rlzyfw'))
  --> sql:SELECT  role1.sID FROM SA_OPRole role1  WHERE  (role1.SVALIDSTATE = ?) AND (role1.SCODE = ?)
--> binds:[1, rlzyfw]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：12ms, ksql:select role1 from SA_OPRole role1 where role1.sValidState=1 and ((role1.sCode='rlzyfw'))
2018-11-28 18:36:09 [SQL Time]sql 执行时间：6ms, exec KSQL: select org.sFID, org.sFName from SA_OPOrg org where org.sValidState=1  and ((org='6CD53DA5315240CD8406B14276776FA5') or (org.sPersonID='6CD53DA5315240CD8406B14276776FA5')) order by org.sSequence
  --> sql:SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTATE = ?) AND ( (org.sID = ?) OR (org.SPERSONID = ?) )   ORDER BY org.SSEQUENCE ASC
--> binds:[1, 6CD53DA5315240CD8406B14276776FA5, 6CD53DA5315240CD8406B14276776FA5]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：8ms, ksql:select org.sFID, org.sFName from SA_OPOrg org where org.sValidState=1  and ((org='6CD53DA5315240CD8406B14276776FA5') or (org.sPersonID='6CD53DA5315240CD8406B14276776FA5')) order by org.sSequence
2018-11-28 18:36:09 [SQL Time]sql 执行时间：8ms, exec KSQL: select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='E60B57B7427C4B359E2C041A9D33BCF6')) order by org.sSequence
  --> sql:SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org JOIN SA_OPAuthorize auth ON org.sFID LIKE auth.SORGFID || ?  WHERE  (org.SVALIDSTATE = ?) AND (auth.sAuthorizeRoleID = ?)   ORDER BY org.SSEQUENCE ASC
--> binds:[%, 1, E60B57B7427C4B359E2C041A9D33BCF6]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：27ms, ksql:select org.sFID, org.sFName from SA_OPOrg org join SA_OPAuthorize auth on org.sFID like concat(auth.sOrgFID, '%') where org.sValidState=1  and ((auth.sAuthorizeRoleID='E60B57B7427C4B359E2C041A9D33BCF6')) order by org.sSequence
2018-11-28 18:36:09 [SQL Time]sql 执行时间：9ms, exec KSQL: select c.sContent from SA_ProcessControl c where c.sProcess='/PMS/Organization/process/ProjectPersonDeploy/ProjectPersonDeployProcess' and c.sActivity='selectTakeOfficePerson' and c.sOperatorID='3421CF19BC5A46BEAE8B526F3032120E' and c.sAction='advanceProcessAction' and (c.sProcessTemplateID2 IS NULL or c.sProcessTemplateID2 = '')
  --> sql:SELECT  c.SCONTENT AS sContent FROM SA_ProcessControl c  WHERE  (c.SPROCESS = ?) AND (c.SACTIVITY = ?) AND (c.SOPERATORID = ?) AND (c.SACTION = ?) AND ( (c.SPROCESSTEMPLATEID2 IS NULL) OR (c.SPROCESSTEMPLATEID2 = ?) )
--> binds:[/PMS/Organization/process/ProjectPersonDeploy/ProjectPersonDeployProcess, selectTakeOfficePerson, 3421CF19BC5A46BEAE8B526F3032120E, advanceProcessAction, ]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：10ms, ksql:select c.sContent from SA_ProcessControl c where c.sProcess='/PMS/Organization/process/ProjectPersonDeploy/ProjectPersonDeployProcess' and c.sActivity='selectTakeOfficePerson' and c.sOperatorID='3421CF19BC5A46BEAE8B526F3032120E' and c.sAction='advanceProcessAction' and (c.sProcessTemplateID2 IS NULL or c.sProcessTemplateID2 = '')
2018-11-28 18:36:09 [SQL Time]sql 执行时间：4ms, exec KSQL: select t.sFlowID, t.sProcess, t.sActivity, t.sName from SA_Task t where t=:task
  --> sql:SELECT  t.SFLOWID AS sFlowID, t.SPROCESS AS sProcess, t.SACTIVITY AS sActivity, t.SNAME AS sName FROM SA_Task t  WHERE t.sID =  ?
--> binds:[19638BA1770A4A959486D00C5666A899]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：5ms, ksql:select t.sFlowID, t.sProcess, t.sActivity, t.sName from SA_Task t where t=:task
2018-11-28 18:36:09 [SQL Time]sql 执行时间：110ms, exec KSQL: select t,t.sCustomerID,t.sWithdraw,t.sStatusID,t.sActualFinishTime,t.sPlanName,t.sVariable,t.sProcessTemplateItemSequence,t.sSummary,t.sFlowID,t.sAIStatusName,t.sDistributeTime,t.sETField32,t.sExecutorPosName,t.sStatusName,t.sETField31,t.sCreatorFName,t.sEDField21,t.sCreatorOgnName,t.sEDField24,t.sEIField41,t.sEIField42,t.sEDField22,t.sEIField43,t.sEDField23,t.sEIField44,t.sETField34,t.version,t.sETField33,t.sExpectFinishTime,t.sExecutorPersonName,t.sData2,t.sTypeName,t.sExecutorOgnName,t.sData1,t.sData4,t.sCreatorDeptName,t.sData3,t.sActivityNames,t.sCreatorPosName,t.sAIID,t.sLock,t.sActivity,t.sExpectStartTime,t.sProcessTemplateID2,t.sENField13,t.sENField14,t.sPlanID,t.sActive,t.sActivityInTemplate,t.sSequence,t.sKindID,t.sProcessName,t.sExecutorOgnID,t.sImportanceName,t.sCreatorPersonID,t.sCURL,t.sENField11,t.sENField12,t.sCode,t.sHints,t.sCreatorOgnID,t.sExecutorNames,t.sParent,t.fBR_BD_travelExpensePro,t.sEmergencyName,t.sESField03,t.sTypeID,t.sESField04,t.sESField05,t.sESField06,t.sESField01,t.sESField02,t.sContent,t.sProcess,t.sExecuteMode,t.sCreatorPersonName,t.sCreateTime,t.sLimitTime,t.sWarningTime,t.sTempPermissionID,t.sSourceID,t.sEURL,t.sImportanceID,t.sCreatorPosID,t.sLastModifyTime,t.sESField07,t.sESField08,t.sExecutorPosID,t.sCreatorDeptID,t.sExecutorPersonID,t.sExecuteTime,t.sEBField51,t.sEBField52,t.sExecutorFName,t.sEBField53,t.sEBField54,t.sCreatorFID,t.sEmergencyID,t.sRemark,t.sAIStatusID,t.sActualStartTime,t.sCustomerName,t.sExecutorFID,t.sProjectID,t.sResponsible,t.sFrontID,t.sPreemptMode,t.sExecutorDeptName,t.sAIActive,t.sExecuteMode2,t.sName,t.sRemindMode,t.sProcessTemplateID,t.sExecutorDeptID,t.sCatalogID,t.sShortcut,t.sActivityName,t.sProjectName from SA_Task t  where  t.sFlowID = :flowID
  --> sql:SELECT  t.sID, t.SCUSTOMERID AS sCustomerID, t.SWITHDRAW AS sWithdraw, t.SSTATUSID AS sStatusID, t.SACTUALFINISHTIME AS sActualFinishTime, t.SPLANNAME AS sPlanName, t.SVARIABLE AS sVariable, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SSUMMARY AS sSummary, t.SFLOWID AS sFlowID, t.SAISTATUSNAME AS sAIStatusName, t.SDISTRIBUTETIME AS sDistributeTime, t.SETFIELD32 AS sETField32, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSTATUSNAME AS sStatusName, t.SETFIELD31 AS sETField31, t.SCREATORFNAME AS sCreatorFName, t.SEDFIELD21 AS sEDField21, t.SCREATOROGNNAME AS sCreatorOgnName, t.SEDFIELD24 AS sEDField24, t.SEIFIELD41 AS sEIField41, t.SEIFIELD42 AS sEIField42, t.SEDFIELD22 AS sEDField22, t.SEIFIELD43 AS sEIField43, t.SEDFIELD23 AS sEDField23, t.SEIFIELD44 AS sEIField44, t.SETFIELD34 AS sETField34, t.VERSION AS version, t.SETFIELD33 AS sETField33, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SDATA2 AS sData2, t.STYPENAME AS sTypeName, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SDATA1 AS sData1, t.SDATA4 AS sData4, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SDATA3 AS sData3, t.SACTIVITYNAMES AS sActivityNames, t.SCREATORPOSNAME AS sCreatorPosName, t.SAIID AS sAIID, t.SLOCK AS sLock, t.SACTIVITY AS sActivity, t.SEXPECTSTARTTIME AS sExpectStartTime, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SENFIELD13 AS sENField13, t.SENFIELD14 AS sENField14, t.SPLANID AS sPlanID, t.SACTIVE AS sActive, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SSEQUENCE AS sSequence, t.SKINDID AS sKindID, t.SPROCESSNAME AS sProcessName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SIMPORTANCENAME AS sImportanceName, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SENFIELD11 AS sENField11, t.SENFIELD12 AS sENField12, t.SCODE AS sCode, t.SHINTS AS sHints, t.SCREATOROGNID AS sCreatorOgnID, t.SEXECUTORNAMES AS sExecutorNames, t.sParentID AS sParent, t.FBR_BD_TRAVELEXPENSEPRO AS fBR_BD_travelExpensePro, t.SEMERGENCYNAME AS sEmergencyName, t.SESFIELD03 AS sESField03, t.STYPEID AS sTypeID, t.SESFIELD04 AS sESField04, t.SESFIELD05 AS sESField05, t.SESFIELD06 AS sESField06, t.SESFIELD01 AS sESField01, t.SESFIELD02 AS sESField02, t.SCONTENT AS sContent, t.SPROCESS AS sProcess, t.SEXECUTEMODE AS sExecuteMode, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SCREATETIME AS sCreateTime, t.SLIMITTIME AS sLimitTime, t.SWARNINGTIME AS sWarningTime, t.STEMPPERMISSIONID AS sTempPermissionID, t.SSOURCEID AS sSourceID, t.SEURL AS sEURL, t.SIMPORTANCEID AS sImportanceID, t.SCREATORPOSID AS sCreatorPosID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SESFIELD07 AS sESField07, t.SESFIELD08 AS sESField08, t.SEXECUTORPOSID AS sExecutorPosID, t.SCREATORDEPTID AS sCreatorDeptID, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SEXECUTETIME AS sExecuteTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEXECUTORFNAME AS sExecutorFName, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORFID AS sCreatorFID, t.SEMERGENCYID AS sEmergencyID, t.SREMARK AS sRemark, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SCUSTOMERNAME AS sCustomerName, t.SEXECUTORFID AS sExecutorFID, t.SPROJECTID AS sProjectID, t.SRESPONSIBLE AS sResponsible, t.SFRONTID AS sFrontID, t.SPREEMPTMODE AS sPreemptMode, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SAIACTIVE AS sAIActive, t.SEXECUTEMODE2 AS sExecuteMode2, t.SNAME AS sName, t.SREMINDMODE AS sRemindMode, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SCATALOGID AS sCatalogID, t.SSHORTCUT AS sShortcut, t.SACTIVITYNAME AS sActivityName, t.SPROJECTNAME AS sProjectName FROM SA_Task t  WHERE t.SFLOWID =  ?
--> binds:[2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：117ms, ksql:select t,t.sCustomerID,t.sWithdraw,t.sStatusID,t.sActualFinishTime,t.sPlanName,t.sVariable,t.sProcessTemplateItemSequence,t.sSummary,t.sFlowID,t.sAIStatusName,t.sDistributeTime,t.sETField32,t.sExecutorPosName,t.sStatusName,t.sETField31,t.sCreatorFName,t.sEDField21,t.sCreatorOgnName,t.sEDField24,t.sEIField41,t.sEIField42,t.sEDField22,t.sEIField43,t.sEDField23,t.sEIField44,t.sETField34,t.version,t.sETField33,t.sExpectFinishTime,t.sExecutorPersonName,t.sData2,t.sTypeName,t.sExecutorOgnName,t.sData1,t.sData4,t.sCreatorDeptName,t.sData3,t.sActivityNames,t.sCreatorPosName,t.sAIID,t.sLock,t.sActivity,t.sExpectStartTime,t.sProcessTemplateID2,t.sENField13,t.sENField14,t.sPlanID,t.sActive,t.sActivityInTemplate,t.sSequence,t.sKindID,t.sProcessName,t.sExecutorOgnID,t.sImportanceName,t.sCreatorPersonID,t.sCURL,t.sENField11,t.sENField12,t.sCode,t.sHints,t.sCreatorOgnID,t.sExecutorNames,t.sParent,t.fBR_BD_travelExpensePro,t.sEmergencyName,t.sESField03,t.sTypeID,t.sESField04,t.sESField05,t.sESField06,t.sESField01,t.sESField02,t.sContent,t.sProcess,t.sExecuteMode,t.sCreatorPersonName,t.sCreateTime,t.sLimitTime,t.sWarningTime,t.sTempPermissionID,t.sSourceID,t.sEURL,t.sImportanceID,t.sCreatorPosID,t.sLastModifyTime,t.sESField07,t.sESField08,t.sExecutorPosID,t.sCreatorDeptID,t.sExecutorPersonID,t.sExecuteTime,t.sEBField51,t.sEBField52,t.sExecutorFName,t.sEBField53,t.sEBField54,t.sCreatorFID,t.sEmergencyID,t.sRemark,t.sAIStatusID,t.sActualStartTime,t.sCustomerName,t.sExecutorFID,t.sProjectID,t.sResponsible,t.sFrontID,t.sPreemptMode,t.sExecutorDeptName,t.sAIActive,t.sExecuteMode2,t.sName,t.sRemindMode,t.sProcessTemplateID,t.sExecutorDeptID,t.sCatalogID,t.sShortcut,t.sActivityName,t.sProjectName from SA_Task t  where  t.sFlowID = :flowID
2018-11-28 18:36:09 [SQL Time]sql 执行时间：8ms, exec KSQL: select tr.sTaskID1, tr.sTaskID2 from SA_TaskRelation tr where tr.sTaskID1=:tid0 or tr.sTaskID1=:tid1
  --> sql:SELECT  tr.STASKID1 AS sTaskID1, tr.STASKID2 AS sTaskID2 FROM SA_TASKRELATION tr  WHERE  (tr.STASKID1 =  ? ) OR (tr.STASKID1 =  ? )
--> binds:[19638BA1770A4A959486D00C5666A899, 2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：11ms, ksql:select tr.sTaskID1, tr.sTaskID2 from SA_TaskRelation tr where tr.sTaskID1=:tid0 or tr.sTaskID1=:tid1
2018-11-28 18:36:09 [SQL Time]sql 执行时间：10ms, exec KSQL: select t, t.sProcessTemplateID2, t.sProcess, t.sProcessInstanceID, t.sPlace, t.sFromActivity, t.sFromActivityInstanceID, t.sToActivity, t.sToActivityInstanceID, t.sValue, t.sActive from SA_TokenInstance t where t.sProcessInstanceID = :flowID
  --> sql:SELECT  t.sID, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SPROCESS AS sProcess, t.SPROCESSINSTANCEID AS sProcessInstanceID, t.SPLACE AS sPlace, t.SFROMACTIVITY AS sFromActivity, t.SFROMACTIVITYINSTANCEID AS sFromActivityInstanceID, t.STOACTIVITY AS sToActivity, t.STOACTIVITYINSTANCEID AS sToActivityInstanceID, t.SVALUE AS sValue, t.SACTIVE AS sActive FROM SA_TokenInstance t  WHERE t.SPROCESSINSTANCEID =  ?
--> binds:[2C2B8FA6ED6C4E488DF4599F8F81E156]
2018-11-28 18:36:09 [KSQL Time]sql 执行时间：14ms, ksql:select t, t.sProcessTemplateID2, t.sProcess, t.sProcessInstanceID, t.sPlace, t.sFromActivity, t.sFromActivityInstanceID, t.sToActivity, t.sToActivityInstanceID, t.sValue, t.sActive from SA_TokenInstance t where t.sProcessInstanceID = :flowID
2018-11-28 18:36:09 excute stream action, params:{"actions":[{"accept":"application/json","action":"externalAdvanceProcessAction","actionFlag":"__action_0__","activity":"selectTakeOfficePerson","contentType":"application/json","executeContext":"","executor":"/A966540DAF5A4F35AD31286344102BA5.ogn/6CD53DA5315240CD8406B14276776FA5.ogn/CD7D338D507E40DDB8B7FA151ACD5C6A.dpt/74355B0FC76F415B83C959900950A747.dpt/7AADFE672CA841F2AE36FD7E3A207BCA.pos/3421CF19BC5A46BEAE8B526F3032120E@7AADFE672CA841F2AE36FD7E3A207BCA.psm","parameters":{"task":"19638BA1770A4A959486D00C5666A899"},"process":"/PMS/Organization/process/ProjectPersonDeploy/ProjectPersonDeployProcess"}]}

其中SA_TokenInstance这个sql的执行结果为null   请教怎么回事

jishuang

SELECT  role1.sID FROM SA_OPRole role1  WHERE  (role1.SVALIDSTATE = 1) AND (role1.SCODE = 'rlzyfw')

SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org  WHERE  (org.SVALIDSTATE = 1) AND ( (org.sID = '6CD53DA5315240CD8406B14276776FA5') OR (org.SPERSONID = '6CD53DA5315240CD8406B14276776FA5') )   ORDER BY org.SSEQUENCE ASC

SELECT  org.sFID AS sFID, org.sFName AS sFName FROM SA_OPOrg org JOIN SA_OPAuthorize auth ON org.sFID LIKE auth.SORGFID || '%'  WHERE  (org.SVALIDSTATE = 1) AND (auth.sAuthorizeRoleID = 'E60B57B7427C4B359E2C041A9D33BCF6')   ORDER BY org.SSEQUENCE ASC


到数据库执行看看查出的什么数据

星辰

jishuang 发表于 2018-11-29 09:05
SELECT  role1.sID FROM SA_OPRole role1  WHERE  (role1.SVALIDSTATE = 1) AND (role1.SCODE = 'rlzyfw')  ...

第一条查出了角色的id，第二条查出了当前机构，第三条查出了所有拥有这个角色的组织

jishuang

那就应该可以，确认设置的是表达式，不是范围表达式？

星辰

jishuang 发表于 2018-11-29 11:14
那就应该可以，确认设置的是表达式，不是范围表达式？

设置的是范围表达式，难道要设置到表达式上？

jishuang

范围表达式是设置弹出来的流转对话框中的可以选择的组织范围，不是设置的默认执行者
要设置默认执行者需要在表达式上设置

星辰

jishuang 发表于 2018-11-29 13:52
范围表达式是设置弹出来的流转对话框中的可以选择的组织范围，不是设置的默认执行者
要设置默认执行者需要 ...

哦哦  谢谢  我之前理解成范围表达式是流转给组织范围了