【同步工具】861 sqlserver数据库，同步到批量设置上级处报错

问题描述：

     客户的eas版本是861，数据库是sqlserver，同步执行到“批量设置上级”的时候报错，如下图所示：

具体报错为：

Sql1 execute exception : insert into T_PM_EASXTRELATIONSMAP(FID,FLeaderXtId,FXtId,FRelationType,FIsPrimary) (select newbosid('F4AF4F04'),leaderOpenId,openId,'LEADER',FIsPrimary from ( SELECT distinct leader.fxtid leaderOpenId,pmap.fxtid openId,'LEADER',pm.FIsPrimary FIsPrimary FROM T_PM_EASXTUSERMAP pmap left join T_ORG_POSITIONMEMBER pm on pmap.fpersonid = pm.FPERSONID left join T_ORG_POSITION pos on pm.FPOSITIONID = pos.FID left join T_ORG_POSITIONHIERARCHY ph on pm.FPOSITIONID = ph.FCHILDID left join T_ORG_POSITIONMEMBER pm1 on ph.FPARENTID = pm1.FPOSITIONID left join T_ORG_POSITION pos1 on pm1.FPOSITIONID = pos1.FID left join T_PM_EASXTUSERMAP leader on pm1.FPERSONID = leader.FPERSONID where pm.FPOSITIONID != pm1.FPOSITIONID and leader.fpersonid is not null and pmap.fpersonid is not null and leader.fxtid is not null and pmap.fxtid is not null and pmap.FStatus = 1 and ph.FHIERARCHYID = '00000000-0000-0000-0000-000000000001396FCAD0' and not exists(SELECT rela.fid FROM T_PM_EASXTRELATIONSMAP rela where pmap.fxtid = rela.fxtid and leader.fxtid = rela.fleaderxtid))) Caused exception message is: “)”附近有语法错误。

分析解答：

        该问题已有补丁修复，请打同步工具的补丁验证，补丁号：PT164923 （BOS_XTSYNC，发布日期：2022-04-02）。或者打BOS_XTSYNC领域最新补丁，目前861版本同步工具最新补丁是PT167129(发布日期：2022-07-29)。