Article - CS351004
Schedule QueueEntry with ScheduleItem in customized queue is slow to execute in Windchill PDMLink
Modified: 19-Aug-2021
Applies To
- Windchill PDMLink 11.0
Description
- In customized Schedule queue, entry with ScheduleItem is slow to execute
- The schedule runs with 5 seconds interval
- Followed CS108165 and CS223192 has no help
- The slow SQL and stack trace
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)
This is a printer-friendly version of Article 351004 and may be out of date. For the latest version click CS351004