设置流程执行者出错

zqc

限定执行者表达式如下：

OrgKey(GetProcUnitExecutorDept('', True), 'KSJSFZR',  &[Biz:\XAXXHCH\SCAPXX.Info\SCAPSJJ.DataSet\F_DeptTechLeader.DataSetField])

校验时提示没问题，运行时报错（提示缺失括号），不知道如何能跟踪到此处代码？

shangxy

GetProcUnitExecutorDept('', True),
这个取环节执行者所属的部门没有环节，填上个已经执行过环节的id看看

zqc

我试试，不加参数不是代表上一环节么？

zqc

同样的错误：


---------------------------
X3 Studio
---------------------------
运行系统初始化的时候发生异常：在操作文件：Org:的时候出现异常，操作代码：34，异常信息：invoke batch method error, error occur during invoke getRecords method, ORA-00907: 缺失右括号


类型：EFileExecuteAction。
---------------------------
确定   
---------------------------

tangyongbo

看看服务器控制台，又没有错误的sql语句

zqc

有，比较复杂：

CommandText: select 0 as FILEINDEX, A.*,  (select COUNT(FGUID) from TORGSYSTEM where FCLIENTACCOUNT = 'GEOWAY' and FPARENTGUID = A.FGUID  and FD
EVEL = 0) AS CHILDRENCOUNT from TORGSYSTEM A  where FCLIENTACCOUNT = 'GEOWAY' and FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FGUID IN (SELECT
ID FROM TORGSYSTEM b, TORGSYSTEM a where a.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FGUID in (select FGUID from TORGINDEX where UPPER(FID)
UNIT.FUNCREF' and UPPER(FVALUE) = '\XAXXHCH\TZBMJSFZR.FUNC')))  AND b.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE ( (UPPER(FFILENAME) LIKE '%.P
)  AND ((( (b.FPATH LIKE a.FPATH || a.FID || a.FKIND || '\%') OR ((a.FKIND = '.PTN') AND ((b.FID = a.FID AND b.FKIND = '.PTM') OR (b.FPATH || b.
b.FKIND LIKE '%\' || a.FID || '.PTM' || '\%'))) ) OR ( a.FPATH || a.FID || a.FKIND = b.FPATH || b.FID || b.FKIND )))) AND FGUID IN (SELECT FGUI
TORGSYSTEM WHERE (FDEPT = 'FGUID IN (SELECT B.FGUID FROM TORGSYSTEM B, TORGSYSTEM A WHERE A.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE FGUID
LECT FGUID FROM TORGSYSTEM WHERE (FDEPT = 'HCSFY') AND (FPOSITION = '' OR FPOSITION IS NULL) AND (FPERSON = '' OR FPERSON IS NULL)))  AND ((( (B
LIKE A.FPATH || A.FID || A.FKIND || '\%') OR ((A.FKIND = '.PTN') AND ((B.FID = A.FID AND B.FKIND = '.PTM') OR (B.FPATH || B.FID || B.FKIND LIKE
|| A.FID || '.PTM' || '\%'))) ) OR ( A.FPATH || A.FID || A.FKIND = B.FPATH || B.FID || B.FKIND ))))') and (FPOSITION = 'KSJSFZR') and (FPERSON =
) and TO_CHAR(FDELETELEVEL) = 0) AND (FDELETELEVEL = 0))

shangxy

orgkey的参数应该是字符串，这里第一个参数是表达式了。