1. Home
  2. Support
Article - CS329748

Why does the size of PublisherQueue effect performance of renaming file in Windchill PDMLink

Modified: 28-Aug-2025   


Applies To

  • Windchill PDMLink 11.1 to 13.0

Description

  • Poor performance when renaming CAD Document/EPMDocument
    • It became much faster after clearing the PublisherQueue in Queue Management
  • What is the relation between PublisherQueue and rename
  • It takes server minutes when creating WTDocument with a word file as the primary content
  • Majority of the time is spent querying database for ProcessingQueue:
SELECT 'wt.queue.ProcessingQueue',A0.administrativeLockIsNull,A0.typeadministrativeLock,A0.deleteWhenEmpty,A0.classnamekeydomainRef,A0.idA3domainRef,A0.enabled,A0.exceptionRetries,A0.executionHost,A0.inheritedDomain,A0.interval,A0.lastStateSet,A0.maxEntryExecutionTimeThresho,A0.name,A0.classnamekeyA5,A0.idA3A5,A0.queueState,A0.randomAccessQueue,A0.removeFailedEntires,A0.securityLabels,A0.stopDeleteRequest,A0.stopInterruptWaitEntryComple,A0.stopWaitEntryCompletion,A0.suspendDuration,A0.suspendUntil,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.totalEntries,A0.totalNotificationThreshold,A0.waitingEntries,A0.waitingNotificationThreshold,'wt.queue.QueueEntry',A1.administrativeLockIsNull,A1.typeadministrativeLock,A1.args,A1.blob$args,A1.classnamekeydomainRef,A1.idA3domainRef,TO_CHAR(A1.endExec,'dd mm yyyy hh24:mi:ss'),A1.entryNumber,A1.entryOwnerIsNull,A1.classnamekeyB5,A1.idA3B5,A1.failureCount,A1.inheritedDomain,TO_CHAR(A1.datelock,'dd mm yyyy hh24:mi:ss'),A1.classnamekeyA2lock,A1.idA3A2lock,A1.notelock,A1.classnamekeyA5,A1.idA3A5,A1.securityLabels,TO_CHAR(A1.startExec,'dd mm yyyy hh24:mi:ss'),A1.statusInfoIsNull,A1.codeC5,A1.messageC5,TO_CHAR(A1.rescheduleTimeC5,'dd mm yyyy hh24:mi:ss'),A1.targetClass,A1.targetMethod,TO_CHAR(A1.createStampA2,'dd mm yyyy hh24:mi:ss'),A1.markForDeleteA2,TO_CHAR(A1.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A1.idA2A2,A1.updateCountA2,TO_CHAR(A1.updateStampA2,'dd mm yyyy hh24:mi:ss') 
FROM ProcessingQueue A0,QueueEntry A1 
  WHERE ((A0.name LIKE 'PublisherQueue%L') 
    AND (A0.idA2A2 = A1.idA3A5)) 
ORDER BY A0.name DESC,A1.entryNumber DESC


 com.ptc.windchill.uwgm.cadx.request.JSTableRequestProcessor.runTask [100%]
 . com.ptc.windchill.uwgm.cadx.request.UwgmRequestProcessor.process [100%]
 . | com.ptc.windchill.uwgm.proesrv.ProeService.execute [100%]
 . | . com.ptc.windchill.uwgm.proesrv.ProeService.executeTransaction [100%]
 . | . | com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.executeTransaction [100%]
 . | . | . com.ptc.windchill.uwgm.proesrv.UwgmTransactionExecuterImpl.execute [100%]
 . | . | . | com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.scanRequests [100%]
 . | . | . | . com.ptc.windchill.uwgm.proesrv.StandardRequestDispatcher.dispatchRequest [100%]
 . | . | . | . | com.ptc.windchill.uwgm.proesrv.request.RenameL01Request.executeRequest [100%]
 . | . | . | . | . com.ptc.windchill.uwgm.proesrv.action.UwgmAction.execute [100%]
 . | . | . | . | . | com.ptc.windchill.uwgm.proesrv.action.ChangeCADNameAction.executeAction [100%]
 . | . | . | . | . | . com.sun.proxy.$Proxy325.changeCADName [100%]
 . | . | . | . | . | . | wt.services.ServiceFactory$ServerInvocationHandler.invoke [100%]
 . | . | . | . | . | . | . java.lang.reflect.Method.invoke [100%]
 . | . | . | . | . | . | . | sun.reflect.DelegatingMethodAccessorImpl.invoke [100%]
 . | . | . | . | . | . | . | . sun.reflect.NativeMethodAccessorImpl.invoke [100%]
 . | . | . | . | . | . | . | . | sun.reflect.NativeMethodAccessorImpl.invoke0 [100%]
 . | . | . | . | . | . | . | . | . wt.epm.EPMStandardDocumentManager.changeCADName [100%]
 . | . | . | . | . | . | . | . | . | wt.epm.EPMCADNameHelper.changeCADName [100%]
 . | . | . | . | . | . | . | . | . | . wt.epm.EPMCADNameHelper.setCADName [100%]
 . | . | . | . | . | . | . | . | . | . | com.sun.proxy.$Proxy382.changeIdentities [100%]
 . | . | . | . | . | . | . | . | . | . | . wt.services.ServiceFactory$ServerInvocationHandler.invoke [100%]
 . | . | . | . | . | . | . | . | . | . | . | java.lang.reflect.Method.invoke [100%]
 . | . | . | . | . | . | . | . | . | . | . | . sun.reflect.DelegatingMethodAccessorImpl.invoke [100%]
 . | . | . | . | . | . | . | . | . | . | . | . | sun.reflect.GeneratedMethodAccessor7602.invoke [100%]
 . | . | . | . | . | . | . | . | . | . | . | . | . wt.fc.StandardIdentityService.changeIdentities [100%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | wt.fc.StandardIdentityService.dispatchVetoableMultiObjectEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.services.StandardManagerService.dispatchVetoableMultiObjectEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.services.StandardManagerService.intDispatchVetoableEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.events.StandardKeyedEventDispatcher.dispatchVetoableMultiObjectEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.events.StandardKeyedEventDispatcher.intDispatchEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.events.StandardKeyedEventBranch.dispatchVetoableMultiObjectEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.events.StandardKeyedEventBranch.intDispatchEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.StandardPublishService$RepresentableEventListener.notifyVetoableMultiObjectEvent [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.StandardPublishService.processRepresentationUpdate [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.StandardPublishService.processRepresentationUpdateForTargets [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.StandardPublishService.processRepresentationUpdateForTargets [99.98%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.Publish.republishRepresentationsOf [99.95%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.Publish.republishRepresentation [99.95%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.Publish.republishRepresentation [99.95%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.Publish.republishRepresentation [99.95%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.Publish.executePublish [98.55%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.PublishQueueHelper.addPublishEntry [98.34%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.PublishQueueHelper.addPublishEntry [98.34%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.PublishQueueHelper.isDuplicatedJob [98.22%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . com.ptc.wvs.server.publish.PublishQueueHelper.getWaitingQueueEntries [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | com.ptc.wvs.server.publish.PublishQueueHelper.getWaitingQueueEntries [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.fc.StandardPersistenceManager.query [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.fc.StandardPersistenceManager.query [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.fc.StandardPersistenceManager._query [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | wt.pom.PersistentObjectManager.query [85.62%]
 . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . wt.pom.PersistentObjectManager.query [85.62%]
This is a printer-friendly version of Article 329748 and may be out of date. For the latest version click CS329748