求助：sql执行超时

wengjw

在执行功能是报以下错误：

取数据的时候出现错误：Lock time out.
SQL Server 连接超时。
连接参数：数据库URL：Biz:\SYSTEM\SYSTEM.Database
SQL语句：select 0 as FILEINDEX, A.*,  (select COUNT(FGUID) from TORGSYSTEM where FPARENTGUID = A.FGUID  and FDELETELEVEL = 0) AS CHILDRENCOUNT from TORGSYSTEM A  where FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FGUID IN (SELECT b.FGUID FROM TORGSYSTEM a, TORGSYSTEM b WHERE a.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FDEPT = 'F08') and (FPOSITION = '' or FPOSITION is null) and (FPERSON = '' or FPERSON is null)) OR FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FDEPT = 'E04') and (FPOSITION = '' or FPOSITION is null) and (FPERSON = '' or FPERSON is null)) OR FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE (FDEPT = 'A07') and (FPOSITION = '' or FPOSITION is null) and (FPERSON = '' or FPERSON is null)))  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.FID + b.FKIND  LIKE '%\' + a.FID + '.PTM' + '\%'))) ) OR ( a.FPATH + a.FID + a.FKIND = b.FPATH + b.FID + b.FKIND )))) AND FGUID IN (SELECT b.FGUID FROM TORGSYSTEM a, TORGSYSTEM b WHERE a.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE FGUID IN (SELECT FGUID FROM TORGINDEX WHERE FGUID in (select FGUID from TORGINDEX where FID = 'ORGUNIT.FUNCREF' and FVALUE = '\SZXX\FUNC\EJJSYWGN.FUNC')))  AND b.FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE FGUID IN (SELECT FGUID FROM TORGSYSTEM WHERE  (FFILENAME LIKE '%.PTM') ))  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.FID + b.FKIND  LIKE '%\' + a.FID + '.PTM' + '\%'))) ) OR ( a.FPATH + a.FID + a.FKIND = b.FPATH + b.FID + b.FKIND )))) and FDELETELEVEL = 0) AND (FDELETELEVEL = 0))

怀疑是系统组织机构相关表的问题，用doctor修复时，doctor无响应。

wengjw

附件为组织机构相关的7个表的数据

wengjw

报错信息

atiger

正在分析，有结果马上跟贴告知，感觉是跟数据有关，

atiger

经过测试，我们这里是正常的，这需要楼主检查数据库了。