Article - CS408736
Unable to extract WTDocument ContentMetadata with message "No wt.doc.WTDocument|CONTENT objects to extract" when using Windchill Bulk Migrator
Modified: 11-Jan-2024
Applies To
- Windchill Bulk Migrator 12.0.2.5
Description
- Unable to extract WTDocument ContentMetadata with message "No wt.doc.WTDocument|CONTENT objects to extract"
- Extraction Report shows that there are some WTDocument FILECONTENT present in Source Windchill environment
- Below message is observed in Extraction Server log :
[RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO util.WBMMigrationSourceSitHelper - Migration source site information already exist. [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO wbmutil.CommonConnectionPool - Total Connections with Staging database are: 10 [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionCache - Initialized WBM session cache [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - ### ENTER: Registering session:637828 for type:wt.doc.WTDocument|CONTENT [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - Entry not Found for type:wt.doc.WTDocument|CONTENT [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - ### EXIT: Registering session:637828 for type:wt.doc.WTDocument|CONTENT [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - ### ENTER: Unregistering session:637828 from cache for type:wt.doc.WTDocument|CONTENT [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - Removing the entry, threadcount is 0 [RMI TCP Connection(17)-xxx.xx.xxx.xx] INFO session.WBMSessionServerHelper - ### Exit: Unregistered session:637828 for type:wt.doc.WTDocument|CONTENT
- Below message is observed in Extraction Client log :
[main] INFO client.Extractor - *******************No wt.doc.WTDocument|CONTENT objects to extract**************************
[main] INFO wbmutil.CommonConnectionPool - Total Connections with Staging database are: 10
[main] INFO wbmutil.CommonConnectionPool - Total Connections with Staging database are: 10
[main] INFO wbmutil.CommonConnectionPool - Total Connections with Staging database are: 10
[main] INFO wbmutil.CommonConnectionPool - Total Connections with Windchill database are: 10
[main] INFO sql.ExtractionFailureSqlHelper - creating failure lower boundary timestamp to list of failure ids map
[main] INFO wbmutil.CommonConnectionPool - Total Connections with Staging database are: 10
[main] INFO extractor.ExtractedClassStatistics -
******************************************************************************************************************************
Extraction Statistics for the Object Type:wt.doc.WTDocument(FILECONTENT)
Processed Items Count :0
Staged Items count :0
Filtered Items count :0
Failed object count :0
Finished extraction. You can see more details by running reports.
******************************************************************************************************************************
- Below is the Extraction query captured from client log :
WITH cont as ( select con.idA2A2 idA2A2, con.namecontainerInfo CONTAINER_NAME, con.classnameA2A2 CONTAINER_TYPE, wtorg.name CONTAINER_ORGANIZATION_NAME from dbuser.PDMLinkProduct con join WTOrganization wtorg on con.idA3organizationReference=wtorg.idA2A2 union all select con.idA2A2 idA2A2, con.namecontainerInfo CONTAINER_NAME, con.classnameA2A2 CONTAINER_TYPE, wtorg.name CONTAINER_ORGANIZATION_NAME from dbuser.WTLibrary con join WTOrganization wtorg on con.idA3organizationReference=wtorg.idA2A2 union all select con.idA2A2 idA2A2, con.namecontainerInfo CONTAINER_NAME, con.classnameA2A2 CONTAINER_TYPE, wtorg.name CONTAINER_ORGANIZATION_NAME from dbuser.Project2 con join WTOrganization wtorg on con.idA3organizationReference=wtorg.idA2A2 union all select con.idA2A2 idA2A2, con.namecontainerInfo CONTAINER_NAME, con.classnameA2A2 CONTAINER_TYPE, wtorg.name CONTAINER_ORGANIZATION_NAME from dbuser.ExchangeContainer con join WTOrganization wtorg on con.idA3organizationReference=wtorg.idA2A2 union all select con.idA2A2 idA2A2, con.namecontainerInfo CONTAINER_NAME, con.classnameA2A2 CONTAINER_TYPE, wtorg.name CONTAINER_ORGANIZATION_NAME from dbuser.OrgContainer con join WTOrganization wtorg on con.idA3organizationReference=wtorg.idA2A2 ) select * from (select * from (SELECT AD.classnamekeyA5 storageClass, SITE.url SRCSITEURL,FVV.name SRCVAULTNAME,MOUNT.path SRCFILEPATH , lower(TO_CHAR(FVI.UNIQUESEQUENCENUMBER,'FM0XXXXXXXXXXXXX')) SRCFILENAME,AD.fileSize SRCFILESIZE,AD.fileVersion SRCFILEVERSION,AD.streamId UNIQUECONTENTIDENTIFIER,AD.fileName FILENAME,DATA.OBJECTNUMBER OBJECTNUMBER,DATA.OBJECTVERSION HOLDERREVISION,DATA.OBJECTITERATION HOLDERITERATION,DATA.DOCUMENTID IdentityId,DATA.CLASSNAME HOLDERCLASSNAME,org.name ORGANIZATION_NAME,AD.role,AD.category,AD.classnameA2A2 TYPE,AD.classnameA2A2 SOURCECLASS ,AD.idA2A2 SOURCEID ,AD.description DESCRIPTION,AD.comments COMMENTS,creator.name CREATEDBY ,AD.createStampA2 CREATEDDATE,modifier.name MODIFIEDBY,AD.modifyStampA2 MODIFIEDDATE, HC.modifyStampA2 modifyStamp,cont.CONTAINER_NAME CONTAINER, cont.CONTAINER_TYPE CONTAINERTYPE, cont.CONTAINER_ORGANIZATION_NAME CONTAINER_ORGANIZATION_NAME FROM dbuser.ApplicationData AD left outer join dbuser.WTUser modifier ON modifier.idA2A2 = AD.idA3C4,dbuser.HolderToContent HC,dbuser.FvItem FVI,dbuser.FvFolder FOL,dbuser.FvVault FVV,dbuser.FvHost FVH,dbuser.Site SITE,dbuser.FvMount MOUNT,dbuser.WTUser creator,dbuser.WTOrganization org,cont , (SELECT D.classnameA2A2 CLASSNAME,M.WTDocumentNumber OBJECTNUMBER,D.versionIdA2versionInfo OBJECTVERSION,D.iterationIdA2iterationInfo OBJECTITERATION,M.idA3organizationReference ORG,M.idA3containerReference containerRef,D.idA2A2 DOCUMENTID,D.modifyStampA2 modifyStamp FROM dbuser.WTDocumentMaster M,dbuser.WTDocument D, dbuser.Cabinet cabinet WHERE D.idA3masterReference = M.idA2A2 AND M.markForDeleteA2 = 0 AND D.markForDeleteA2 = 0 AND D.oneOffVersionIdA2oneOffVersi is null AND D.idA3A2folderingInfo= cabinet.idA2A2 AND cabinet.personalCabinet=0 and D.statecheckoutInfo in ('c/i','c/o','sb c/o','term')) DATA WHERE DATA.DOCUMENTID = HC.idA3A5 AND FVH.hostName in ('xyz.ptc.com') AND HC.idA3B5=AD.idA2A2 AND AD.idA3A5=FVI.idA2A2 AND FVI.idA3A4=FOL.idA2A2 AND FOL.idA2A2=MOUNT.idA3A5 AND FOL.idA3A5=FVV.idA2A2 and FVV.idA3A5=SITE.idA2A2 AND MOUNT.idA3B5=FVH.idA2A2 AND FVH.idA3A5=SITE.idA2A2 and AD.idA3A4=creator.idA2A2 and DATA.ORG=org.idA2A2 and cont.idA2A2 = DATA.containerRef AND (HC.modifyStampA2 between TIMESTAMP '2024-01-11 07:47:09.199' and TIMESTAMP '2024-01-11 09:13:58.761' or DATA.modifyStamp between TIMESTAMP '2024-01-11 07:47:09.199' and TIMESTAMP '2024-01-11 09:13:58.761') UNION ALL SELECT AD.classnamekeyA5 storageClass, null SRCSITEURL,null SRCVAULTNAME,null SRCFILEPATH,null SRCFILENAME ,AD.fileSize SRCFILESIZE,AD.fileVersion SRCFILEVERSION,AD.streamId UNIQUECONTENTIDENTIFIER,AD.fileName FILENAME,DATA.OBJECTNUMBER OBJECTNUMBER,DATA.OBJECTVERSION HOLDERREVISION,DATA.OBJECTITERATION HOLDERITERATION,DATA.DOCUMENTID IdentityId,DATA.CLASSNAME HOLDERCLASSNAME,org.name ORGANIZATION_NAME,AD.role,AD.category,AD.classnameA2A2 TYPE,AD.classnameA2A2 SOURCECLASS ,AD.idA2A2 SOURCEID ,AD.description DESCRIPTION,AD.comments COMMENTS,creator.name CREATEDBY ,AD.createStampA2 CREATEDDATE,modifier.name MODIFIEDBY,AD.modifyStampA2 MODIFIEDDATE, HC.modifyStampA2 modifyStamp,cont.CONTAINER_NAME CONTAINER, cont.CONTAINER_TYPE CONTAINERTYPE, cont.CONTAINER_ORGANIZATION_NAME CONTAINER_ORGANIZATION_NAME FROM dbuser.ApplicationData AD left outer join dbuser.WTUser modifier ON modifier.idA2A2 = AD.idA3C4,dbuser.HolderToContent HC,dbuser.WTUser creator,dbuser.WTOrganization org,cont , (SELECT D.classnameA2A2 CLASSNAME,M.WTDocumentNumber OBJECTNUMBER,D.versionIdA2versionInfo OBJECTVERSION,D.iterationIdA2iterationInfo OBJECTITERATION,M.idA3organizationReference ORG,M.idA3containerReference containerRef,D.idA2A2 DOCUMENTID,D.modifyStampA2 modifyStamp FROM dbuser.WTDocumentMaster M,dbuser.WTDocument D, dbuser.Cabinet cabinet WHERE D.idA3masterReference = M.idA2A2 AND M.markForDeleteA2 = 0 AND D.markForDeleteA2 = 0 AND D.oneOffVersionIdA2oneOffVersi is null AND D.idA3A2folderingInfo= cabinet.idA2A2 AND cabinet.personalCabinet=0 AND D.statecheckoutInfo in ('c/i','c/o','sb c/o','term')) DATA WHERE DATA.DOCUMENTID = HC.idA3A5 AND HC.idA3B5=AD.idA2A2 and AD.idA3A4=creator.idA2A2 and DATA.ORG=org.idA2A2 and cont.idA2A2 = DATA.containerRef and AD.classnamekeyA5 != 'wt.fv.FvItem' AND (HC.modifyStampA2 between TIMESTAMP '2024-01-11 07:47:09.199' and TIMESTAMP '2024-01-11 09:13:58.761' or DATA.modifyStamp between TIMESTAMP '2024-01-11 07:47:09.199' and TIMESTAMP '2024-01-11 09:13:58.761')) tab1, ( select CASE WHEN RM.IS_FILEBASED is null THEN 1 ELSE RM.IS_FILEBASED END AS IS_FILEBASED, AD.ida2a2 AD_ida2a2 from dbuser.APPLICATIONDATA AD inner join dbuser.FVITEM FVI on AD.IDA3A5=FVI.IDA2A2 inner join dbuser.FVFOLDER FVF on FVI.IDA3A4=FVF.IDA2A2 left outer join dbuser. ROOTFOLDER RF on FVF.IDA3B5=RF.IDA2A2 left outer join (select ida3b5, CASE WHEN MOUNTTYPE='fileBased' THEN 1 WHEN MOUNTTYPE is null THEN 1 ELSE 0 END as IS_FILEBASED from dbuser.ROOTMOUNT group by ida3b5, MOUNTTYPE) RM on RM.IDA3B5=RF.IDA2A2) tab2 where tab1.SOURCEID=tab2.AD_ida2a2) tab where 1=1 order by IdentityId
- WTDocument Content extraction was attempted second time
This is a printer-friendly version of Article 408736 and may be out of date. For the latest version click CS408736