アーティクル - CS363890

Windchill Bulk Migrator の SQL Server で事前ロード検証がハングする

修正日: 07-Mar-2025   


注記:ここに記載されている情報は、お客様の利便性向上のため機械翻訳ソフトを使用しています。PTCは、ここに記載されている情報の翻訳の正確性について、一切の責任を負いませんので、ご了承ください。英語の原文を参照するには、こちら。この機械翻訳に関する詳細は、こちら。
お知らせいただき、ありがとうございます。この機械翻訳をレビューします。

適用対象

  • 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