アーティクル - CS329748
PublisherQueueのサイズがWindchill PDMLinkでのファイル名変更のパフォーマンスに影響するのはなぜですか？
修正日: 28-Aug-2025
適用対象
- Windchill PDMLink 11.1 to 13.0
説明
- CAD ドキュメント/EPM ドキュメントの名前を変更するとパフォーマンスが低下する
- キュー管理でPublisherQueueをクリアした後、速度が大幅に向上しました。
- PublisherQueueと名前変更の関係は何ですか？
- 主要なコンテンツとしてWordファイルを使用してWTDocumentを作成すると、サーバーで数分かかる
- 時間の大部分は、 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%]
最新バージョンはこちらを参照ください CS329748