Getting Following ERROR but not generating any logs for that.
EBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Query to be run - SELECT staging.SEQUENCENUMBER AS SEQUENCENUMBER FROM INT_WTDOCUMENTVERSION staging WHERE staging.MIGRATED =50 AND staging.SEQUENCENUMBER IN (SELECT A278.SEQUENCENUMBER
FROM INT_WTDOCUMENTVERSION A278
INNER JOIN INT_WTDOCUMENTMASTER A71 ON A278.MASTERREFERENCE=A71.SEQUENCENUMBER WHERE A71.BATCH_ID=1
)
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Releasing Connection from staging Queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connection added back to queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connections with Staging database after releasing one Connection 15
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Getting Connection
INFO : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Total Connections with Staging database are: 15
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Staging live connections 3
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Query to be run - SELECT staging.SEQUENCENUMBER AS SEQUENCENUMBER FROM INT_WTDOCUMENTMASTER staging WHERE staging.MIGRATED =50 AND staging.SEQUENCENUMBER IN (SELECT A71.SEQUENCENUMBER
FROM INT_WTDOCUMENTMASTER A71 WHERE A71.BATCH_ID=1
)
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Releasing Connection from staging Queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connection added back to queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connections with Staging database after releasing one Connection 15
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Getting Connection
INFO : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Total Connections with Staging database are: 15
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Staging live connections 3
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Query to be run - SELECT staging.SEQUENCENUMBER AS SEQUENCENUMBER FROM INT_WTDOCUMENT staging WHERE staging.MIGRATED =50 AND staging.SEQUENCENUMBER IN (SELECT A280.SEQUENCENUMBER
FROM INT_WTDOCUMENT A280
INNER JOIN INT_WTDOCUMENTVERSION A12931 ON A280.VERSIONREFERENCE=A12931.SEQUENCENUMBER
INNER JOIN INT_WTDOCUMENTMASTER A71 ON A12931.MASTERREFERENCE=A71.SEQUENCENUMBER WHERE A71.BATCH_ID=1
)
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Releasing Connection from staging Queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connection added back to queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connections with Staging database after releasing one Connection 15
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Calling service to find source and target object map...
WARN : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - No result from the server!
WARN : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Nothing is return from the process thread!
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Releasing Connection from staging Queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connection added back to queue
DEBUG : com.ptc.windchill.migration.wbm.util.ReconcilationHelper - Connections with Staging database after releasing one Connection 15
16/02/2023 11:50:21 INFO core.CIOTHandler - Start processing: [WTDocument]
16/02/2023 11:50:21 INFO core.CIOTHandler - Start processing definition: com.ptc.wbm.worm.core.Definition|1509890151|General|[Container=com.ptc.wbm.worm.core.Worm|604990529|WTDOCUMENT|Default]
16/02/2023 11:50:21 INFO raw.CIOTRawDataHandler - WTDocument loaderQuery:SELECT A71.DOCTYPE
,A71.NAME
,A71.SERIES
,A71.CONTAINER_ORGANIZATION_NAME
,A71.CONTAINERTYPE
,A71.CONTAINER
,A71.ORGANIZATION_NAME
,A71.CREATEDDATE
,A71.MODIFIEDDATE
,A71.OBJECTNUMBER
,A71.BATCH_ID
,A71.WBMSOURCEDESCRIPTION
,A71.WBMSOURCEIDENTIFIER
,A71.MIGRATED
,A278.MASTERREFERENCE
,A278.REVISION
,A278.MIGRATED
,A280.DEPARTMENT
,A280.DESCRIPTION
,A280.DOCTYPE
,A280.VERSIONREFERENCE
,A280.TITLE
,A280.FOLDERPATH
,A280.FORMAT
,A280.ITERATION
,A280.ITERATIONNOTE
,A280.CREATEDBY
,A280.MODIFIEDBY
,A280.LIFECYCLE
,A280.LIFECYCLESTATE
,A280.CREATEDDATE
,A280.MODIFIEDDATE
,A280.TEAM
,A280.TYPE
,A280.SEQUENCENUMBER
,A280.WBMSOURCEDESCRIPTION
,A280.WBMSOURCEIDENTIFIER
,A280.MIGRATED
FROM INT_WTDOCUMENT A280
INNER JOIN INT_WTDOCUMENTVERSION A278 ON A280.VERSIONREFERENCE=A278.SEQUENCENUMBER
INNER JOIN INT_WTDOCUMENTMASTER A71 ON A278.MASTERREFERENCE=A71.SEQUENCENUMBER WHERE A71.BATCH_ID=1 AND (A280.MIGRATED IN (0,1,52)) AND (A278.MIGRATED IN (0,52,5,7,70,72,9,90,92)) AND (A71.MIGRATED IN (0,52,5,7,70,72,9,90,92))
ORDER BY MASTERREFERENCE,VERSIONREFERENCE
