Article - CS374954
The performance of normalizing WTDocument is very slow in Windchill Bulk Migrator
Modified: 18-Aug-2022
Applies To
- Windchill Bulk Migrator 12.1
- Microsoft SQL Server
Description
- The performance of normalizing WTDocument is very slow in WBM
- It spent more than 48 houses and still stuck on
- SQL below takes hours to execute
-
SELECT A258.MASTERORGANIZATION_NAME,A258.MASTEROBJECTNUMBER,XXXXXX,CONVERT(datetimeoffset , A258.CREATEDDATE, 120), CONVERT(datetimeoffset , A258.MODIFIEDDATE, 120),A258.TEAM,A258.TYPE,A258.WBMSOURCEDESCRIPTION,A258.WBMSOURCEIDENTIFIER FROM WTDOCUMENT A258 WHERE NOT EXISTS (Select 1 FROM INT_WTDOCUMENTVERSION A260,INT_WTDOCUMENTMASTER A8813 WHERE ISNULL(A8813.ORGANIZATION_NAME,'c4:4b:23:33######')=ISNULL(A258.MASTERORGANIZATION_NAME,'c4:4b:23:33######') AND ISNULL(A8813.OBJECTNUMBER,'c4:4b:23:33######')=ISNULL(A258.MASTEROBJECTNUMBER,'c4:4b:23:33######') AND ISNULL(A8813.CONTAINERTYPE,'c4:4b:23:33######')=ISNULL(A258.MASTERCONTAINERTYPE,'c4:4b:23:33######') AND ISNULL(A8813.CONTAINER,'c4:4b:23:33######')=ISNULL(A258.MASTERCONTAINER,'c4:4b:23:33######') AND ISNULL(A8813.CONTAINER_ORGANIZATION_NAME,'c4:4b:23:33######')=ISNULL(A258.MASTERCONTAINER_ORG_NAME,'c4:4b:23:33######') AND ISNULL(A8813.WBMSOURCEIDENTIFIER,'c4:4b:23:33######')=ISNULL(A258.MASTERWBMSOURCEIDENTIFIER,'c4:4b:23:33######') AND ISNULL(A260.MASTERREFERENCE,0)=ISNULL(A8813.SEQUENCENUMBER,0) AND ISNULL(A260.REVISION,'c4:4b:23:33:b3:98:45:40:5f:5d:40:1b:b1:3d:35:7f:b5:b1:bd:d6:')=ISNULL(A258.REVISION,'c4:4b:23:33:b3:98:45:40:5f:5d:40:1b:b1:3d:35:7f:b5:b1:bd:d6:') );
This is a printer-friendly version of Article 374954 and may be out of date. For the latest version click CS374954