Windchill Bulk Migrator 中的预加载验证在 SQL Server 上挂起

INSERT INTO PV_ERR_D_LIFECYCLE(NAME,STATE,CONTAINER,CONTAINERTYPE,CONTAINER_ORGANIZATION_NAME) 
SELECT DISTINCT A.LIFECYCLE,A.LIFECYCLESTATE,B.CONTAINER,B.CONTAINERTYPE,B.CONTAINER_ORGANIZATION_NAME 
FROM INT_EPMDOCUMENT A,INT_EPMDOCUMENTMASTER B, INT_EPMDOCUMENTVERSION C 
  WHERE A.VERSIONREFERENCE = C.SEQUENCENUMBER 
    AND C.MASTERREFERENCE = B.SEQUENCENUMBER 
    AND B.MIGRATED = 0 
    AND A.MIGRATED = 0 
    AND A.SEQUENCENUMBER IN ( 
SELECT A.SEQUENCENUMBER 
FROM INT_EPMDOCUMENT A,INT_EPMDOCUMENTMASTER B, INT_EPMDOCUMENTVERSION C 
  WHERE A.VERSIONREFERENCE = C.SEQUENCENUMBER 
    AND C.MASTERREFERENCE = B.SEQUENCENUMBER 
    AND B.MIGRATED = 0 
    AND A.MIGRATED = 0 
    AND NOT EXISTS (
SELECT 1 
FROM SN_LIFECYCLETEMPLATE D 
  WHERE D.NAME = A.LIFECYCLE 
    AND ((D.CONTAINER = B.CONTAINER 
    AND D.CONTAINER_TYPE = B.CONTAINERTYPE 
    AND D.CONTAINER_ORGANIZATION_NAME = B.CONTAINER_ORGANIZATION_NAME) OR (D.CONTAINER = 'Site') OR (D.CONTAINER = B.CONTAINER_ORGANIZATION_NAME)) 
    AND D.ITERATION = (
SELECT MAX(F.ITERATION) from SN_LIFECYCLETEMPLATE F 
  WHERE F.MASTER_OID=D.MASTER_OID) ) UNION( 
SELECT A.SEQUENCENUMBER 
FROM INT_EPMDOCUMENT A,INT_EPMDOCUMENTMASTER B, INT_EPMDOCUMENTVERSION C 
  WHERE A.VERSIONREFERENCE = C.SEQUENCENUMBER 
    AND C.MASTERREFERENCE = B.SEQUENCENUMBER 
    AND B.MIGRATED = 0 
    AND A.MIGRATED = 0 
    AND NOT EXISTS (
SELECT 1 
FROM SN_LIFECYCLETEMPLATE D, SN_LC_PHASE E 
  WHERE D.OID = E.LC_OID 
    AND D.NAME = A.LIFECYCLE 
    AND E.STATE = A.LIFECYCLESTATE 
    AND D.CONTAINER = B.CONTAINER 
    AND D.CONTAINER_TYPE = B.CONTAINERTYPE 
    AND D.CONTAINER_ORGANIZATION_NAME = B.CONTAINER_ORGANIZATION_NAME 
    AND D.ITERATION = (
SELECT MAX(F.ITERATION) from SN_LIFECYCLETEMPLATE F 
  WHERE F.MASTER_OID=D.MASTER_OID) ) INTERSECT 
SELECT A.SEQUENCENUMBER 
FROM INT_EPMDOCUMENT A,INT_EPMDOCUMENTMASTER B, INT_EPMDOCUMENTVERSION C 
  WHERE A.VERSIONREFERENCE = C.SEQUENCENUMBER 
    AND C.MASTERREFERENCE = B.SEQUENCENUMBER 
    AND B.MIGRATED = 0 
    AND A.MIGRATED = 0 
    AND NOT EXISTS (
SELECT 1 
FROM SN_LIFECYCLETEMPLATE D, SN_LC_PHASE E 
  WHERE D.OID = E.LC_OID 
    AND D.NAME = A.LIFECYCLE 
    AND E.STATE = A.LIFECYCLESTATE 
    AND D.CONTAINER = B.CONTAINER_ORGANIZATION_NAME 
    AND D.ITERATION = (
SELECT MAX(F.ITERATION) from SN_LIFECYCLETEMPLATE F 
  WHERE F.MASTER_OID=D.MASTER_OID) ) INTERSECT 
SELECT A.SEQUENCENUMBER 
FROM INT_EPMDOCUMENT A,INT_EPMDOCUMENTMASTER B, INT_EPMDOCUMENTVERSION C 
  WHERE A.VERSIONREFERENCE = C.SEQUENCENUMBER 
    AND C.MASTERREFERENCE = B.SEQUENCENUMBER 
    AND B.MIGRATED = 0 
    AND A.MIGRATED = 0 
    AND NOT EXISTS (
SELECT 1 
FROM SN_LIFECYCLETEMPLATE D, SN_LC_PHASE E 
  WHERE D.OID = E.LC_OID 
    AND D.NAME = A.LIFECYCLE 
    AND E.STATE = A.LIFECYCLESTATE 
    AND D.CONTAINER = 'Site' 
    AND D.ITERATION = (
SELECT MAX(F.ITERATION) from SN_LIFECYCLETEMPLATE F 
  WHERE F.MASTER_OID=D.MASTER_OID) ) ) ) EXCEPT 
SELECT NAME,STATE,CONTAINER,CONTAINERTYPE,CONTAINER_ORGANIZATION_NAME 
FROM PV_ERR_D_LIFECYCLE