WinRU Task RepairMasterWithDifferentContextRT Takes Hours to Complete

• WinRU Task RepairMasterWithDifferentContextRT has been running for many hours without completing
• The following queries are executing frequently, taking ~200ms per execution

SELECT 'wt.epm.EPMDocument',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.classnamekeyC10,A0.idA3C10,A0.authoringAppVersion,A0.classnamekeyB10,A0.idA3B10,A0.blob$entrySetadHocAcl,A0.blob$expressionData,A0.boxExtentsIsNull,A0.AxD10,A0.AyD10,A0.AzD10,A0.BxD10,A0.ByD10,A0.BzD10,A0.checkoutInfoIsNull,A0.statecheckoutInfo,A0.classnamekeycontainerReferen,A0.idA3containerReference,A0.dbKeySize,A0.derived,A0.description,A0.classnamekeydomainRef,A0.idA3domainRef,A0.entrySetadHocAcl,A0.eventSet,A0.expressionData,A0.extentsValid,A0.familyTableStatus,A0.classnamekeyA2folderingInfo,A0.idA3A2folderingInfo,A0.classnamekeyB2folderingInfo,
A0.idA3B2folderingInfo,A0.classnamekeyformat,A0.idA3format,A0.hasHangingChange,A0.hasPendingChange,A0.hasResultingChange,A0.hasSuspect,A0.hasVariance,A0.indexersindexerSet,A0.inheritedDomain,A0.iopStateinteropInfo,A0.stateinteropInfo,A0.branchIditerationInfo,A0.classnamekeyD2iterationInfo,A0.idA3D2iterationInfo,A0.classnamekeyE2iterationInfo,A0.idA3E2iterationInfo,A0.iterationIdA2iterationInfo,A0.latestiterationInfo,A0.classnamekeyB2iterationInfo,
A0.idA3B2iterationInfo,A0.noteiterationInfo,A0.classnamekeyC2iterationInfo,A0.idA3C2iterationInfo,A0.stateiterationInfo,A0.lengthScale,CONVERT(varchar,A0.datelock,120),A0.classnamekeyA2lock,A0.idA3A2lock,A0.notelock,A0.classnamekeymasterReference,A0.idA3masterReference,A0.maximumAllowed,A0.minimumRequired,A0.missingDependents,A0.oneOffVersionIdA2oneOffVersi,A0.classnamekeyA2ownership,A0.idA3A2ownership,A0.placeHolder,A0.referenceControlIsNull,
A0.geomRestrE10,A0.geomRestrRecursiveE10,A0.scopeE10,A0.violRestrictionE10,A0.revisionNumber,A0.classnamekeyrootItemReferenc,A0.idA3rootItemReference,A0.securityLabels,A0.atGatestate,
A0.classnamekeyA2state,A0.idA3A2state,A0.statestate,A0.teamIdIsNull,A0.classnamekeyteamId,A0.idA3teamId,A0.teamTemplateIdIsNull,A0.classnamekeyteamTemplateId,A0.idA3teamTemplateId,A0.enabledtemplate,A0.templatedtemplate,CONVERT(varchar,A0.createStampA2,120),A0.markForDeleteA2,CONVERT(varchar,A0.modifyStampA2,120),A0.idA2A2,A0.updateCountA2,CONVERT(varchar,A0.updateStampA2,120),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,
A0.verified,A0.versionIdA2versionInfo,A0.versionLevelA2versionInfo,A0.versionSortIdA2versionInfo,A0B.CADName,A0B.authoringApplication,A0B.collapsible,A0B.classnamekeycontainerReferen,
A0B.idA3containerReference,A0B.defaultUnit,A0B.docSubType,A0B.docType,A0B.genericType,A0B.globalID,A0B.name,A0B.documentNumber,A0B.classnamekeyorganizationRefe,A0B.idA3organizationReference,A0B.ownerApplication,A0B.series,CONVERT(varchar,A0B.createStampA2,120),A0B.markForDeleteA2,CONVERT(varchar,A0B.modifyStampA2,120),A0B.classnameA2A2,A0B.idA2A2,A0B.updateCountA2,CONVERT(varchar,A0B.updateStampA2,120),A0B.branchIdA2typeDefinitionRefe,A0B.idA2typeDefinitionReference 
FROM EPMDocument A0 INNER JOIN EPMDocumentMaster A0B ON (A0.idA3masterReference = A0B.idA2A2) 
  WHERE ((A0.branchIditerationInfo = :1 ) 
    AND (A0.latestiterationInfo = :2 )) 
    AND (A0.markForDeleteA2 = 0)

SELECT 'wt.iba.value.StringValue',A0.classnamekeyA5,A0.idA3A5,A0.hierarchyIDA6,A0.classnamekeyA6,A0.idA3A6,A0.classnamekeyA4,A0.idA3A4,CONVERT(varchar,A0.createStampA2,120),A0.markForDeleteA2,CONVERT(varchar,A0.modifyStampA2,120),A0.idA2A2,A0.updateCountA2,CONVERT(varchar,A0.updateStampA2,120),A0.value,A0.value2 
FROM StringValue A0 
  WHERE ((A0.idA3A4 = :1 ))

• Most of the time for the task is spent in the following stacktrace:

"RMI TCP Connection(29)-127.0.0.1" Id=432 daemon prio=5 RUNNABLE
      Blocked (cnt): 14; Waited (cnt): 4
  at app//wt.fc.jmx.TopSQLTraceTimingLogger.processEntry(TopSQLTraceTimingLogger.java:92)
  at app//wt.fc.jmx.AbstractTraceTimingLogger.addEndEntry(AbstractTraceTimingLogger.java:134)
  at app//wt.util.TraceTimingCompositeLogger.lambda$addEndEntry$1(TraceTimingCompositeLogger.java:41)
  at app//wt.util.TraceTimingCompositeLogger$$Lambda$459/0x00000007c103ec40.accept(Unknown Source)
  at [email protected]/java.util.concurrent.CopyOnWriteArrayList.forEach(CopyOnWriteArrayList.java:807)
  at app//wt.util.TraceTimingCompositeLogger.addEndEntry(TraceTimingCompositeLogger.java:41)
  at app//wt.util.TraceTimingResource.close(TraceTimingResource.java:65)
  at app//wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:629)
  at app//wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:544)
  at app//wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282)
  at app//wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
  at app//wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
  at app//wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880)
  at app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077)
  at app//wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986)
  at app//wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
  at app//wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
  at app//wt.vc.StandardVersionControlService.getLatestIteration(StandardVersionControlService.java:2643)
  at jdk.internal.reflect.GeneratedMethodAccessor619.invoke(Unknown Source)
  at [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
  at app//wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
  at app//com.sun.proxy.$Proxy61.getLatestIteration(Unknown Source)
  at app//wt.vc.MasterWithDifferentContextQuery.getFirstPDMIterationOfSharedObject(MasterWithDifferentContextQuery.java:154)
  at app//wt.vc.RepairMasterWithDifferentContextRT.processQueryResult(RepairMasterWithDifferentContextRT.java:157)
  at app//wt.vc.RepairMasterWithDifferentContextRT.runRepair(RepairMasterWithDifferentContextRT.java:103)
  at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
  at app//com.ptc.windchill.upgrade.updates.directives.MigratorMethod.invoke(MigratorMethod.java:131)
  at app//com.ptc.windchill.upgrade.updates.directives.LightWeightServiceDirective$Server.invokeLightWeightServiceApi(LightWeightServiceDirective.java:635)
  at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at [email protected]/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at [email protected]/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at [email protected]/java.lang.reflect.Method.invoke(Method.java:566)
  at app//wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:165)
  at app//wt.method.MethodResult.writeExternal(MethodResult.java:226)