1. 主页
  2. 支持
技术文章 - CS351004

在自定义队列中使用 ScheduleItem 计划 QueueEntry 在 Windchill PDMLink 中执行缓慢

已修改: 22-Jun-2022   


注意：本文已使用机器翻译软件翻译，以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意， PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情，请单击 此处 。
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • Windchill PDMLink 11.0

说明

  • 在自定义的 Schedule 队列中，带有ScheduleItem的条目执行速度很慢
  • 计划以 5 秒的间隔运行
  • 跟着CS108165和CS223192没有帮助
  • 缓慢的 SQL 和堆栈跟踪
SELECT 'wt.scheduler.ScheduleHistory',TO_CHAR(A0.completionTime,'dd mm yyyy hh24:mi:ss'),....
FROM ScheduleHistory A0 
WHERE ((A0.idA3B4 = ?)) AND (A0.markForDeleteA2 = 0) 
ORDER BY A0.submissionTime DESC

wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:273)
wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:985)
wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008)
wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:655)
wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:407)
sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
com.sun.proxy.$Proxy18.find(Unknown Source)
wt.scheduler.ScheduleItem.getLatestSchedHistory(ScheduleItem.java:417)
wt.scheduler.StandardSchedulingService.executionKernel(StandardSchedulingService.java:1154)
wt.scheduler.StandardSchedulingService.executeScheduledItem(StandardSchedulingService.java:605)
sun.reflect.GeneratedMethodAccessor224.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
wt.queue.ScheduleQueueEntry.execute(ScheduleQueueEntry.java:264)
wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:336)
wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:457)
wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:280)
wt.queue.ScheduleQueueThread.run(ScheduleQueueThread.java:88)

wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:273)
wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076)
wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:985)
wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1972)
wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1123)
wt.scheduler.StandardSchedulingService.previousExecutingScheduleStatus(StandardSchedulingService.java:2228)
wt.scheduler.StandardSchedulingService.executionKernel(StandardSchedulingService.java:1165)
wt.scheduler.StandardSchedulingService.executeScheduledItem(StandardSchedulingService.java:605)
sun.reflect.GeneratedMethodAccessor224.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
wt.queue.ScheduleQueueEntry.execute(ScheduleQueueEntry.java:264)
wt.queue.ScheduleQueue.execEntry(ScheduleQueue.java:336)
wt.queue.ScheduleQueue.execEntries(ScheduleQueue.java:457)
wt.queue.ScheduleQueueThread.processReadyEntries(ScheduleQueueThread.java:280)
这是文章 351004 的 PDF 版本，可能已过期。最新版本 CS351004