Repeating CheckoutLink query during checkout in Windchill PDMLink 11.2

• CheckoutLink query repeated 877 times during a single checkout:

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.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),CheckoutLink A1 
  WHERE ((A0.statecheckoutInfo <> @P0)) 
    AND ((A0.markForDeleteA2 = 0) 
    AND (A1.markForDeleteA2 = 0)) 
    AND ((A1.idA3B5 = A0.idA2A2) 
    AND (A1.idA3A5 = @P1))

• Stack trace shows above query comes from wt.vc.wip.StandardWorkInProgressService.workingCopyOf():

"ajp-nio-127.0.0.1-8011-exec-28" Id=25274 RUNNABLE (in native)
      Blocked (cnt): 91; Waited (cnt): 295
  at java.net.SocketInputStream.socketRead0(Native Method)
  at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  at java.net.SocketInputStream.read(SocketInputStream.java:171)
  at java.net.SocketInputStream.read(SocketInputStream.java:141)
  at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:1009)
  at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:997)
  at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
  at sun.security.ssl.InputRecord.read(InputRecord.java:503)
  at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983)
  at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:940)
  at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)
  at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1983)
  at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6494)
  at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7738)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:546)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:401)
  at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:582)
  at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:540)
  at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282)
  at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
  at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
  at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837)
  at wt.pds.SQLDatabasePds.expandLink(SQLDatabasePds.java:3818)
  at wt.pds.SQLDatabasePds.expand(SQLDatabasePds.java:663)
  at wt.pom.PersistentObjectManager.expand(PersistentObjectManager.java:1409)
  at wt.fc.StandardPersistenceManager.expand(StandardPersistenceManager.java:3121)
  at wt.fc.StandardPersistenceManager.navigate(StandardPersistenceManager.java:489)
  at sun.reflect.GeneratedMethodAccessor1033.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
  at com.sun.proxy.$Proxy14.navigate(Unknown Source)
  at wt.vc.wip.StandardWorkInProgressService.workingCopyOf(StandardWorkInProgressService.java:1713)
  at sun.reflect.GeneratedMethodAccessor1073.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
  at com.sun.proxy.$Proxy42.workingCopyOf(Unknown Source)
  at com.ptc.netmarkets.projmgmt.NmProjMgmtHelper.getWorkingCopyOf(NmProjMgmtHelper.java:2424)
  at com.ptc.netmarkets.projmgmt.NmProjMgmtHelper.getDeliverables(NmProjMgmtHelper.java:2263)
  at com.ptc.netmarkets.projmgmt.StandardNmProjMgmtService$19.notifyVetoableEvent(StandardNmProjMgmtService.java:9376)
  at wt.events.StandardKeyedEventBranch.intDispatchEvent(StandardKeyedEventBranch.java:320)
  at wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent(StandardKeyedEventBranch.java:268)
  at wt.events.StandardKeyedEventDispatcher.intDispatchEvent(StandardKeyedEventDispatcher.java:306)
  at wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent(StandardKeyedEventDispatcher.java:244)
  at wt.services.StandardManagerService.intDispatchVetoableEvent(StandardManagerService.java:412)
  at wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent(StandardManagerService.java:314)
  at wt.vc.wip.StandardWorkInProgressService.dispatchVetoableMultiObjectEvent(StandardWorkInProgressService.java:361)
  at wt.vc.wip.StandardWorkInProgressService.checkoutMap(StandardWorkInProgressService.java:2411)
  at wt.vc.wip.StandardWorkInProgressService.checkoutMap(StandardWorkInProgressService.java:2217)
  at wt.vc.wip.StandardWorkInProgressService.checkout(StandardWorkInProgressService.java:1177)
  at sun.reflect.GeneratedMethodAccessor1659.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
  at com.sun.proxy.$Proxy42.checkout(Unknown Source)
  at wt.epm.workspaces.WorkspaceCheckoutManager.checkout(WorkspaceCheckoutManager.java:188)
  at wt.epm.workspaces.EPMStandardWorkspaceManager.checkout(EPMStandardWorkspaceManager.java:477)
  at sun.reflect.GeneratedMethodAccessor1918.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
  at com.sun.proxy.$Proxy220.checkout(Unknown Source)
  at com.ptc.windchill.uwgm.proesrv.action.AddToWorkspaceAction.reservedCheckout(AddToWorkspaceAction.java:527)
  at com.ptc.windchill.uwgm.proesrv.action.AddToWorkspaceAction.checkoutToWorkspace(AddToWorkspaceAction.java:475)
  at com.ptc.windchill.uwgm.proesrv.action.AddToWorkspaceAction.executeAction(AddToWorkspaceAction.java:1538)
  at com.ptc.windchill.uwgm.proesrv.action.UwgmAction.execute(UwgmAction.java:84)
  at com.ptc.windchill.uwgm.proesrv.request.AddToWorkspaceRequest.executeRequest(AddToWorkspaceRequest.java:208)
  at com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.dispatchRequest(StandardRequestDispatcher.java:1277)
  at com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests(StandardRequestDispatcher.java:1014)
  at com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute(UwgmTransactionExecuterImpl.java:109)
  at com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction(UwgmTransactionExecuterImpl.java:59)
  at com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction(ProeService.java:111)
  at com.ptc.windchill.uwgm.proesrv.ProeService.execute(ProeService.java:87)
  at com.ptc.windchill.uwgm.soap.impl.uwgm.ProEServiceHandler.doExecute(ProEServiceHandler.java:115)
  at com.ptc.windchill.uwgm.soap.impl.uwgm.Service_i.execute(Service_i.java:159)
  at com.ptc.windchill.uwgm.soap.impl.uwgm.Service_aux.execute(Service_aux.java:46)
  at sun.reflect.GeneratedMethodAccessor2381.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.infoengine.procunit.webject.WebjectProcessor.invokeWebject(WebjectProcessor.java:573)
  at com.infoengine.procunit.webject.WebjectProcessor.processTask(WebjectProcessor.java:210)
  at com.infoengine.SAK.Webject.invoke(Webject.java:491)
  at com.infoengine.SAK.ExternalWebject.invoke(ExternalWebject.java:119)
  at com.infoengine.compiledTasks.file.dsk01.ptc.Windchill.tasks.com.ptc.windchill.uwgm.execute$2exml.invoke(execute$2exml.java:71)
  at com.infoengine.SAK.Task.invoke(Task.java:1806)
  at com.infoengine.SAK.Task.invokeAndCheckExternalAccess(Task.java:1703)
  at wt.method.WTAdapterImpl.processTask(WTAdapterImpl.java:750)
  at wt.method.WTAdapterImpl.processRequest(WTAdapterImpl.java:523)
  at com.infoengine.procunit.adapter.Adapter.send(Adapter.java:199)
  at com.infoengine.SAK.Task.executeTaskRemotely(Task.java:2083)
  at com.infoengine.SAK.Task.invoke(Task.java:1740)
  at com.infoengine.SAK.Task.invoke(Task.java:1714)
  at com.infoengine.SAK.Task.executeTask(Task.java:1968)
  at com.infoengine.webject.mgt.DispatchTasks.invoke(DispatchTasks.java:631)
  at com.infoengine.SAK.ManagementWebject.invoke(ManagementWebject.java:81)
  at com.infoengine.soap.RPCHandler.execute(RPCHandler.java:1730)
  at com.infoengine.soap.RPCHandler.postProcess(RPCHandler.java:1318)
  at com.infoengine.soap.RPCHandler.postProcess(RPCHandler.java:1285)
  at com.infoengine.soap.RPCHandler.process(RPCHandler.java:644)
  at com.infoengine.soap.SOAPServlet.doPost(SOAPServlet.java:277)
  at com.ptc.core.adapter.server.impl.SimpleTaskDispatcherTunnel.doPost(SimpleTaskDispatcherTunnel.java:122)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at ...internalDoFilter()
  at ...doFilter()