アーティクル - CS363890
Windchill Bulk Migrator の SQL Server で事前ロード検証がハングする
修正日: 07-Mar-2025
適用対象
- Windchill Bulk Migrator 4.0 to 13.0
- Microsoft SQL Server
説明
- SQL Server で事前ロード検証がハングする
- SQLProcessUtilization が非常に高い (CPU 使用率が高い/急上昇)
- CXPACKET待機タイプは非常に高い
- 一時停止ステータスと CXPACKET 待機タイプのアクティブ SQL:
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
最新バージョンはこちらを参照ください CS363890